+ Reply to Thread
Results 1 to 3 of 3

Running Totals Calculating Overtime?

  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    Ontario
    MS-Off Ver
    Excel 2003
    Posts
    2

    Talking Running Totals Calculating Overtime?

    Hi Everyone! Hope someone can help with this. I am having a hard time wrapping my head around it, so anything will be useful! Thanks in advance!

    I need to track employee overtime that needs to be used in 3 months, for example:

    Employee A: did overtime on July 1 for 8 hrs, which is banked at 12 (time and half) These 12 hours need to be used up by Oct 1 (3 months from date worked) otherwise they are paid out...

    I have set up a spreadsheet with the following:
    Date Worked
    Hours Worked (input the 8 hours)
    At 1.5 (calculates the time and a half) 12
    Must be used or paid out by (I have a date formula that returns 3 months)
    Date Used
    Banked time used (can only be in units of 8 hrs or less)
    Paid Out (will pay out 12)

    Problem is simple getting around it, not so much! Employee A works July 1, and banks the 12 hours, Uses the banked time on Aug 15 using 8 of the 12 hours, I still need a way to track the remaining 4 hours and ensure that it is being used BEFORE Oct 1st.

    HELP!

  2. #2
    Forum Contributor
    Join Date
    08-01-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    182

    Re: Running Totals Calculating Overtime?

    Hi,

    Welcome to the forum.

    It will be great if you can attach a workbook with some dummy data. In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
    One must rise above the Clouds to see the Blue Sky rather than constantly trying to push them aside

    If you want to say Thank you to a member, click the little star * below.

    If your Problem is Solved, please mark the Thread as Solved

  3. #3
    Registered User
    Join Date
    10-25-2011
    Location
    Ontario
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Running Totals Calculating Overtime?

    Hi, sorry for the delay, it has been crazy at work, here is a sample. Please help!!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

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