View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default sports time entering

Hi,

What do you mean by "sports time"?

If you are trying to display times in hours, minutes and seconds then choose
Format, Cells, Number tab, Time, and scroll down to the bottom on the right
until you see 30:55.2 or 37:30:55 or you can make your own custom format.
--
Thanks,
Shane Devenshire


"Mathias" wrote:

how can I enter sports timing in a spread sheet