Averaging times (similar to lap times)

  • Thread starter Thread starter cqmman
  • Start date Start date
C

cqmman

Hello, I have some dates like this:

1:54.334
1:54.442
1:54.553

I want to average the three, and then work out the difference with
another three. The big problem seems to be the rounding. When I change
the cells to time format, they just go to 00:01:55. (or :54). Not
really what I want.

What is the best way to do this?

It is excel 2003.

Cheers
 
Back
Top