SOLVED

wrong date calculate

Copper Contributor
Hello,
I am using Excel to create a database and I got an error in the Excel calculation.
I am attaching a file, why in E117 the value is too strange?..
3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@elegatec 

It is a rounding error caused by the way dates and times are represented in binary notation. To get rid of the discrepancy, use the ROUND function. In E3:

=ROUND((C3-D2)*1440,0)

Fill down.

@Hans Vogelaar 
Thank you, now it look ok

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@elegatec 

It is a rounding error caused by the way dates and times are represented in binary notation. To get rid of the discrepancy, use the ROUND function. In E3:

=ROUND((C3-D2)*1440,0)

Fill down.

View solution in original post