|  

» Converting Time Values from One Time Zone to Another

Problem:

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
Screenshot // Converting Time Values from One Time Zone to Another
Converting Time Values from One Time Zone to Another

Rate This Tip
12 34 5
Rating: 2.27     Views: 114757
No comments have been submitted.
Name
Comment Title
Comments