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.
Bookmarks