formula to add/deduct an hour for travel [solved]

Hi,
I've already had someone have a crack at this for me but it's not ideal as it requires alteration of the formula itself to deduct time.

\1

Is there a formula that will simply allow me to enter "+1" or "-1" in the the time zone +/- field?

Thanks in advance for any suggestions

Hi unclejambo,

welcome to the forum.
Try using below formula for arrival:

=D4+TIME(HOUR(F5)+F4,MINUTE(F5),SECOND(F5))

Regards,
DILIPandey
<click on below * if this helps>

You are welcome unclejambo... cheers

Please mark this thread as [SOLVED]... thanks.


Regards,
DILIPandey
<click on below * if this helps>