| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I format an cell in excell:10min50Sec 88hundreths of a Sec
I would like to write 10:50:88 so that Excel understands that I mean
10 minutes 50 Seconds and 88 of a second: mm:ss + what? Do you know how to format? |
|
#2
|
|||
|
|||
|
Format as mm:ss.00 and enter 10:55.88 (note the period instead of colon)
-- Kind regards, Niek Otten Microsoft MVP - Excel "Alfred Nobel" <Alfred wrote in message ... I would like to write 10:50:88 so that Excel understands that I mean 10 minutes 50 Seconds and 88 of a second: mm:ss + what? Do you know how to format? |
|
#3
|
|||
|
|||
|
Thanks a lot Niek Otten, that did the trick!
"Niek Otten" wrote: Format as mm:ss.00 and enter 10:55.88 (note the period instead of colon) -- Kind regards, Niek Otten Microsoft MVP - Excel "Alfred Nobel" <Alfred wrote in message ... I would like to write 10:50:88 so that Excel understands that I mean 10 minutes 50 Seconds and 88 of a second: mm:ss + what? Do you know how to format? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
| how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| How do I format a value when using it within a cell reference tha. | Excel Worksheet Functions | |||
| How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
Linear Mode
