https://bugs.freedesktop.org/show_bug.cgi?id=76549
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC| |[email protected] --- Comment #1 from m.a.riosv <[email protected]> --- Hi fsoltrash, thanks for reporting. Even it seems, there is not a bug. The value in B2499 is 41665,999999994 not 41666,00000000000. As you aren't rounding the +1/24/4 an error is accumulated. In B2499 you are showing the time, so the format round the time and in consequence the day, so it shows 27/01/14 00:00. But if you set up here a format like DD/MM/YY it shows 26/01/14. The text formula in C2499 doesn't show the hour, so as it must be it takes only the day, integer part of the value is 41665, that correspond to 26/01/14. If you add the hours to text function shows the same as B2499. To obtain an accurate value for the whole year, use a formula like: B4: =ROUND(B3+1/24/4;10) Changed status to resolve notabug, please if you are not agree, reopen it. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
