LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 153
Default Calculating the difference, in hours, between two date/time intwo different time zon

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating diff between date/ time only between certain hours GMv1 Excel Discussion (Misc queries) 5 March 2nd 10 05:26 AM
Calculating diff between date/ time only between certain hours GMv1 Excel Discussion (Misc queries) 4 March 1st 10 09:56 AM
difference of date/time only calculating workingdays/hours Susanne Excel Worksheet Functions 4 February 5th 09 01:42 PM
calculating difference between date/time fields drew Excel Programming 19 July 14th 08 08:46 PM
Calculating Difference Between Start Date & Time And End Date & Ti Samwar Excel Discussion (Misc queries) 2 December 19th 05 12:42 PM


All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"