Hi,
I am looking for a way to calculate the average time, over a number of times.
So basically, would have different times in 24 hour hh:mm:ss, all in column i.
I have tried =AVERAGE(i2:i18) and it doesn't work.
I have also tries Ctrl/Shift enter as an array, it didn't work.
I tries to format cells as time and number, it didn't work!
Where am I going wrong?
=AVERAGE(i2:i18) should work fine. What does "doesn't work" mean? Does your data have dates, or just times? It is possible to have a date/time like
4/28/2014 13:00:00
but display it as
13:00:00
and if you average a bunch of those it will also average the dates, not just the times. So what is in your data?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks