Calculating working shifts between two hours

I think it's working now...

Thx DO...

I'll also ask ddl to see his opinion

I use this version

=((B6>C6)*MEDIAN(0,C6-1/4,2/3)+MAX(0,MIN(11/12,C6+(B6>C6))-MAX(1/4,B6)))*24

That will give you hours between 06:00 (1/4) and 22:00 (11/12). 2/3 represents the duration of the day shift (11/12-1/4)