how can I work with lap times?

[Fonz]

I need to format and work with lap times in the form mm:ss:ttt (minutes,
seconds and thousandths). I cannot find out how to format these so that I can
perform comparisons on them and draw up charts. Can anybody help me? I know
about "Format Cells" of course but don't seem to find any suitable choices
listed.

 

[Mike H]

Hi,

Format you cell with

mm:ss.000



Mike

 

[David Biddulph]

.... or [mm]:ss.000 if the number might go beyond 60 minutes.

 

[Fonz]

Thanks, Mike, I now have my cells formatted properly (or so I thought) but
when I use the =min() function on a column of lap times, I get 00:00.000 as
the result! Any ideas? There are no blank cells in the column and none of my
lap times are zero (I'm not that fast!)

Fonz

 

[Mike H]

It sounds like there's still something wrong with the cell format because
=Min(.. should work ok

Try this on your times
=ISNUMBER(A1)
it should evaluate as true.

If it doesnt your cells were probably formatted as text before you entered
any numbers. To overcome this delete the cell contents. format with the time
formula and re-enter the time value

Mike

 

[Fonz]

Mike H, I am in your debt. You were spot on, the values I had did not match
the new formats I gave the cells. Silly me! Thanks again.

Fonz

 

[Mike H]

Glad I could help

Mike H, I am in your debt. You were spot on, the values I had did not match
the new formats I gave the cells. Silly me! Thanks again.

Fonz