Timesheets for hourly paid staff

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

Thanks, but thats how I got this far.

To clarify, I need to work out the amount of hours per week worked after 18:00 to midnight, to pay these at a different rate.

Regards
Jennii

Thanks for the response, I've uploaded the file.

Regards
Jennii

Wow, thanks. You're a gem!

It's almost perfect!!! - although the OT total is showing as 2:30 hours and the calculations on the other sheets need to say 2.5 hours. I think I can probably figure this. I'll play around with it...

It would be very helpful if you would explain your formula briefly, just so I learn something from this and don't bug you with the same sort of question.

Your help is most appreciated.

Regards
Jennii

Very helpful, thank you very much.

Regards
Jennii