caculate workdays accurately

  • Thread starter Thread starter Derek Davlut
  • Start date Start date
D

Derek Davlut

I am uing the options pak with the networkdays function and would like to
calculate the number of days more accurately. Instead of 8 days I would like
8.235 for example.

09/25/03 2:00pm and 09/30/03 5:00pm how much time is between these two dates
minus the weekends?

Derek.
 
How do you define a workday? Is it more or less than 8 hours per
calendar day (and do you have shifts involved?)?

If your workday is from 9:00 am to 5:00 pm, you can use

=(NETWORKDAYS(A1, A2, holidays)- 2)/3 + TIME(17,0,0)-(A1-INT(A1)) +
(A2-INT(A2) - TIME(9,0,0))

or the slightly shorter and possibly more obscure:

=(NETWORKDAYS(A1,A2)-2)/3+TIME(17,0,0)-MOD(A1,1)+MOD(A2,1)-TIME(9,0,0
)
 
Back
Top