<div>
hmharvey,<br />
<br />
Sorry, but to the best of my knowledge there is no built in method to accomplish this in Excel. <br />
<br />
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 &nbsp;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.<br />
<br />
If you are just imputting them for display purposes (no calculations or graphs, etc.) then entering them as text would work.<br />
<br />
Wish I had a better answer for you, but I don't. &nbsp;Maybe someone else will.<br />
<br />
Steve<br />

</div>


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


<div>
<div class="content wysiwyg-content">
Is there a way to format an excel cell to track Minutes:seconds:hundredths<wbr /> of a second. This is for keeping times for a track team.
</div>
</div>


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.

format for doing Hundredths of a second in Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.