up vote 1 down vote favorite
share [g+] share [fb]

I am trying to average time. The time format in the cells are 0:00:00. I have changed the number section at the top to time however I keep getting 00:00:00 as the answer.

link|improve this question
3  
What is your question about? Excel? – David Schwartz Jan 28 at 4:24
4  
Which program are you using? Excel? – iglvzx Jan 28 at 4:25
5  
It's meaningless to talk about averaging time. Do you mean taking the average of several time INTERVALS? – DanH Jan 28 at 4:44
3  
Do you have an example of that data that you are using? I opened my Excel, put in about 8 rows with your format 0:00:00 and used the following formula: =AVERAGE(B3:B9) where B3:B9 was the range of column data to average. And the result came back properly. So if we could see what your data was, that would be great, and let us know if it's a conversion issue, or what ever else. – zackrspv Jan 28 at 10:36
Without clarification this question is incomplete. We need to know details: your values, your "average" function, and what program (Excel, LibraOffice, so on). – Mokubai Jan 28 at 14:02
feedback

2 Answers

up vote 2 down vote

I think you might be doing some thing wrong.

Refer to the screenshot of my samples with the formulas.

enter image description here

link|improve this answer
feedback
up vote 0 down vote

It is likely that Excel does not recognize your times as times. To test change the number format of your time entries to "Number". This should cause your time values to change to a decimal number. If they still appear to be time values, Excel likely understands them as text values.

link|improve this answer
That's possible, Pynner, but if none of the times were recognised as numbers then the result of a simple AVERAGE would be #DIV/0 not zero.....unless the formula used is not a simple average – barry houdini Jan 30 at 12:20
good call... I hadn't really thought of that – Pynner Jan 30 at 18:33
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.