https://bugs.freedesktop.org/show_bug.cgi?id=83414
GerardF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |NOTABUG CC| |[email protected] --- Comment #9 from GerardF <[email protected]> --- This is not a bug. Your sum result is 428:01:39 (format [HH]:MM:SS) or 17.8344791666667 formated as number. Original default date in Calc is 0 = 1899-12-30 Your result is 17.83 days after original day 00:00. 1899-12-30 00:00:00 + 428:01:39 = 1900-01-16 20:01:39 When formatting DD:HH:MM:SS (date-time format) you get the Day which is january *16*. The result with Excel seems correct because Excel original date is 1 = 1900-01-01 I wrote "seems correct" because Excel behaviour with this format is the same as LO Calc. Do the same formatting with a result greater than 768:00:00 in Excel and you will see the result. -- 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
