Separating Hours Worked By Shift

[edgarsanchezjr]

I have three shifts that I need to separate hours worked into. Attached is a picture of what I am trying to do it includes the start and end times of the shifts.

 

[mole999]

Have a read at this thread and see if thats a good starting point > https://www.mrexcel.com/forum/excel-questions/1101548-shift-name-based-timestamp.html