exclude weekend days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to do a caculation in a report to find the number of hours between
two dates excluding weekend hours.

Start Date: 5/5/2005 9:31:19 AM
End Date: 5/9/2005 2:56:15 PM

Please help!
Cynthia
 
Hi DL,

Networkdays function returns the number of whole days, I need the number of
hours. Should I just multiple by 24 hours?
 
You would likely need to determin hours for the partial days then add this
to days*24 returned by the function.
ie the calculation would need to be in several parts
StartDay hours = SDH
EndDate hours = EDH
Networkdays = ND
Hours = SDH + EDH + (ND*24)
NB the above is only a general guide.
 
Back
Top