Results 1 to 5 of 5

Subtracting Times

Threaded View

  1. #1
    Registered User
    Join Date
    05-28-2009
    Location
    Oxford
    MS-Off Ver
    Excel 2007
    Posts
    86

    Subtracting Times

    I am making a timesheet but having trouble with subtracting times.

    I have subtracted 3 times away (start time / lunch break / end time) to calculate hours worked.

    I have then taken this from the Contracted hours to see + / - time worked.

    However when you look at the calculation of the + / - time worked as a number, there is a a variance at the 16th number past the decimal point when they should be exactly the same (for 07:35 - 07:35). This causes the timesheet to display + and - values for 00:00.

    Please see attached excel file on the Example sheet dates 26/01/2011 to 27/01/2011. I have no idea why there is this discrepancy.

    Many thanks.
    Attached Files Attached Files
    Last edited by Knawl; 11-02-2010 at 03:51 AM.

Thread Information

Users Browsing this Thread

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

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