Difference between 2 hours doen't result in 0

[Michele317]

Hello,

I have a sheet in which I have an IF statement and the false condition makes the difference between 2 hours:
- one is the result from another formula
- the other is typed manually.

I don't undersand the reason. But some time this formula gives me the result -00:00 (to be precise, I converted it in General format and I get -6,93889390390723E-18)
I tried to do a simple difference between the 2 without the IF statement and I get exactly 00:00.

This things happens only sometimes, since I have same formula for multiple other cases.

How is that possible?

Below a part of the sheet:

09:10	01:10	01:10	01:10	-00:00
09:15	01:15	01:15	01:15	00:00

(the difference is between the second and the fourth column, the result is in the last column)
In the first line, I'm getting the problem above.
In the second line, I'm getting the correct result.

 

[Fluff]

It's to do with floating point precison. Floating-point arithmetic may give inaccurate result in Excel - Microsoft 365 Apps

 

[Michele317]

It's to do with floating point precison. Floating-point arithmetic may give inaccurate result in Excel - Microsoft 365 Apps

Thank you for the asnwer Given the problem, I fixed it just with a ROUND() function

 

[Fluff]

Glad to help & thanks for the feedback.