| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering in Minutes and Seconds
Hi all
I have formatted the cell from the Custom in cells to MM:SS. But it does not appear to be the correct way as the results are not correct when I enter them Hope you can help Stew |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering in Minutes and Seconds
Suppose you want to put 45:00 in the cell - you need to enter it
EITHER as 0:45:00 OR as 45:00.0 (i.e. with a leading 0: to indicate zero hours, or with a trailing .0 to indicate zero fractions of a second). If you just enter 45:00 then Excel will assume this means 45:00:00, which is not what you want. Hope this helps. Pete On Jan 9, 4:44*pm, stew wrote: Hi all I have formatted the cell from the Custom in cells to MM:SS. But it does not appear to be the correct way as the results are not correct when I enter them Hope you can help Stew |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering in Minutes and Seconds
Thanks Pete
Stew "Pete_UK" wrote: Suppose you want to put 45:00 in the cell - you need to enter it EITHER as 0:45:00 OR as 45:00.0 (i.e. with a leading 0: to indicate zero hours, or with a trailing .0 to indicate zero fractions of a second). If you just enter 45:00 then Excel will assume this means 45:00:00, which is not what you want. Hope this helps. Pete On Jan 9, 4:44 pm, stew wrote: Hi all I have formatted the cell from the Custom in cells to MM:SS. But it does not appear to be the correct way as the results are not correct when I enter them Hope you can help Stew |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering in Minutes and Seconds
You're welcome, Stew.
Pete On Jan 9, 5:38*pm, stew wrote: Thanks Pete Stew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a minutes and seconds as a 2400 time to seconds? | Excel Worksheet Functions | |||
| Entering Minutes:Seconds | New Users to Excel | |||
| Entering Seconds but displaying minutes & seconds | Excel Discussion (Misc queries) | |||
| Entering minutes and seconds | Excel Discussion (Misc queries) | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Linear Mode
