» 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:
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- A Mathematician Plays the Stock Market
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Windows XP Annoyances
- How to Read A Financial Report
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.
