Assume you have hours filled in Range A1:G1
A1:E1 for Monday to Friday and F1 for Sat and G1 for Sunday.
The calculation of overtime is
=IF(SUM(A1:E1)=40,SUM(A1:G1)-40,IF(SUM(A1:G1)40,SUM(A1:G1)-40,0))
If the total hours for M-F =40, then OT = total hours for all 7 days -
40;
If the total hours for M-F < 40, but for all 7 days 40 then OT = total
hours for all 7 days - 40;
If the total hours for all 7 days <= 40 then OT = 0

===== * ===== * ===== * =====
Daniel CHEN


www.Geocities.com/UDQServices
Free Data Processing Add-in<
===== * ===== * ===== * =====


"ness" wrote in message
...
I have been using the IF formula to calculate everything else on this time
card that I am trying to creat, but in certain instances for CA if a
person
does not meet 40 hours in a M-F workweek, and works on say Saturday the
time
worked on Saturday does not count as OT until the 40 hour threshold is
met.

ie: worked 35 hours M-F, worked 7 hours on Saturday, we need 5 hours to go
into regular hours, and the remaining 2 hours into OT. it gets really
complicated. I'm hoping someone already created a worksheet with all the
formulas and can answer my question.