Calculating the difference, in hours, between two date/time in two different time zon

G

gmccray

I am trying to figure the difference in hours between two date tim
fields which involves different time zones. The one element that wil
never change is the one time zone will always be eastern tim
(philadelphia, pa, usa area). the others time zones will always b
ahead, for example to get the correct time in Austrailia, I would nee
to add 14 hours to the time here. Can you help?
example of dates; 07/13/12 @ 8am a shipment leaves Melbourne
Austrailia, it arrives in Phila, pa, USA, 07/15/12 @ 6am. How can
caluclate the elasped time between the two dates

Z

zvkmpw

I am trying to figure the difference in hours between two date time
fields which involves different time zones. The one element that will
never change is the one time zone will always be eastern time
(philadelphia, pa, usa area). the others time zones will always be
ahead, for example to get the correct time in Austrailia, I would need
to add 14 hours to the time here. Can you help?
example of dates; 07/13/12 @ 8am a shipment leaves Melbourne,
Austrailia, it arrives in Phila, pa, USA, 07/15/12 @ 6am. How can I
caluclate the elasped time between the two dates?

If A1 has the Philadelphia date/time to receive, B1 has the local time in the other time zone to send, and C1 has the number of hours ahead, then maybe this would work:
=A1-(B1+TIME(C1,0,0))
Format as desired, maybe
d h:mm
or
d "days" h:mm

G

gmccray

zvkmpw;1603781 said:
If A1 has the Philadelphia date/time to receive, B1 has the local tim
in the other time zone to send, and C1 has the number of hours ahead
then maybe this would work:
=A1-(B1+TIME(C1,0,0))
Format as desired, maybe
d h:mm
or
d "days" h:mm

Sorry it took so long getting back to you! It works Great!! Thanks