Results 1 to 6 of 6

Calculating Overtime Hours for each Day on a 40+ Overtime per Week Basis

Threaded View

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

    Calculating Overtime Hours for each Day on a 40+ Overtime per Week Basis

    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. If I can get this overtime figured out I think I got the rest of it. I might have trouble with the job codes I'm not sure yet. I'm going to change them to numbers when I get to them, the current strings are for easy reference at this point.
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 05-16-2014, 11:30 AM
  2. [SOLVED] Calculating overtime in Excel for over 40 hrs per week
    By mike4000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2013, 06:16 AM
  3. Calculating overtime hours on a daily and weekly basis
    By Skwerl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2011, 09:12 PM
  4. +40 Hours in a Week Overtime Fromula
    By Chelsea in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-28-2006, 01:55 PM
  5. Calculate Hours and overtime by week
    By gregt812 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-23-2005, 03:10 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