ExcelBanter - sports time entering

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sports time entering (https://www.excelbanter.com/excel-discussion-misc-queries/206888-sports-time-entering.html)

Mathias

sports time entering

how can I enter sports timing in a spread sheet

Mike H

sports time entering

Hi,

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

Mike

"Mathias" wrote:

how can I enter sports timing in a spread sheet

ShaneDevenshire

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

All times are GMT +1. The time now is 06:14 AM.