I have the following sheet that calculates the downtime in branches based on the specific operating hours everyday.
The downtime ahould only take into account during the operating hours and should exclude hours of downtime during non operating hours.
In the example attached, the actual downtime during operating hours is 14 hours and 32 minutes. Although the downtime lasted from Feb 14 to Feb 16, the downtime hours that affected operating hours was 14 hours 32 minutes and not 36 hours and 8 minutes.
Is there anyway we could build a formula for this ?
Appreciate all the help.
I have a cross pots here: