Results 1 to 4 of 4

excel formula for determining time difference is late or on time not calculating correctly

Threaded View

AvidanR excel formula for determining... 08-11-2017, 04:17 PM
etaf Re: excel formula for... 08-11-2017, 04:27 PM
AvidanR Re: excel formula for... 08-11-2017, 04:45 PM
etaf Re: excel formula for... 08-12-2017, 01:48 AM
  1. #1
    Registered User
    Join Date
    07-17-2017
    Location
    New Jersey
    MS-Off Ver
    2013
    Posts
    56

    excel formula for determining time difference is late or on time not calculating correctly

    I have this excel sheet that I have been working with people on this website for the past couple months. I have made serious progress and there seems to be this glitch in the formula i am using. I am attaching an excel sheet withe formulas and the line from the excel sheet that isn't calculating correctly. The basics of this excel are this, I am taking two different times and dates and from that calculating the time difference between the two. Once I have done that I am determine based on a rule that if the time difference is over 12 hours then the item is late if its below 12 hours it is on time. This particular line I am having trouble with is under 12 hours yet it says its late. On top of that it is the only line in the entire excel sheet that has this issue. I have double check the formulas against other lines to make sure it matches and it does. The line with the issue is on the 4 tab of the excel the first page is a sample of what the formulas are doing.


    thank you in advance for anyone who can help me.
    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. Replies: 6
    Last Post: 05-20-2023, 01:07 AM
  2. Replies: 31
    Last Post: 07-28-2017, 01:48 PM
  3. Time difference calculating formula needed
    By nahidking in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-03-2015, 06:17 AM
  4. [SOLVED] Formula for calculating time difference between two cells
    By mprasanna in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-05-2015, 04:54 AM
  5. [SOLVED] Time formula not calculating correctly
    By brianfromla in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2014, 11:12 AM
  6. [SOLVED] Calculating difference between 2 dates in excel 2003 - formula not working correctly
    By cf7046 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2013, 10:18 PM
  7. Calculating time difference between two days capturing the overnight time.
    By Monica_La in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2007, 11:22 AM

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