Posted to microsoft.public.excel.programming
|
|
In Excel how do I format swimming times - mm.ss.100ths
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?
.
|