Results 1 to 11 of 11

Need help with an hour calculating timesheet... please!

Threaded View

  1. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,085

    Re: Need help with an hour calculating timesheet... please!

    its the way the hours are worked out and its to do with a 44 hour threshold
    if you unhide and work through the formulas - you will see how they are calculating, and you will need to see if thats a logical way to calculate for you situation. Is that how you want it to work now.

    if you put an 1 in for each day , sunday populates

    but if the hours are over 44 then negative numbers are entered and -8 then displays 0 for a day
    not sure i understand the logic
    but thats what the formula appears to be doing
    Last edited by etaf; 03-04-2015 at 04:45 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] 24-hour clock timesheet help
    By utahcorvettenut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2015, 07:25 AM
  2. Excel timesheet for quarter hour
    By ZNLOZ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-27-2011, 04:54 AM
  3. Replies: 4
    Last Post: 10-14-2010, 03:31 PM
  4. Rounding Timesheet to quarter hour
    By djknight2007 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-30-2010, 01:12 PM
  5. 24 Hour Format For Timesheet
    By faisca_aem in forum Excel General
    Replies: 3
    Last Post: 06-29-2006, 10:10 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