Calculate actual business interruption hours from two time window

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

A1= issue start time
B1= issue end time
C1= agent shift start time
D1= agent shift end time
E1=? How to get the actual time of interruption from the above A1 to B1, final time should only from the window of C1 to D1.

Please help