Description: Adding times (SUM()) leads to wrong results (especially if blank lines are involved). Example time-value: 08:04:00 Steps to Reproduce: 1. times (like 08:05:00) in cells in one column under each other 2. put randomly empty cells between them (up to 3 empty cells f.e.) 3. after 10 or more values build the sum of them Actual Results: incorrect sums Expected Results: correct sums Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Firefox/45.0
Please upload a sample file with an incorrect sum. Note that cell should be formatted as Time / [HH]:MM:SS, otherwise time is displayed modulo 24h.
Created attachment 130216 [details] file that proofs the bug Sample file for the time sum bug.
This is exactly caused by what I described, the cell format is not Time / [HH]:MM:SS, adjust it, and you'll see the expected results. Now it shows time as you'd see on a clock, eg. between 0-24h.
Actually the in the sum involved cells b2 to b11 are of format time (hh:mm:ss).
Read this: http://superuser.com/questions/387106/libreoffice-calc-how-to-get-total-for-hhmmss-cells
Tanks for the link. Time format 8766113:37:46 (Format code [HH]:MM:SS) leads to the same result. Is it possible that LibreOffice adds those values as times of the day (times of the clock), but not as times like a sum of hours and minutes?
Are you sure the result field is formatted [HH]:MM:SS? That's what matters. If I open the attached file, and change B13's format to [HH]:MM:SS, it displays the expected 43:10:00 value.
Yes. Finally I got the same result. I summarize: Give all number involved in the sum of times the format hh:mm:ss (cells b2 to b12). The cell with the sum result needs the format [hh]:mm:ss. And voilá the times are added correctly. Thanks a lot.
Note that the summarized times can be formatted any way you want, since it only affects how the time is displayed, and for times between 00:00:00 and 23:59:59 the two formats display the same.