Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 564
  • Last Modified:

format for doing Hundredths of a second in Excel

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
hmharvey
Asked:
hmharvey
1 Solution
 
shalbeCommented:
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
 
the_whelkCommented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now