Night Time Differential - MOD Function

I've used this formula to determine hours worked between 22:00-06:00 and it works fine:
=MOD($S4-$R4,1)*24-($S4<$R4)*(22-6)-MEDIAN($S4*24,22,6)+MEDIAN($R4*24,22,6)

I'm now trying to calculate hours worked between 00:00 - 06:00, but it doesn't give me the correct value:
=MOD($S4-$R4,1)*24-($S4<$R4)*(0-6)-MEDIAN($S4*24,0,6)+MEDIAN($R4*24,0,6)

Also I have another column with the day of the week (column q). I want to show the hours worked on a Sunday only. What formula can be used for this?


Can you please help?

Please see attached sample workbook

for this instance, if no shifts start between midnight and 6 in the morning
=IF(INT(C3)>INT(B3),MIN(0.25,F3),0)*24

For sundays perhaps
=IF(WEEKDAY(B3)=1,MIN(C3,INT(B3)+1)-B3,0)*24+IF(WEEKDAY(C3)=1,C3-MAX(B3,INT(C3)),0)*24