There seems to be some confusion on what DD HH:MM:SS actually shows. It shows the date based off the basis day of 1899-12-30, which means 31 is correct.
** Changed in: openoffice.org (Ubuntu) Status: Incomplete => Invalid -- [upstream] [hardy] oo-calc - formatting cell from decimal number to format "dd:hh:mm:ss" report wrong day https://bugs.launchpad.net/bugs/238822 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs