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.