» 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 Guide to Understanding Financial Statements
- Advanced modelling in finance using Excel and VBA
- Finance and Accounting for Nonfinancial Managers
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Investing for Dummies, Third Edition
No comments have been submitted.
