M
Mashuganah
I need to calculate the number of work hours between a start and end time.
The task may stretch across several days, including weekends and holidays.
Only the work hours should be counted. Work hours are 8 am - 5 pm, Mon - Fri.
How can this be done?
While NETWORKDAYS provides days, I need hours.
The task may stretch across several days, including weekends and holidays.
Only the work hours should be counted. Work hours are 8 am - 5 pm, Mon - Fri.
How can this be done?
While NETWORKDAYS provides days, I need hours.