Solved

format for doing Hundredths of a second in Excel

Posted on 1998-06-15
2
555 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Office 365 Training for Admins

Learn how to provision tenants, synchronize on-premise Active Directory, and implement Single Sign-On with these master level course.  Only from Platform Scholar

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…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

740 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