In Excel how do I format swimming times - mm.ss.100ths
 

MIN should work.

time is stored as a fraction of a 24 hour day, so regardless of what time
you are storing, it should work.

format the cell with the MIN formula using a custom number format like

mm:ss.0



--
Regards,
Tom Ogilvy


"Vistadelmare" wrote in message
...
I want to make a record of swimming times for swimmers in the Club. I
need
to calculate the P.B. (minimum time out of those listed) and I assume I
use
the =MIN(-,-) formula. BUT it doesn't appear to work because I can't get
the
format to be understood as minutes, seconds and 100ths of seconds.

Alternatively, does anyone have a setup they are prepared to share with
me?