Created attachment 51732 [details] *.odt document showing up issues with time converting Please see attached spreadsheet.
It seems a precision problem, probably not a bug. Try the function ROUND() instead of INT(). BTW Excel 2010 shows same results as LibO/OOo.
Thank you, ROUND() does the trick. Nevertheless I wonder what's wrong with E5/F5 in contrast to E6/F6. Which internal values underlie related to E5 and E6? It was known to me that Excel 2007 shows same results.
Created attachment 51889 [details] spreadsheet containing issues with time converting
Unfortunately my last comment got lost somehow. Please see the 2nd attachment from 2011-10-02 22:24 showing up issues with both INT() and ROUND() function.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian