Untitled.jpg

Start Date End Date Elapse time 1st Shift Start 1st Shift End 2nd Shift Start 2nd Shift End Day Off 1 Day Off 2 Actual Service Interruption Hours
10:00:00 AM 10:00:00 PM 12:00:00 9:00:00 AM 12:00:00 PM 1:00:00 PM 6:00:00 PM Monday Tuesday 0:00(Trying to find a formula to calculate the Actual Service Interruption Hours from Above scenario)

Thanks