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

Ask Your Question

Incorrect average of time in Calc [closed]

asked 2019-08-13 15:42:03 +0200

alderek gravatar image

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 flag offensive 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

1 Answer

Sort by » oldest newest most voted

answered 2019-08-13 16:28:37 +0200

erAck gravatar image

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.

edit flag offensive delete link more


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

alderek gravatar imagealderek ( 2019-08-13 17:32:43 +0200 )edit

Question Tools

1 follower


Asked: 2019-08-13 15:42:03 +0200

Seen: 199 times

Last updated: Aug 13 '19