Incorrect average of time in Calc

[alderek]

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?

[erAck]

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.

[alderek]

That first 7:50:00 AM entry was actually 31:50:00! Thanks for the help!