» 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 and Date2, 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)
Example:
Date1_______________Date2________________Result
4/4/2005 10:30______14/4/2005 19:12______200:42

Book Store:
Recommended Books:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Word 2002: The Complete Reference
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Special Edition Using Microsoft Access 2002
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
No comments have been submitted.


