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.

Hi,

Format you cell with

mm:ss.000



Mike



"Fonz" wrote:

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.

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

"Mike H" wrote in message
...
Hi,

Format you cell with

mm:ss.000



Mike



"Fonz" wrote:

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



"Mike H" wrote:

Hi,

Format you cell with

mm:ss.000



Mike



"Fonz" wrote:

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.

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" wrote:

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" wrote:

Hi,

Format you cell with

mm:ss.000



Mike



"Fonz" wrote:

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, 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" wrote:

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

Glad I could help

"Fonz" wrote:

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" wrote:

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