Need help with excel overtime formula?

Question

Need help with excel overtime formula

I have been working on this formula for 2 days now and i have had no break.

The parameters for the formula go like this:
After 8 Hours, the worker gets overtime at time and a 1/2 (1.5)
After 40 Hours the worker gets overtime at (1.5)

Please Help
Thanks

that is 40Hrs in one week

Answer 1

you could use an if formula
b1=hours
c1=$ per hour

then d1 has
=+IF(B1>8,8*C1+((B1-8)*(1.5*C1)),+B1*C1)

you dont specifiy whether its 40 hours in 1 week or 40 hours in 2 weeks. that would make a difference. example, if someone worked 5 hours a day for 2 weeks (not including weekends on all this), then they would get OT.

ok then at 40 hours per week, the formula should work. i dont know why it shows the ... at the end, so i will break it into 2 lines so you can see the end of it.
=+IF(B1>8,8*C1+((B1
-8)*(1.5*C1)),+B1*C1)

Answer 2

Try searching Google for "Excel Overtime Formulas." If it is something simple where you just need to calculate the overtime in a separate cell from the actual hours worked, then the cell that displays the overtime rate should have:

(Hours) * (Rate + (Rate *.5))