» Calculating the Number of Weekday Hours between Two Dates
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Microsoft Windows XP Step by Step (With CD-ROM)
- Dictionary of Finance and Investment Terms
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Excel 2002 For Dummies®
- Adventure Capitalist: The Ultimate Road Trip
query
sameer goswami
In this function what is are the working hours being considered. In case it 24X7 working hours does this function suitable for use or there is some other function.Do we have the fexibility to decide the working hours in this function.
