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?