We will be migrating from Ask to Discourse on the first week of August, read the details here

Incorrect average of time in Calc [closed]

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?

edit retag reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck close date 2019-08-14 13:13:11.723480

Sort by » oldest newest most voted

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

Apply the duration time format [HH]:MM:SS to B10:B18 to see which of the values it is.

more