Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
how can I enter sports timing in a spread sheet
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Entering Time | Excel Discussion (Misc queries) | |||
Entering time | Excel Discussion (Misc queries) | |||
Code for entering time - trying again | Excel Discussion (Misc queries) | |||
Entering Time Macro | Excel Worksheet Functions | |||
Entering and Adding Time | Excel Worksheet Functions |