I'm pretty new to Excel, but have set up a timesheet for staff who sometimes work two variable shifts in one day.

Each employees hours are entered on a separate row as follows:
Five cells for each day - In, Out, In, Out (into which times are entered) and Total. The formula for the Total cell is =((D9-C9+(D9<C9))+(F9-E9+(F9<E9)))*24

This is repeated across the row for each day - with a WEEK TOTAL hours at the end which adds each of the daily totals. Hope this makes sense.

This Weekly Total cell is then linked to a new sheet. Again each employee has their own row. The linked cell is then multiplied by a cell with the hourly rate (say £6.00) inserted. So far this all works. However, I have been asked to pay the staff a different rate (£6.50) for evening work after 18:00 hours. How should I go about this?

Regards
Jenni