![]() |
#1
|
|||
|
|||
![]()
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? |
Tags |
formula help |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need formula to determine minimum quantity needed per price | mbking | Excel | 2 | 02-10-2015 01:46 PM |
![]() |
JohnTurner | Project | 1 | 01-27-2014 07:53 AM |
Help: Very low response-rate! | Jeff10 | Office | 6 | 12-17-2013 10:44 AM |
![]() |
meggenm | Excel | 2 | 04-22-2013 09:21 PM |
![]() |
Metamag | Excel | 2 | 09-07-2012 09:00 PM |