Formula Error

[How_Do_I]

What is likely to be going on here to give me FALSE in AD13 please?

Excel Workbook
	Y	Z	AA	AB	AC	AD
12	TRUE					Time
13	101:37:14					FALSE
14						101:37:14
Sheet3

 

[cerfani]

check the milliseconds, or you can convert both to a number and check the difference

they do not equal though, that is certain

 

[becci.gott]

Have you got examples of what they are summing? It could simply be a rounding issue.

 

[How_Do_I]

I checked the cell format, they are both [h]:mm:ss whatever that is... if I change them to hh:mm:ss format then the calculation is wrong...

 

[How_Do_I]

Totally bizarre... Everything worked until today with this workbook... I'm trying to enter 01:33:01 for today. So to test, yesterday's entry 01:35:58 I drag down and get 02:35:58 but TRUE in AD13, I change my 02:35:58 one digit at a time to see what AD13 is doing and for 01:33:08 I am returning TRUE... As soon as I change the 8 to a 1 to match my data with that in the Jeanie I get the FALSE in AD13...