Hi,


I am trying to make a downtime log that tracks the amount of working hours a machine is out of service for.

I need to find a formula that will calculate the amount of working hours between the date/time the machine went out of service and the date/time the problem was recifitied and the machine began working again.

I've tried a number of different variations of the NETWORKDAYS and WORKDAYS formulas but I can't seem to get them to work perfectly.

The working hours are 8:00 - 16:00 (Monday-Thursday) and 8:00 - 13:00 (Friday). I need the formula to take these working hours into account as well as ignore weekend dates.

For example: If a machine was logged as being out of service at 13:00 on Thursday and came back into service at 10:00 the following Monday, the formula would return 10 hours. (13:00-16:00 on Thursday (3 hrs), 8:00 - 13:00 on Friday (5 hrs), ignore Saturday and Sunday, and 8:00 - 10:00 on Monday (2 hrs). So 3 + 5 + 2 = 10!)

Any help you can provide will be much appreciated!

Thanks

J