Thread: How can I enter time in Excel in 10:15:10:02 for sport timing ?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
  
Posts: 2,344
Default How can I enter time in Excel in 10:15:10:02 for sport timing ?
Hi,

And another FYI - you can enter fractions by typing 7 1/2 and Excel will
enter it in the cell as 7.5 but display it as 7 1/2. In your case I would
enter them as Jon said decimals.

--
Thanks,
Shane Devenshire


"Mathias" wrote:

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