» Creating a World Time Converter
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem:Finding the equivalent time for the city in cell C5 (Jerusalem) as that shown in cell D2 for the city in cell C2 (New York).
Solution:
1. Create a list of cities (column A) and their matching hourly difference (column B) from GMT (Greenwich Mean Time).
2. Use the VLOOKUP function as shown in the following formula in cell D5:
=(D2*24-VLOOKUP(C2,A2:B8,2,FALSE)+VLOOKUP(C5,A2:B8,2,FALSE))/24
Book Store:
Recommended Books:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Windows XP Annoyances
- A Mathematician Plays the Stock Market
- Monte Carlo Methods in Finance
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Accounting and Financial Fundamentals for Nonfinancial Executives
No comments have been submitted.
