Hours worked to be distributed into day shift, evening shift, and overnight shift

Arnaldo_Longart The following formulas seem to work for the three shifts:

=LET( time_in, $B2, time_out, $C2 + IF($C2 < time_in, 1, 0),
    shift_start, TIME(6,0,0), shift_end, TIME(18,0,0),
    MAX( 0, MIN(time_out, shift_end) - MAX(time_in, shift_start) )
    + IF( $C2 < time_in, MAX(0, $C2 - shift_start), 0 )
)
=LET( time_in, $B2, time_out, $C2 + IF($C2 < time_in, 1, 0),
    shift_start, TIME(18,0,0), shift_end, 1,
    MAX( 0, MIN(time_out, shift_end) - MAX(time_in, shift_start) )
)
=LET( time_in, $B2, time_out, $C2 + IF($C2 < time_in, 1, 0),
    shift_start, TIME(0,0,0), shift_end, TIME(6,0,0),
    MAX( 0, MIN(time_out, shift_end) - MAX(time_in, shift_start) )
    + IF( $C2 < time_in, MIN($C2, shift_end), 0 )
)

(Spaces are included for readability; they are not required.)

The attached workbook includes notes and more test data.