+ Reply to Thread
Results 1 to 5 of 5

If formula possible, timesheet over time

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

    Unhappy If formula possible, timesheet over time

    I am having trouble figuring out how to get this timesheet to flow right.
    I am looking for a formula for Column G(Regular Hours) & H(OT), the conditions is that after 40 hours it classified as OT, but the variable is that if there is Vacation hours, they are apart of the 40 hours. They are not paid OT on column J or K.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,057

    Re: If formula possible, timesheet over time

    You need to provide a lot more information or change your form.

    From your explanation it is impossible to calculate overtime on a daily basis.

    You could if you specified that each person works 5 x 8 hour days. But you have not.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,057

    Re: If formula possible, timesheet over time

    You need to provide a lot more information or change your form.

    From your explanation it is impossible to calculate overtime on a daily basis.

    You could if you specified that each person works 5 x 8 hour days. But you have not.

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

    Re: If formula possible, timesheet over time

    Thank You, so I figured it out somewhat, but here is what I'm left with, an If statement within an If state,emt


    My logical test is if G19>40,
    If its true I want it be F19-(G19-40), however if F19-(G19-40) is a less than 0(or negative), then it needs to read"0"
    if false f18.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,816

    Re: If formula possible, timesheet over time

    My guess would be
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    This doesn't quite match up with the file in post #1 as row 19 is Friday and row 20 is Total. If the above formula doesn't do what you want I would suggest uploading another file showing the desired location of the formula and (Manually entered) expected result.
    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. Formula for Timesheet - Double Time, Time Half and normal Hours
    By Tracs13 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-12-2017, 09:40 PM
  2. [SOLVED] Timesheet Formula - Time in Lieu
    By holiday4ever in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2017, 07:06 AM
  3. Timesheet formula to deduct unpaid time based on value in a column
    By tlstevens in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-16-2015, 04:41 PM
  4. double time formula for timesheet
    By techmob in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2009, 11:21 AM
  5. TimeSheet: When an end time is after Midnight
    By coreytroy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2008, 05:01 AM
  6. Show timesheet time in and out in regular time versus military tim
    By John in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-11-2005, 01:20 AM
  7. [SOLVED] Help, How can I deduct time for a timesheet?
    By Jo in forum Excel General
    Replies: 7
    Last Post: 09-20-2005, 05:05 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