+ Reply to Thread
Results 1 to 3 of 3

Timesheet, overtime and double overtime calculation

  1. #1
    Registered User
    Join Date
    05-10-2016
    Location
    San Francisco
    MS-Off Ver
    2013
    Posts
    2

    Timesheet, overtime and double overtime calculation

    OK, So here is my problem I was wondering if anyone could help. I have hit a dead end while calculating double over 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 using the =MIN function. When someone works more than 8 hours the remainder is automatically thrown into the overtime cell, using the =Max function. I need this cell to can at 4.

    For example.....if someone worked 14 hours with a lunch I can't figure out the formula to get the overtime cell to display four hours and the double overtime to display 2 (8 regular, 4 overtime, 2 double overtime = 14) If anyone could help me it would be greatly appreciated.

    Thank you!!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Timesheet, overtime and double overtime calculation

    Will this work for the overtime hours:

    Please Login or Register  to view this content.
    It finds the max, then takes the minimum of the max or 4.
    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.

  3. #3
    Registered User
    Join Date
    05-10-2016
    Location
    San Francisco
    MS-Off Ver
    2013
    Posts
    2

    Re: Timesheet, overtime and double overtime calculation

    Yay! I was so close but my brain just gave up. Thank you so much!

+ 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. Timesheet with overtime and double time
    By ymqiao in forum Excel General
    Replies: 8
    Last Post: 06-28-2015, 01:36 AM
  2. Timesheet with overtime and double time
    By ymqiao in forum Excel General
    Replies: 2
    Last Post: 06-26-2015, 02:17 AM
  3. [SOLVED] Timesheet with overtime calculation between certain hours, days only
    By ExcelNoviceHexham in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-02-2013, 12:21 PM
  4. Timesheet calculation for overtime and double overtime
    By eortega in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-29-2013, 03:28 PM
  5. [SOLVED] Timesheet Overtime Calculation
    By missionvalley1 in forum Excel General
    Replies: 8
    Last Post: 04-09-2012, 10:35 AM
  6. Timesheet / Overtime rate calculation
    By mobiay in forum Excel General
    Replies: 3
    Last Post: 03-19-2008, 04:42 PM
  7. Overtime and Double time Calculation
    By violet in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2007, 04:16 PM

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