» 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:
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Yes, You Can Time the Market!
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Financial Modeling - 2nd Edition
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
