+ Reply to Thread
Results 1 to 8 of 8

Timesheet to calculate TIL hrs based on Total Hours worked

  1. #1
    Registered User
    Join Date
    12-18-2019
    Location
    Gold Coast, Australia
    MS-Off Ver
    2016
    Posts
    4

    Timesheet to calculate TIL hrs based on Total Hours worked

    I am working on s timesheet that calculates TIL hrs based on Total Hours worked less Regular Hours.
    However, my TIL accrues a negative if there are no Total Hours entered yet.
    How do I show TIL Accrued as 0 if Total Hours is 0?
    example is attached.
    thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: Timesheet to calculate TIL hrs based on Total Hours worked

    would be easier if you provide an extra sample sheet also with correct values (no formula) wherever your formula fails or where you do not know how to calculate (change background color for easy detection)

  3. #3
    Registered User
    Join Date
    12-18-2019
    Location
    Gold Coast, Australia
    MS-Off Ver
    2016
    Posts
    4

    Re: Timesheet to calculate TIL hrs based on Total Hours worked

    I am calculating TIL Accrued from Regular Hours - Total Hours

    attached simpler spreadsheet
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: Timesheet to calculate TIL hrs based on Total Hours worked

    Please Login or Register  to view this content.

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Timesheet to calculate TIL hrs based on Total Hours worked

    @Fraser
    Please do not use professional jargon in your thread title/body. Not everybody understands it and members might skip your post seeing a title they do not understand. (TIL is a mystery to me)
    Thanks

  6. #6
    Registered User
    Join Date
    12-18-2019
    Location
    Gold Coast, Australia
    MS-Off Ver
    2016
    Posts
    4

    Re: Timesheet to calculate TIL hrs based on Total Hours worked

    wonderful thank you!
    i knew it was simple

  7. #7
    Registered User
    Join Date
    12-18-2019
    Location
    Gold Coast, Australia
    MS-Off Ver
    2016
    Posts
    4

    Re: Timesheet to calculate TIL hrs based on Total Hours worked

    apologies for jargon, second nature.

  8. #8
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: Timesheet to calculate TIL hrs based on Total Hours worked

    I did not believe on your first post that it was that easy. Therefore I asked for "simplification"
    Nevertheless it is always good also to provide a final result for comparision

    cheers

+ 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. [SOLVED] Formula to calculate hours worked w/lunch or w/o + OT column only total after 40 hours
    By blinhart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2023, 11:14 AM
  2. Calculate total hours worked in week by worker name
    By evgemans in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-23-2019, 12:24 PM
  3. [SOLVED] Timesheet total for hours worked between specific times of day e.g. 10pm to 12am
    By thisfatcat in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-05-2017, 01:13 AM
  4. Replies: 5
    Last Post: 01-11-2016, 11:15 PM
  5. Replies: 1
    Last Post: 06-14-2013, 02:09 AM
  6. Replies: 4
    Last Post: 06-26-2012, 02:19 AM
  7. Excel 2007 : Calculate total hours worked
    By elexiahope in forum Excel General
    Replies: 3
    Last Post: 01-23-2011, 04:18 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