Then H12:
Formula:
=ROUND(24*IF(WEEKDAY(A12,2)>5,0,IF(C12="",0,MIN(C12,19/24)-MAX(B12,7/24))+IF(F12="",0,MIN(F12,19/24)-MAX(E12,7/24))),2)
I12:
Formula:
=ROUND(24*IF(WEEKDAY(A12,2)>5,0,IF(C12="",0,MAX(0,C12-MAX(B12,19/24)))+IF(F12="",0,MAX(0,F12-MAX(E12,19/24)))),2)
J12:
Formula:
=ROUND(24*IF(WEEKDAY(A12,2)>5,0,IF(C12="",0,MAX(0,MIN(C12,7/24)-B12))+IF(F12="",0,MAX(0,MIN(F12,7/24)-E12))),
K12:
Formula:
=ROUND(24*IF(WEEKDAY(A12,2)<>6,0,IF(C12="",0,C12-B12)+IF(F12="",0,F12-E12)),2)
and similar but with day = 7 in L12
Bookmarks