ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I format a cell for 00:00:00 (minutes:seconds:100th)? (https://www.excelbanter.com/excel-discussion-misc-queries/176844-how-do-i-format-cell-00-00-00-minutes-seconds-100th.html)

dspeencer

How do I format a cell for 00:00:00 (minutes:seconds:100th)?
 
I am trying to set up a time trail grid for a swim team.

Dave Peterson

How do I format a cell for 00:00:00 (minutes:seconds:100th)?
 
mm:ss.00
or
mm:ss.000

If you sum them and want to keep seeing all the minutes:
[mm]:ss.00


dspeencer wrote:

I am trying to set up a time trail grid for a swim team.


--

Dave Peterson


All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com