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?

Seeing as you have a "set" time zone (PA) you could use a lookup table in conjunction with the formulas where the region/country could be looked up and dictate how many hours were +/- the PA time.

Hard to describe exactly how that would work without a working example workbook.

If you can provide that, I'm sure you'll get several people jump at the chance to help out.

S.

I will try to put together a workbook as you suggest and post it within the next couple days! This is the first assignment I've ever had dealing with date/time situations so I was not sure what would be needed. Thanks!

It doesn't have to be anything elaborate... just 3 or 4 country time differences and the basic layout should be enough to put us on the right path to getting your problem solved.

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

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