We help IT Professionals succeed at work.

format for doing Hundredths of a second in Excel

hmharvey
hmharvey asked
on
686 Views
Last Modified: 2008-02-01
Is there a way to format an excel cell to track Minutes:seconds:hundredths of a second. This is for keeping times for a track team.
Comment
Watch Question

Commented:
hmharvey,

Sorry, but to the best of my knowledge there is no built in method to accomplish this in Excel.

It may be able to be done using a macro depending on what you want to do. The only way I can think of off hand would be a macro that changes your entries into decimal seconds and stores the result in another sheet but then displays the result as text in the format you want on your main sheet. The macro would then look to the other sheet for numbers to  do calculations and then update the text entries displayed in your format. Depending on what you're doing with the numbers, it could get tricky.

If you are just imputting them for display purposes (no calculations or graphs, etc.) then entering them as text would work.

Wish I had a better answer for you, but I don't.  Maybe someone else will.

Steve
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.