+ Reply to Thread
Results 1 to 4 of 4

How to Calculate Number of Overtime Hours but Only for Weekday

  1. #1
    Registered User
    Join Date
    04-15-2014
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    5

    How to Calculate Number of Overtime Hours but Only for Weekday

    Hello,

    I need help with a formula that will calculate the number of overtime hours, but only for weekdays.

    I have in:
    Column A1: Date of Work (for example, December 24, 2012)
    Column A2: Number of Hours worked (for example, 8)
    Column A3: Day of the Week (for example, Monday)

    I want to put the formula in Column A4, which will show "Number of Overtime Hours (Weekdays)".
    Basically, anything over 8 hours will be overtime. So in Column A4, I want something that says if A2>8 and A3 is Monday-Friday, then A2-8.
    So lets say for example it is 12 hours on a Tuesday. I'm guessing the formula would be something like: =IF(A2>8 AND MONDAY-FRI???, (A2)-8,0)=4.

    Can anyone help? Thanks,

    Tony

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: How to Calculate Number of Overtime Hours but Only for Weekday

    deleted..bvj
    Last edited by protonLeah; 04-15-2014 at 09:46 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    04-15-2014
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: How to Calculate Number of Overtime Hours but Only for Weekday

    ??? What?????

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How to Calculate Number of Overtime Hours but Only for Weekday

    A formula like this might be what you are looking for if the date is in A3 and the hours worked are in B3 instead of the arrangement that you describe. If you want to keep the arrangement that you describe, change the cell references for B3 to A2. Your entry for A3 isn't necessary as the WEEKDAY function will figure out what day of the week the date is.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. How to Calculate Number of Overtime Hours but Only for Weekday
    By ajyoo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2014, 03:18 AM
  2. Replies: 2
    Last Post: 01-17-2014, 02:22 PM
  3. [SOLVED] 40 Hours per week / how to calculate overtime hours
    By hudsonic72 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2013, 02:33 AM
  4. Subtracting hours from time to calculate overtime hours
    By nabilishes in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-16-2012, 08:56 AM
  5. Calculate Overtime Hours
    By Yelrihs in forum Excel General
    Replies: 2
    Last Post: 05-18-2011, 03:45 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