hi,
see http://www.mvps.org/dmcritchie/excel/datetime.htm

-----Original 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?
.