sports time entering

[Mathias]

how can I enter sports timing in a spread sheet

 

[Mike H]

Hi,

What times?
Format a cell with [hh]:mm:ss.000
and enter the times.

Mike

 

[ShaneDevenshire]

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.