» Creating a World Time Converter
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The One Page Business Plan: Start With a Vision, Build a Company!
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Marketing Plans
- Microsoft Access 2002 for Dummies
No comments have been submitted.
