Measure Time (HH:mm) between dates excluding weekends

[Colmans]

Hi

I need to measure time between a start and end event in a workflow as this is a key KPI which I need to report on. The start and end times are shown in extended date form DD/MM/YY HH:MM. However, I need to exclude weekends and also set the working hours e.g 9am - 5pm. I'd also like to exclude public holidays, similar to the holidays component in the NETWORKDAYS function.

Thanks in advance for any help or advice.

 

[Legacy 143009]

Here is a nice article about this:

http://www.exceltactics.com/calculate-net-work-hours-using-networkdays/

You may download the sample sheet at the bottom of the page and play with it.