+ Reply to Thread
Results 1 to 6 of 6

Calculating Overtime Over 40 Hours

  1. #1
    Registered User
    Join Date
    12-14-2019
    Location
    Cincinnati
    MS-Off Ver
    10
    Posts
    3

    Calculating Overtime Over 40 Hours

    Good Afternoon,

    I am trying to create a spreadsheet that will calculate overtime hours per day. Towards the end of a long week the employee may work one day where they have 3 regular hours and 3 overtime hours. The next day all of the 4 hours would be overtime.

    In the attached spreadsheet I cannot seem to figure out the formula to make that happen. It is giving me a running total of overtime hours and I just need the overtime hours for that day.

    What I was trying to accomplish was
    D7 equals 4 regular hours and E7 equals 5 overtime hours (which is correct)
    D8 equals 0 regular hours and E8 equals 4 overtime hours
    D9 equals 0 regular hours and E9 equals 0 overtime hours.

    Any help is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-26-2020
    Location
    US
    MS-Off Ver
    2010
    Posts
    157

    Re: Calculating Overtime Over 40 Hours

    Hi try this timesheet:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by RChad; 03-25-2020 at 03:25 PM.

  3. #3
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: Calculating Overtime Over 40 Hours

    =IF(C3=0,,MAX(SUM($C$3:C3)-40-SUM($E$2:E2),)) for overtime
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-14-2019
    Location
    Cincinnati
    MS-Off Ver
    10
    Posts
    3

    Re: Calculating Overtime Over 40 Hours

    Thanks tim201110 but where do the hours originate from? Everything is a formula and if you change the data in column C, the spreadsheet changes.

    Again thank you for your help!

  5. #5
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,894

    Re: Calculating Overtime Over 40 Hours

    He just put a formula in there to generate random hours. You would put in whatever hours the employee worked. So you can delete everything in that column (from Mon-Sun), then enter your actual hours.

  6. #6
    Registered User
    Join Date
    12-14-2019
    Location
    Cincinnati
    MS-Off Ver
    10
    Posts
    3

    Re: Calculating Overtime Over 40 Hours

    Beautiful! Thank you everybody for your help!!

+ 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] Calculating Overtime Hours for each Day on a 40+ Overtime per Week Basis
    By HumdrumPanic in forum Excel General
    Replies: 5
    Last Post: 09-30-2020, 12:55 PM
  2. help for formula Calculating Hours [Overtime hours]
    By tryhyper in forum Excel General
    Replies: 5
    Last Post: 07-03-2017, 04:16 AM
  3. [SOLVED] Calculating Overtime without going over 12 hours
    By ljmparalegal in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-05-2015, 03:23 PM
  4. Calculating overtime hours
    By Tashia in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-19-2014, 02:09 AM
  5. Calculating overtime hours on a timesheet
    By tiffany04530 in forum Excel General
    Replies: 8
    Last Post: 12-01-2012, 04:50 AM
  6. Timesheet formula for calculating ordinary hours and overtime hours.
    By zoen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-18-2011, 04:23 AM
  7. Calculating Overtime Hours
    By Jonathan78 in forum Excel General
    Replies: 0
    Last Post: 11-02-2009, 05:49 PM

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