Hi
I have a project that requires me to calculate the downtime of a machine only during working hours but I cannot include Sundays and holidays. Doing it manually is one way but is there any formula that I could use?
Weekdays working hours :
6am to 7pm
Saturday working hours
7am to 2pm
I need to have both start date and time in a cell and the end date and time in another cell
I have a project that requires me to calculate the downtime of a machine only during working hours but I cannot include Sundays and holidays. Doing it manually is one way but is there any formula that I could use?
Weekdays working hours :
6am to 7pm
Saturday working hours
7am to 2pm
I need to have both start date and time in a cell and the end date and time in another cell