» Calculating the Number of Hours per Month, Allowing for Daylight-Saving Shifts
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem:Calculating the number of hours that constitute each month (serial number) listed in column A.
One hour should be subtructed to April due to the shift to daylight saving time.
Similarly, one hour should be added from October's total due to the shift back to standard time.
Solution:
Use the DAY, EOMONTH, and DATE functions as shown in the following formula:
=DAY(EOMONTH(DATE(2005,A2,1),0))*24-(A2=4)+(A2=10)
Book Store:
Recommended Books:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Personal Finance for Dummies
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Accounting for Dummies
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
No comments have been submitted.
