Format Cells As Fractions Of Seconds

Hi

I am trying to set up a workbook to record times for our swimming club. This will involve recording the swimmer's time as minutes, seconds, tenths and hundredths. I would then want to be able to compare the new time to the swimmer's previous personal best and calculate the difference. Does anyone know if this is possible?

Many thanks,
Fliss

Re: Format Cells As Fractions Of Seconds

Hi Robert

Thank you very much - that works perfectly. I feel a bit daft now when the answer was so simple.

Thanks again,
Fliss