|  

» Calculating the Number of Weekday Hours between Two Dates

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)

Rate This Tip
12 34 5
Rating: 3.53     Views: 17377
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments