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
 
Ad

Advertisements

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
 
Ad

Advertisements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top