+ Reply to Thread
Results 1 to 3 of 3

Trying to create time tracker that stops at 40hrs and then splits the OT separately

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Trying to create time tracker that stops at 40hrs and then splits the OT separately

    So you log your hours each day. i.e. 8,8,8,8,8 = 40 hours. but if you did 8,8,8,10,8 then on our spreadsheet you would need to log it as 8,8,8,10,6 and then 2 on the next row down.

    Basically, you continue to put in your accumulated hours until you hit 40, then everything over 40 goes into the next row for OT. I've attached a sample workbook to try and make sense. inside the black box is what I am looking at. The top example is what the employees see and would enter. The orange box is how it should work. I would like to allow the employees to enter their info into the top example and the bottom would then instruct them what their timesheet should look like if filled out correctly. Hope that makes some sense!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,915

    Re: Trying to create time tracker that stops at 40hrs and then splits the OT separately

    Try this ...

    In K13:

    =MAX(0,MIN(40,SUM($K$10:K10))-SUM($J$13:J13))

    In K14:

    =SUM($K$10:K10)-SUM($K$13:K13,$J$14:J14)

  3. #3
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Trying to create time tracker that stops at 40hrs and then splits the OT separately

    I think that works! Thank you

+ 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. Replies: 1
    Last Post: 02-09-2016, 09:57 PM
  2. Time sheet that splits normal time and a half and double time
    By leewat in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-09-2016, 07:52 PM
  3. Help build a Leave tracker and Effort Time Estimation Tracker
    By cherias in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2015, 02:10 PM
  4. System idle time tracker / Break Tracker
    By reetika05 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2014, 07:26 AM
  5. Calculating lap time splits
    By james-w-bray84 in forum Excel General
    Replies: 3
    Last Post: 05-24-2012, 09:54 AM
  6. Subtracting Time (splits)
    By t3coach1 in forum Excel General
    Replies: 1
    Last Post: 07-29-2009, 12:24 PM
  7. time tracker-a running tracker date wise
    By arnab0711 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2008, 03:08 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