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
Quote:
Originally Posted by Tom Connell
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
|