work hours and extra hours

[winstonshu]

=IF(G2<=8,G2*$J$2,IF(G2<10,8*$J$2+(G2-8)*1.25*$J$2,IF(G2>10,8*$J$2+2*1.25*$J$2+(G2-10)*1.5*$J$2)))+IF(C2=6,G2*1.5*$J$2-G2*$J$2,0)+IF(C2=7,G2*2*$J$2-G2*$J$2,0)

C2=6
C2=7

6 and 7 are the days. it works fine with 8 hours work, but more than 8 years it doesnt work

the terms are:
work 1 hour- 43.5
8 hours-100$
2 hours extra work-125%
more than 2 hours- 150%
day 6(c2=6)=150% all day
day 7(c2=7)=200% all day

 

[steve the fish]

If you need help you are going to need to be clearer. What is in G2? J2? As for the terms what do the first two mean?

 

[winstonshu]

If you need help you are going to need to be clearer. What is in G2? J2? As for the terms what do the first two mean?

G2- decimal presence e.g from 7:30 to 17:20 - 9:50 hours and 9.83 decimal
J2- salary per hour (43.5$)
the first two means:
salary per hour- 43.5%
8 hours a day-100%(8*43.5)

i only have problem with day 6 and day 7
in day 6: 150% all day(1.5*43.5)
in day 7: 200% all day

more than 8 years- the calculation doesnt work out



****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">decimal</body>****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">decimaldecimal</body>

 

[steve the fish]

Test to see if this works:

=IF(C2=7,2*G2*J2,IF(C2=6,1.5*G2*J2,J2*(MIN(8,G2)+1.25*MIN(2,MAX(G2-8,0))+MAX(0,1.5*(G2-10)))))

 

[winstonshu]

Test to see if this works:

=IF(C2=7,2*G2*J2,IF(C2=6,1.5*G2*J2,J2*(MIN(8,G2)+1.25*MIN(2,MAX(G2-8,0))+MAX(0,1.5*(G2-10)))))

works like a charm. thanks