About Us

Mazzaropi

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formating tenths and hundreds to show as whole numbers	Nelson B.	Excel Discussion (Misc queries)	3	March 15th 10 08:00 PM
hundreds separator	Viraj Nayaka	Excel Discussion (Misc queries)	2	September 6th 06 12:09 PM
Convert Hundreds to Thousands	abs	Excel Discussion (Misc queries)	2	April 5th 06 05:06 PM
Show timesheet time in and out in regular time versus military tim	John	Excel Worksheet Functions	1	November 11th 05 05:14 AM
Excel should let me enter time in one hundreds of a second.	mrvw	Excel Discussion (Misc queries)	3	August 31st 05 05:47 PM