I cannot locate the cell format option [hh]:mm:ss in OpenOffice. It is possible we are using different versions (mine is OpenOffice.org core 1:2.3.0-lubuntu 5.3, Tue Nov 27 18:52:42 GMT 2007).
I have tried all the different time format and custom format options in Excel, and the behaviour of the spreadsheet does not change. The sum function always adds to the correct total time (72:32:00). Perhaps the sum resetting at 24:00 is the way Calc is suppose work! On Wed, 2008-02-27 at 04:12 +0000, Brian Murray wrote: > I see what you are saying but I'm still curious as to how the cells are > formatted in Excel though. Additionally looking in the help of > OpenOffice.org I found that the time format "hh" is defined as 0 to 23 > which I think helps to explain the behavior you are seeing. After > changed all the cells to "[hh]:mm:ss" the preview summing feature in the > bottom right behaved as expected. > -- Spreadsheet time "sum" resets at 24:00 https://bugs.launchpad.net/bugs/180937 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
