Calcuate elapsed business date/time

Posted by Charles on December 07, 2001 6:52 AM

Greetings,

I am looking for a formula that will calculate elapsed business hours using a start date and time and an end date and time that will not include weekends or holidays.

Thanks

Posted by Mark w. on December 07, 2001 7:11 AM

Why not...

Use the NETWORKDAYS worksheet formula and multiply
the results by the length of a standard work day
(e.g., 8 hr/day). You'll need to install the
Analysis ToolPak to make this function available.