Hi and welcome to the board

if your data layout does not match pb71 's example please attach a sample workbook.
Does the pay change starting at midnight, or is ti different if the shift goes from one day to the next?