» Converting Time Values from One Time Zone to Another
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Listed in B1:E2 are several destinations and their hourly time difference with New York.
We want to convert the time value in B3 (New York local time) to the equivalent local time in each destination city.
Solution:
With destinations in C1:E1 and time differences in C2:E2, enter the following formula in C3, and copy across to E3:
=$B$3+(C2/24)*-1
Example:
EST____________GMT
12:00 AM_______5:00 AM
9:30 PM________2:30 AM
3:00 AM________8:00 AM
11:00 PM_______4:00 AM
Book Store:
Recommended Books:
- Financial Risk Manager Handbook, Second Edition
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Seven Habits Of Highly Effective People
in say, X1 (formatted to HH:MM) enter the time difference (e.g. 04:00 ), then formula in C12 is
A12 + $X$1. WHen the clocks change, or you need another time zone, all you need to change is X1.