Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 01 Nov 2017 09:09:15 +0100How to sum a column of hours:minutes valueshttps://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/ I want to total a column of Hours:minutes values.
If I use a1+A2+A3 etc, it works if I format the cell in which I want the total to appear as [HH]:MM:SS
But if I use the SUM function for a range of cell (much more convenient) I get the answer 00:00:00.
Is there some other function I should be using or is this a bug?
This is to total a series of glider flight durations express as hours and minutes, to get a total number of hours.Wed, 01 Nov 2017 08:39:49 +0100https://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/Comment by Mike Kaganski for <p>I want to total a column of Hours:minutes values.</p>
<p>If I use a1+A2+A3 etc, it works if I format the cell in which I want the total to appear as [HH]:MM:SS</p>
<p>But if I use the SUM function for a range of cell (much more convenient) I get the answer 00:00:00.</p>
<p>Is there some other function I should be using or is this a bug?</p>
<p>This is to total a series of glider flight durations express as hours and minutes, to get a total number of hours.</p>
https://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/?comment=136666#post-id-136666and does the source cell format change when you do that?
Please post a sample document to some share and post a link here to checkWed, 01 Nov 2017 08:53:06 +0100https://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/?comment=136666#post-id-136666Comment by Mike Kaganski for <p>I want to total a column of Hours:minutes values.</p>
<p>If I use a1+A2+A3 etc, it works if I format the cell in which I want the total to appear as [HH]:MM:SS</p>
<p>But if I use the SUM function for a range of cell (much more convenient) I get the answer 00:00:00.</p>
<p>Is there some other function I should be using or is this a bug?</p>
<p>This is to total a series of glider flight durations express as hours and minutes, to get a total number of hours.</p>
https://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/?comment=136662#post-id-136662Possibly the source cells are actually not dates, but text formatted as dates. The plus converts them implicitly, but SUM cannot.Wed, 01 Nov 2017 08:42:20 +0100https://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/?comment=136662#post-id-136662Comment by jennyg for <p>I want to total a column of Hours:minutes values.</p>
<p>If I use a1+A2+A3 etc, it works if I format the cell in which I want the total to appear as [HH]:MM:SS</p>
<p>But if I use the SUM function for a range of cell (much more convenient) I get the answer 00:00:00.</p>
<p>Is there some other function I should be using or is this a bug?</p>
<p>This is to total a series of glider flight durations express as hours and minutes, to get a total number of hours.</p>
https://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/?comment=136663#post-id-136663I tried formatting the source cells as [hh]:mm as well but same result.Wed, 01 Nov 2017 08:45:12 +0100https://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/?comment=136663#post-id-136663Comment by jennyg for <p>I want to total a column of Hours:minutes values.</p>
<p>If I use a1+A2+A3 etc, it works if I format the cell in which I want the total to appear as [HH]:MM:SS</p>
<p>But if I use the SUM function for a range of cell (much more convenient) I get the answer 00:00:00.</p>
<p>Is there some other function I should be using or is this a bug?</p>
<p>This is to total a series of glider flight durations express as hours and minutes, to get a total number of hours.</p>
https://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/?comment=136669#post-id-136669I don't think it did, but how can you tell?Wed, 01 Nov 2017 09:09:15 +0100https://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/?comment=136669#post-id-136669Answer by jennyg for <p>I want to total a column of Hours:minutes values.</p>
<p>If I use a1+A2+A3 etc, it works if I format the cell in which I want the total to appear as [HH]:MM:SS</p>
<p>But if I use the SUM function for a range of cell (much more convenient) I get the answer 00:00:00.</p>
<p>Is there some other function I should be using or is this a bug?</p>
<p>This is to total a series of glider flight durations express as hours and minutes, to get a total number of hours.</p>
https://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/?answer=136667#post-id-136667I think I have solved the problem myself after reading Mike's comment.
The list of times was imported from a csv file - ticking the option "detect special numbers" at the import stage seems to make the SUM function handle them correctly, as long as the total cell is formatted [HH]:MM:SS
Thanks Mike KaganskiWed, 01 Nov 2017 09:03:09 +0100https://ask.libreoffice.org/en/question/136661/how-to-sum-a-column-of-hoursminutes-values/?answer=136667#post-id-136667