My head hurts on this one! I am trying to calculate overtime based on 2 conditions.
If your WcState (in Rates file) is equal to CA, you get Overtime over 8 hours a day (Marta Jones) (Sean Jones) AND overtime for hours over 40 as well (Sean Jones).
if your WcState (in Rates file) is equal to anything else, you get overtime for hours over 40 a week. - (Katie Jones)
Sean Jones is not working correctly. He should have 40 hours Regular (28 hours + 12 hours) at $80 VNDLY Pay Rate ST Hr AND (7 + 2 + 4 hours) at overtime rate $120 VNDLY Pay Rate ST Hr.
I don't know how to calculate the hours over 40 he should get overtime for, they are going into the regular time calc.
@ewassell I didn't want to dig into your whole workflow but see the attached solution for calculating the overtime hours.