Labor Allocations surrounding OverTime
I know there are many questions asking for help dealing with payroll / overtime / etc. I have read them all and they do not apply to my situation. I am in charge of completing the labor allocations for events held at my workplace. I have created a spreadsheet to keep track of these in and normally its a piece of cake since events are a one day occurrence. Last week we had our state fair which ran for 10 days. Seven of those days were in one payroll period and the last three days were in another payroll period.
I created formulas to track the hours and regular pay. Then I added in a column to track the cumulative hours for each employee so that I would know when they reached overtime. When I created the formula for the overtime pay I wrote a formula to have it check the value in the cumulative column, see if it was over 40, and if so take the difference between 40 and the total to find the overtime and multiply it by the O/T rate.
Went one step further and had that formula subtract out the previous days overtime rates so that it reflects only the current days wages. HOWEVER, there lies my problem. I can't figure out how to write a formula that will prevent it from putting wages in the regular pay column if all the hours worked that day are overtime hours.
Re: Labor Allocations surrounding OverTime
Post a sample workbooks and we can help.
Please ensure you mark your thread as Solved once it is. Click here
to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By jajinka in forum Excel Formulas & Functions
Last Post: 10-19-2012, 10:04 AM
By avery robok in forum Excel Formulas & Functions
Last Post: 10-02-2012, 03:30 PM
By bball95 in forum Excel General
Last Post: 04-05-2012, 11:26 PM
By Nosila in forum Excel General
Last Post: 01-27-2011, 01:59 PM
By mankothari in forum Excel General
Last Post: 07-05-2008, 11:11 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1