CA Overtime Rules Timecard Calculator

HI THERE - I know what I want my spreadsheet to look like & what I want it to do, but I don't have the knowledge to create the formulas. A friend got me get this far - now stuck.

The CA Overtime rules are detailed on the spreadsheet.

Reg Hrs in D column should cap at 8 per day & 40 per week.
OT daily hrs 9 to 12 go to E column.
OT daily hrs 13+ go to column F.

Based on our workweek, emp is able to earn OT for working over 40 hrs in a week (this does not include OT hrs woked on a daily basis so as not to double dip) starting on Fri &/or Sat. These over 40 and over 48 hrs go to columns G & H.

7th Day rule wages also go in G & H.

Your help is appreciated - thank you.
Roxy[/SIZE]