LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Need help with Overtime formula.

Hello!

I have several employees that work for me at $7.00 per hour. They want to
work more hours per week at this same wage, but I am unable to afford
overtime for them.

Department of labor laws state that every hour over 40 per week must be paid
at 1.5 the normal hourly rate. My employees have agreed to take a cut in pay
to enable me to pay them whatever amount is necessary if, when overtime is
applied, they average out to $7.00 per hour. In other words, they are
willing to work for 40 hours per week at x amount and a variable number of
hours for x*1.5 as long as the x +(x*1.5) averages $7.00 per hour.

This number x will change with each schedule since they will work a
different number of hours per schedule (ie an employee may work 55 hours in
week one, 50 hours in week two, 60 hours in week three, and so on). Can
anyone help with a formula that will solve for x based on these changing
hours with the average rate of pay still staying at or around $7.00 per hour?

Thank you,
Brad in Dallas
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
=SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $2 paulrm906 Excel Worksheet Functions 8 June 11th 06 10:34 AM
HOW DO I CALULATE A OVERTIME FORMULA Payclerk Excel Worksheet Functions 1 April 9th 06 09:21 PM
WHAT'S THE FORMULA FOR CALCULATING OVERTIME IN 1 CELL? EXAMPLE: 8. garpavco Excel Worksheet Functions 3 August 18th 05 01:22 PM
need help w/formula for calculating overtime hours jv749297 Excel Worksheet Functions 1 January 17th 05 07:54 PM
IF or SUMIF help for Overtime Formula Myrna Excel Worksheet Functions 2 November 8th 04 04:01 PM


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"