To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=101292
User cloph changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Fri Jun 5 13:50:51 +0000
2009 -------
This is invalid/wontfix.
Date is represented as a number internally, more specific: counted in fraction
of days since a specific start-date. (12 hours equals 0,5)
So hours and minutes are represented as decimal numbers. As all computer systems
have limited accurancy with floating point numbers, rounding errors occur.
INT will always round down to the integer. INT(12,9999999...) will still result
in 12
So depending at what point in the calculation you introduce such
rounding-errors, you can get different results.
Despite the displayed value of 15, E1 doesn't really contain 15. It is just
rounded for display. In fact it is 14,9999999999 to the available precision.
This precision stuff is one of the reasons why there are dedicated date and time
functions. If you're only interested in the difference of the minute part, just
do =MINUTE(B1)-MINUTE(A1) or =MINUTE(B1-A1)
(Another way is to not use INT but one of the other rounding functions to round
to the closest integer value)
Invalid/wontfix because fundamental limitation of computer based floating point
arithmetics. Invalid because dedicated time-based functions exist that avoid
that problem.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
