+ Reply to Thread
Results 1 to 3 of 3

Issue with Timesheet + doubletime hours

  1. #1
    Registered User
    Join Date
    08-26-2011
    Location
    California, United States
    MS-Off Ver
    Excel 2016
    Posts
    45

    Question Issue with Timesheet + doubletime hours

    OK, So heres my problem I was wondering if anyone could possibly help. I seem to have hit a brick wall while calculating double time in my time sheet. I need the regular hours to be no greater than 8, I need the overtime hours to be no greater than 4 and the double time hours to be anything over 12. I think the problem lies with the way the overtime is calculated in my sheet to begin with. When someone works 8 hours everything displays fine (as with example one in the time-sheet) When someone works more than 8 hours the remainder is automatically thrown into the overtime cell (as with example two in the time sheet) So for instance if someone worked 14 hours with a lunch I cant figure out the formula to get the overtime cell to display four hours and the double time to display 2 (8 regular, 4 overtime, 2 double time = 14) If anyone could help me it would be greatly appreciated.Oh and I have i have attached the time-sheet (2007 excel) so anyone that can see what i did wrong can get an idea of what I'm talking about. Thank You in advance.
    Attached Files Attached Files
    Last edited by Lmao; 08-26-2011 at 01:30 PM. Reason: Solved

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Issue with Timesheet + doubletime hours

    Incorporating the "12" (without the greater than sign) in cell J6, how about:

    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    08-26-2011
    Location
    California, United States
    MS-Off Ver
    Excel 2016
    Posts
    45

    Re: Issue with Timesheet + doubletime hours

    Wow i didn't expect to get a response so fast! You are awesome thank you for your help this is exactly what i needed.

+ 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