calculating penalty rates

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.

I can't seem to get this to work says there is an error and to remove circular reference which i did but still no joy.

OK I have attached a sheet of what i am looking for, no formulas - but if someone wants to help would be very grateful.

SUCCESS!!!!!

Thankyou so so so much everyone for your help