Averaging times (similar to lap times)
 

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

Averaging times (similar to lap times)
 

format cells as:

mm:ss.000


"cqmman" wrote:

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