Wage spreadsheet for hours

sorry to be a pain, there is one more little problem,
if a shift starts at 23:00 and goes through to 08:00 in the morning, the 2 hours past 06:00 should show as 2 hrs of day shift- in the formula you gave it shows all as night hours.

there must be a simpler way of working this out , even if there are extra columns to help

Hi Richard, can you have a look at the problem when you can please