If you are only recording seconds and tenths then you will only need to enter
normal numbers i.e.45.6, 52.4 etc. In the next column you could enter a
formula such as =SUM($A$1:A1)/COUNT($A$1:A1) then copy it down. The $A$1
will remain static so the sum will include the next cell in the column and
you will be dividing by the number of cells which will also increment down
the column.

"M.A.Tyler" wrote:

I would like to know the best method to average time. I would ideally like to
keep the time in seconds.tenths [sss.0]. Additionally I would like to keep a
rolling average of the compiled results. So that as new results are added
they will be calculated with the old results, and produce a possible new
average, to be saved until the next set of results are added. Is this
possible? And can this be somewhat automated?