Results 1 to 4 of 4

Random calculation error with adding and subtracting times

Threaded View

randywombat Random calculation error with... 09-02-2020, 10:16 AM
MrShorty Re: Random calculation error... 09-02-2020, 10:35 AM
Richard Buttrey Re: Random calculation error... 09-02-2020, 11:25 AM
randywombat Re: Random calculation error... 09-17-2020, 05:17 AM
  1. #1
    Registered User
    Join Date
    09-02-2020
    Location
    Brussels
    MS-Off Ver
    Office 365
    Posts
    2

    Random calculation error with adding and subtracting times

    I have a staff timesheet which records overtime/undertime worked by a member of staff based on their daily hours.

    As with all timesheets, it has to do calculations with negative times, and therefore it uses the 1904 date system rather than the 1900 date system. This works perfectly everywhere... well, NEARLY everywhere. There is one row which generates a wildly wrong answer. It adds –00:04 to +01:14 and comes up with the crazy answer of –22:50.

    I have attached the timesheet, with personal information removed. I apologise for attaching such a large spreadsheet, but everything is so interlinked, there's no way to cut down the amount of data without changing the data and thus making the problem invisible. The error is on the August worksheet in cell AG11; I have highlighted it in yellow and made it nice and big so it's easy to see.

    Can anyone help figure out what's going on here, and how to fix it? Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Get rid of error message while subtracting two times
    By chriswrcg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2019, 10:16 AM
  2. [SOLVED] Precision error while adding or subtracting values in excel.
    By alokmpatel in forum Excel General
    Replies: 2
    Last Post: 11-19-2015, 06:38 AM
  3. Adding subtracting times
    By jays35 in forum Excel General
    Replies: 1
    Last Post: 08-23-2012, 10:26 PM
  4. Adding/Subtracting Times
    By controlfreak in forum Excel General
    Replies: 2
    Last Post: 09-09-2009, 04:20 AM
  5. Adding/Subtracting Dates & Times
    By Kim17740 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-11-2006, 08:04 PM
  6. Rounding Error when adding or subtracting two cells
    By mtheo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2006, 02:55 PM
  7. Subtracting Times
    By bhalchandra2000 in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 12: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