Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sports time entering
how can I enter sports timing in a spread sheet
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |