Thread: How can I enter time in Excel in 10:15:10:02 for sport timing ?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default How can I enter time in Excel in 10:15:10:02 for sport timing ?
Separate the seconds from the fractions of a second with a decimal point,
not another colon, then apply a custom number format of h:mm:ss.00 to the
cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mathias" wrote in message
...
I Like to enter sports times in a excel sheet with tens off a secound how
can
i do that?


Reply With QuoteReply With Quote