View Single Post
  #3   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,

Well it is a multiple posting, but this one explains what you want.

Choose Format, Cells, Number tab, Fractions, and on the right scroll down to
As tenths (3/10)


If this helps, please click the Yes button.
--
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?