(SOLVED) Help with the IF function to calculate my ordinary hours for a timesheet

Hello
Im am having trouble with the IF function in excel 2010, for a template of a pay sheet.
I have been asked to -Using an IF statement in cell G8, calculate the ordinary hours component of total hours.
Using a nested IF statement in H8, calculate the overtime hours.
Using a nested IF statement in I8, calculate the time and a half (T ½) overtime hours
Using a nested IF statement in J8, calculate the double time hours.
The ordinary hours are 8hrs a day.
On weekdays, the first 2 overtime hours are paid at time and a half and remaining overtime hours are paid at double time rates.
Hours worked on Saturday are considered overtime, with the first 2 hours worked at time and a half rates and remaining overtime hours are paid at double time rates.

As you can see in my file i have just put the normal hours which is 7.30am - 4.00pm,with a 30 min lunch break, so i am not sure how to work out the IF functions.
I will be putting the employees actual hrs in my next spreadsheet, this will be the template i will use to calculate the info.

Can anyone please help me with this function,
I would greatly appreciate it!
natasha9794

I have attached my file!

Hi natasha,

I made a new file, the named cells in your table made it really hard to work with since they had [returns] on them. But my new file is placed in the same cells as you have them in your file. I hope you can take a look and work with it for your file. Hope it helps.

Hi natasha,
for your first overtime, it would be something like:

=if(ordinary hours<=0.33333,0,if(ordinary hours - 0.3333>0.083333,0.083333,ordinary hours - 0.333333)

remember that time has different values, 8 hours = 0.33333 and 2 hours = 0.083333

Alexis,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.