+ Reply to Thread
Results 1 to 2 of 2

Labor Allocations surrounding OverTime

  1. #1
    Registered User
    Join Date
    Bangor, ME
    MS-Off Ver

    Labor Allocations surrounding OverTime

    Hi all,

    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.


  2. #2
    Forum Expert
    Join Date
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Vlook up value with diffrent allocations
    By jajinka in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-19-2012, 10:04 AM
  2. Replies: 3
    Last Post: 10-02-2012, 03:30 PM
  3. cosolidating report with department allocations
    By bball95 in forum Excel General
    Replies: 1
    Last Post: 04-05-2012, 11:26 PM
  4. Replies: 0
    Last Post: 01-27-2011, 01:59 PM
  5. Allocations of currency notes
    By mankothari in forum Excel General
    Replies: 3
    Last Post: 07-05-2008, 11:11 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1