Determine if shift start/end time falls between times over 24h - more complex

Hi Everyone,
You know the time when you sit over one piece of formula and you are stuck? That's where I am at now.
I decided to reach for help.
I am working an a rota tool which also is to show who is present and when.
I am struggling with the daily breakdown.
I have shifts which start say, 20:00 on one date and end 8:00 on the following date.
I need to show those correctly on the "Daily" sheet.

Shifts worked : "Schedule" sheet
List of shifts and corresponding start/end times: "Shifts" sheet.

My current formula in C5 (same for C5:CT44) is:

Please Login or Register  to view this content.

attaching sample workbook.

I hope you will see above this and will be able to help or point me in the right direction.
Thank You!

Please change Shifts!
C16 to 01-01-1900 10:00:00
C17 to 01-01-1900 08:00:00

Please try at Shifts
E4
=(MIN(1,C4)-B4)*24

G4
=(C4-B4)*24