Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 13 Aug 2019 17:32:43 +0200Incorrect average of time in Calchttps://ask.libreoffice.org/en/question/204492/incorrect-average-of-time-in-calc/ In calc, I have a column showing times of arrival:
8:00:00 AM
7:50:00 AM
7:55:00 AM
7:50:00 AM
8:20:00 AM
8:00:00 AM
8:05:00 AM
8:05:00 AM
8:00:00 AM
At the bottom of the column, I have a column with the calculation: =AVERAGE(B10:B18). The result that it gives me is "10:40:00 AM". Unless I've made a dumb mistake...that's not right. Just by doing some of the math by hand, that should be ~"8:00:00 AM".
All of this is imported from excel, where the formula worked.
Is there another formula that I should be using?Tue, 13 Aug 2019 15:42:03 +0200https://ask.libreoffice.org/en/question/204492/incorrect-average-of-time-in-calc/Answer by erAck for <p>In calc, I have a column showing times of arrival:</p>
<p>8:00:00 AM</p>
<p>7:50:00 AM</p>
<p>7:55:00 AM</p>
<p>7:50:00 AM</p>
<p>8:20:00 AM</p>
<p>8:00:00 AM</p>
<p>8:05:00 AM</p>
<p>8:05:00 AM</p>
<p>8:00:00 AM</p>
<p>At the bottom of the column, I have a column with the calculation: =AVERAGE(B10:B18). The result that it gives me is "10:40:00 AM". Unless I've made a dumb mistake...that's not right. Just by doing some of the math by hand, that should be ~"8:00:00 AM".</p>
<p>All of this is imported from excel, where the formula worked.</p>
<p>Is there another formula that I should be using?</p>
https://ask.libreoffice.org/en/question/204492/incorrect-average-of-time-in-calc/?answer=204502#post-id-204502Make sure one of the values isn't actually 24 hours plus the displayed time, for example 32:00:00 instead of 8:00:00, which would give 10:40:33 instead of 8:00:33
Apply the duration time format `[HH]:MM:SS` to B10:B18 to see which of the values it is.
Tue, 13 Aug 2019 16:28:37 +0200https://ask.libreoffice.org/en/question/204492/incorrect-average-of-time-in-calc/?answer=204502#post-id-204502Comment by alderek for <p>Make sure one of the values isn't actually 24 hours plus the displayed time, for example 32:00:00 instead of 8:00:00, which would give 10:40:33 instead of 8:00:33</p>
<p>Apply the duration time format <code>[HH]:MM:SS</code> to B10:B18 to see which of the values it is.</p>
https://ask.libreoffice.org/en/question/204492/incorrect-average-of-time-in-calc/?comment=204519#post-id-204519That first 7:50:00 AM entry was actually 31:50:00! Thanks for the help!Tue, 13 Aug 2019 17:32:43 +0200https://ask.libreoffice.org/en/question/204492/incorrect-average-of-time-in-calc/?comment=204519#post-id-204519