Calculating the minimum value from a range of times

  • Thread starter Thread starter afarrow
  • Start date Start date
A

afarrow

I'm running a spreadsheet to record my daughters swimming times in mm.ss.0
format and want to be able to identify the minimum value representing her
personal best time. The MIN function doesn't seem to work against this
format. Can anyone suggest an alternative way?
 
I'm running a spreadsheet to record my daughters swimming times in mm.ss.0
format and want to be able to identify the minimum value representing her
personal best time. The MIN function doesn't seem to work against this
format. Can anyone suggest an alternative way?
Click to expand...

It's always helpful if you give us your formula and describe the problem.
"doesn't seem to work" is not very useful.

So I will try to guess at what the problem might be:

Formatting only affects how a value is displayed.

If you enter a string in the format of mm.ss.0 it will be a text string and not
a time.

Enter her times as mm:ss.0 (you can still format them as mm.ss.0) and they
will be interpreted as time and the MIN function should work.
--ron
 
Enter the times as real times:
mm:ss.0
(remember to format the cells to show what you want, too)
 
afarrow,
I used your format of time (mm:ss.0) in a column B1 thru B7.
In B7 the formula "=MIN(B1:B6)"
I then entered data and it updated as I put data in.
hth
 
Back
Top