Here's a challenge for the brainiacs!..Way beyond my excel skills I'm afraid.

Hi All,

I'm hoping someone out there might be able to help. I'm keeping track of the hours of my work in a spreadsheet that my employer has issued us, however I want a spreadsheet that doesn't just add up the hours (as it currently does) but calculate the breakdown of hours according to our pay structure.
I get paid at different rates for different times of the day and also penalty rates for weekend work.

So what formula do I have to enter to get my hours segregated based on the hours I have entered in on the spreadsheet.

Here's a breakdown of our pay rates

5am - 8pm Single Time
8pm - 5am - x1.5 Time for first 2 hrs & x2 thereafter.
Sat x1.5 Time for first 2 hrs & x2 Thereafter. Sunday x2 Time all day

You've probably guessed I'm not a computer wizz so any assistance would be greatly appreciated.

I have attached a sample of my fortnightly timesheet so you can see what I'm talking about. Hopefully it attached ok.

Many Thanks

RJRJ Timesheet excel.xlsm