<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
> </o
>
I can calculate my overtime into 2 diferrent rates including weekends, but I need to enter manually any 2UP (Row/Cell AH) or Wait time hours (Row/Cell AM)which both need to be deducted from the daily hours before calculating the overtime K19 is the Calculated Total hours paid for the day<o
></o
>
This Spreadsheet calculates overtime each day after 10 hours regular time or after 38 hours of regular time per week. 3hrs max pay at x 1.5 then balance x 2 <o
></o
>
Overtime formula is<o
></o
>
=MAX(IF($AO$8,MAX(0,SUM(N18:N18)+K19-$N$3),0),IF($AO$5,IF(K19>$K$3,K19-$K$3,0),0))<o
></o
>
<o
> </o
>
Can anyone help??? Please!!!
Thank you




I can calculate my overtime into 2 diferrent rates including weekends, but I need to enter manually any 2UP (Row/Cell AH) or Wait time hours (Row/Cell AM)which both need to be deducted from the daily hours before calculating the overtime K19 is the Calculated Total hours paid for the day<o


This Spreadsheet calculates overtime each day after 10 hours regular time or after 38 hours of regular time per week. 3hrs max pay at x 1.5 then balance x 2 <o


Overtime formula is<o


=MAX(IF($AO$8,MAX(0,SUM(N18:N18)+K19-$N$3),0),IF($AO$5,IF(K19>$K$3,K19-$K$3,0),0))<o


<o


Can anyone help??? Please!!!
Thank you