Hi

I am needing a spreadsheet that calculates my penalty rates. Basically i want to be able to put in the hours worked for whichever day and it automatically calculates how much is time and half and double time.

For Example, if i worked on a monday the first 8 hours are normal time, the next 2 hours are time and half and any hours after that are double time. - This is consistent mon - fri

On saturdays when i work it is time and half for the first 2 hours then double time the rest of the day.

I want to be able to just put the total hours in for each day and it then just works out how much is normal time, time and half and double time, can anyone help me pleeeeease.