Calculating Day Rate and Night Rate Hours on a Timesheet

Hello everybody

I'm new to the forum and a fairly basic Excel user so would really appreciate some advice on a problem I'm having with a timesheet.

As it stands now, my timesheet will accurately calculate total hours worked over any particular shift, even those spanning two days. However, I'd also like to include a calculation for my wages, and to do that I need to distinguish between day rate hours and night rate hours. Basically 6 am - 10 pm is classed as day rate while 10 pm - 6 am is night rate. I've been attempting to use an IF statement to work it out, but it's ended up too complicated for me.

Rather than explain what I've done so far, could somebody please look at where I'm up to and advise me on the best way forward? Any suggestions for improvement are also welcome. Thank you in anticipation.

Timesheet_Help.xlsx