» Calculating the Number of Weekday Hours between Two Dates
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem:Calculating the number of hours between Date1 (A2) and Date2 (B2), excluding weekends.
Solution:
Use the NETWORKDAYS and MOD functions as shown in the following formula:
=NETWORKDAYS(A2,B2)-1-MOD(A2,1)+MOD(B2,1)
Book Store:
Recommended Books:
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Positioning: The Battle for Your Mind
- Business Analysis with Microsoft Excel (2nd Edition)
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Not-for-Profit Accounting Made Easy
No comments have been submitted.
