I am having a little trouble with this one. I need to find the average of 1500 given times. It's in the format of hours:minutes:seconds How do i configure the average function to work with this format?
It can't be that hard. Convert the time to a single unit, average them, then convert it back to the original time convention.
not gonna do the punk thing with the let me google that for you.. but seriously, there are certain things that are really easy to google. use google and "average time excel" and see what comes up here's one link with an answer that is probably easy to try: http://in.answers.yahoo.com/question/index?qid=20080809131807AAU73Z0 A lot of links came up..many of which are probably useful
If you weren't able to use kaleidosky's link, then post on here how you have them listed. Are the hours/minutes/seconds in separate cells? Or are they all in 1 cell? That will make a big difference on how this is done. Usually you can use the average function. It would be: =average(list or highlight your cells, ex. a1:a1501) That may do the trick, unless the times are listed separately, in their own cells. Pugs
They were listed in one cell in hr:min:second format. I pretty much had to highlight the column and went Data-> Text to columns-> kept delimited and selected next-> deselected tab and inserted ":" in the other option-> Finish This broke it down to seconds, minutes and hours in individual cells. It was not difficult to find the average once I had it in this format. I still don't understand how you would still be able to straight up use the average function with the given format.
