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

[annazet]

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:

=IFERROR(IF(C$4=MEDIAN(
INDEX(Time_start,MATCH((INDEX(Schedule!$J9:$AR9,MATCH(Date_dailyselected,Dates_schedule,0))),ShiftNames,0)),
INDEX(Time_end,MATCH((INDEX(Schedule!$J9:$AR9,MATCH(Date_dailyselected,Dates_schedule,0))),ShiftNames,0)),
C$4),
INDEX(Schedule_dpts,MATCH($CX5,Schedule_dpts,0)),0),0)

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!