+ Reply to Thread
Results 1 to 5 of 5

Calculating Overtime (after 40 hours worked)

  1. #1
    Registered User
    Join Date
    03-19-2008
    Posts
    4

    Calculating Overtime (after 40 hours worked)

    I need a formula to calculate overtime, after a work week of 40 hours.

    for example: if an employee works 10 hours a day we would not count towards overtime until the employee completes a 40 hour work week.

    Any suggestions would be greatly appreciated!!!!!

    Thanks,
    YV

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Calculating Overtime (after 40 hours worked)

    A1: Hours
    B1: (number of hours worked....eg 42)

    A2: Overtime
    B2: =MAX(B1-40,0)

    If B1: 42
    B2 returns 2

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    03-19-2008
    Posts
    4

    Calculating Overtime (After 40 hours worked)

    WOrked out perfectly THANKS!!!!!! You are the best!!!!!

  4. #4
    Registered User
    Join Date
    04-05-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    4

    Re: Calculating Overtime (after 40 hours worked)

    I'm having trouble with my Overtime Hours column (I).
    I can't figure out how to get it to show just the overtime for that day.
    I have attached the xlsx file as well as a photo of the table as is.

    The formula for that column is: =IF(ISBLANK(D20),0,(MAX(H20-40,0)))
    I want it to subtract the previous cell before it, but every time I do it returns a value error with this formula:
    =IF(ISBLANK(D20),0,(MAX(H20-40,0)-I5:I6)) Then the I6 increases

    The ultimate goal is for a spreed sheet that can calculate employee wage with a single employee that has two separate wages
    that shares the same set of 40 hours for that week in a biweekly setup with an on call bonus added at the end of the week.
    Attached Images Attached Images
    Attached Files Attached Files

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Calculating Overtime (after 40 hours worked)

    Hi Humdrum, welcome to the forum

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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