how can I work with lap times?

  • Thread starter Thread starter Fonz
  • Start date Start date
F

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.
 
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
 
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
 
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
 
Glad I could help

Fonz said:
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
Click to expand...
 
Back
Top