show time to hundreds of a second
 

I'm sure this has been asked before but I do need help.
I'm a college athlete and need to keep a record of my times. If I use Excel to input my time of 1minute 48.76 seconds it usually displays as a date. How can I display my times down to hundreds of a second? (1.48.76 or 01.48.76) 1 minute 48 point 76 seconds. Thank you in advance x

Dear Tom Connell, Good Afternoon

You can use Cell Formatting to do this one.

Menu -- Format -- Number -- Personalized
Type: mm.ss,00

Try this one.
Tell me if it worked for you.

I hope it can helped you.

____________________________
Minas Gerais, Brasil
Mazzaropi