+ Reply to Thread
Results 1 to 5 of 5

Overtime after 40 hours Timesheet

  1. #1
    Registered User
    Join Date
    05-11-2017
    Location
    Hamilton
    MS-Off Ver
    2016
    Posts
    12

    Overtime after 40 hours Timesheet

    I cannot get my formulas to flow right, think I may need another column, ultimately I need OT to be 3 hours on Friday and a possibly a column the is PAID VAC/Stat???? Column J is manually entered because depends on how many hours they take when taking vacation time and they are paid OT on Vacation and Stat hours. What I don't know why its putting 8 hours in OT when its only 3 hours....and even when there's no OT it showing 8 hours of OT for the Vac/Stat hours.....
    Also columns F, G and M are hidden usually.
    Attached Files Attached Files
    Last edited by majorqt75; 04-15-2019 at 04:36 PM.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,010

    Re: Overtime after 40 hours Timesheet

    .
    Does the attached clean things up ?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-11-2017
    Location
    Hamilton
    MS-Off Ver
    2016
    Posts
    12

    Re: Overtime after 40 hours Timesheet

    Thank You but no, OT is after 40 hours a week ....not 8 hours per day....

  4. #4
    Registered User
    Join Date
    05-11-2017
    Location
    Hamilton
    MS-Off Ver
    2016
    Posts
    12

    Re: Overtime after 40 hours Timesheet

    Anybody else have any luck?

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Overtime after 40 hours Timesheet

    Try pasting the following into cell I13 then drag the fill handle down to I19: =IF(G13>40,G13-40,0)
    If that doesn't produce the desired results please show or tell us what values you expect and in what cells you need them.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. adding formula [on timesheet to show overtime hours]
    By toddp2 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-05-2017, 12:47 PM
  2. Separating overtime hours from regular hours in timesheet
    By aphatmc in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-20-2017, 10:00 AM
  3. Showing Overtime Hours Only on a Timesheet
    By Damo33 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-19-2015, 09:39 AM
  4. Timesheet to calculate overtime hours
    By steve@stanley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2013, 12:27 PM
  5. [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
  6. Calculating overtime hours on a timesheet
    By tiffany04530 in forum Excel General
    Replies: 8
    Last Post: 12-01-2012, 04:50 AM
  7. 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

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