|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 18th, 2008, 02:24 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
How can I enter time in Excel in 10:15:10:02 for sport timing ?
I Like to enter sports times in a excel sheet with tens off a secound how can
i do that? 
|
|
#2
October 18th, 2008, 03:22 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I enter time in Excel in 10:15:10:02 for sport timing ?
Please don't multi-post. You've got an answer elsewhere.
-- David Biddulph "Mathias" wrote in message ... I Like to enter sports times in a excel sheet with tens off a secound how can i do that?
|
|
#3
October 18th, 2008, 05:45 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I enter time in Excel in 10:15:10:02 for sport timing ?
Hi,
Well it is a multiple posting, but this one explains what you want. Choose Format, Cells, Number tab, Fractions, and on the right scroll down to As tenths (3/10) If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Mathias" wrote: I Like to enter sports times in a excel sheet with tens off a secound how can i do that?
|
|
#4
October 18th, 2008, 07:35 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I enter time in Excel in 10:15:10:02 for sport timing ?
Separate the seconds from the fractions of a second with a decimal point,
not another colon, then apply a custom number format of h:mm:ss.00 to the cell. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Mathias" wrote in message ... I Like to enter sports times in a excel sheet with tens off a secound how can i do that?
|
|
#5
October 18th, 2008, 09:09 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I enter time in Excel in 10:15:10:02 for sport timing ?
Hi,
And another FYI - you can enter fractions by typing 7 1/2 and Excel will enter it in the cell as 7.5 but display it as 7 1/2. In your case I would enter them as Jon said decimals. -- Thanks, Shane Devenshire "Mathias" wrote: I Like to enter sports times in a excel sheet with tens off a secound how can i do that?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
