Formula to categorize hours for shift differentials?

[Beefwellington100]

Hi all, I'm working on this timesheet project where I have to separate the hours an employee works because he gets paid at a higher rate during certain hours. The timesheet separates them into hours worked from 15:00 to 23:00 and hours worked from 23:00 to 7:00.

Is there a formula to separate the number of hours on the timesheet into these shift differentials? I've included a file showing what I mean.

 

[Luke M]

Per forum rules, please remember to include links to cross-posts:
https://www.excelforum.com/excel-ge...hours-in-shift-differentials.html#post5548785