Solved

format for doing Hundredths of a second in Excel

Posted on 1998-06-15
2
544 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.
0
Comment
Question by:hmharvey
2 Comments
 
LVL 3

Expert Comment

by:shalbe
ID: 1609591
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
0
 
LVL 2

Accepted Solution

by:
the_whelk earned 50 total points
ID: 1609592
You can achieve this in the formatting of the cells as follows.

Number format codes for dates and times

·      To display days, months, and years, include the following format codes in a section. If you use m immediately after the h or hh format code, Microsoft Excel displays the minute instead of the month.

To display      Use this format code

Months as 1-12      m
Months as 01-12      mm
Months as Jan-Dec      mmm
Months as January-December      mmmm
Days as 1-31      d
Days as 01-31      dd
Days as Sun-Sat      ddd
Days as Sunday-Saturday      dddd
Years as 00-99      yy
Years as 1900-2078      yyyy
·      To display hours, minutes, and seconds, include the following format codes in a section.

To display      Use this format code

Hours as 0-23      h
Hours as 00-23      hh
Minutes as 0-59      m
Minutes as 00-59      mm
Seconds as 0-59      s
Seconds as 00-59      ss
Hours as 4 AM      h AM
Time as 4:36 pm      h:mm pm
Time as 4:36:03 p      h:mm:ss p
Hours as 25.02      [h]:mm
Minutes as 63:46      [mm]:ss
If the format contains an AM or PM, the hour is based on the 12-hour clock, where AM, am, A, or a indicates times from midnight until noon, and PM, pm, P, or p indicates times from noon until midnight. Otherwise, the hour is based on the 24-hour clock. The m or mm must appear immediately after the h or hh format code, or Microsoft Excel displays the month rather than the minute.
You can also use the decimal point to create time formats that display fractions of a second.

To display hours greater than 24, or minutes or seconds greater than 60, place brackets around the leftmost part of the time code. For example, the time code [h]:mm:ss allows the display of hours greater than 24.

As it says above you can achieve a display showing fractions of a second 1/100ths by using a decimal point in that formatting.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
My experience with Windows 10 over a one year period and suggestions for smooth operation
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now