Somewhat complicated...at least for me. Our company does not pay overtime (don't ask....it's a trucking company and falls under Intrastate exemption).

I'm trying to back into the ACTUAL earned hourly rate if an employee WAS paid overtime.

For instance;
Employee "A" earned $1,000 for the week, but worked 50-hours. His current Earned Hourly rate is $20 for ALL hours worked.

If we were to pay O.T at 1.5X, what would his "straight" time be for the first 40-hours?


I.E., Straight time rate = $XX (X) 40-hours
Overtime rate = $XX (X) 10-hours.

Is there a formula that can be built to reflect such?