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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
