![]() |
|
#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 |
|
|
Similar Threads
|
||||
| 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 |
Cost Rate Table Macro Help
|
JohnTurner | Project | 1 | 01-27-2014 07:53 AM |
| Help: Very low response-rate! | Jeff10 | Office | 6 | 12-17-2013 10:44 AM |
Monthly Growth Rate Formula
|
meggenm | Excel | 2 | 04-22-2013 09:21 PM |
Automatically updating currency exchange rate?
|
Metamag | Excel | 2 | 09-07-2012 09:00 PM |