| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display minutes more than 60
How do I display the length of a time interval of more than 60 minutes as
mmm:ss? (i.e., don't roll over 60 minutes to one hour). And if you will say just convert the time value from days to minutes, you would lose the mm:ss format (60:30 would be displayed as 60.5); I am looking to have more than 60 minutes while maintaining separation of the seconds. A similar question for hours more than 24. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display minutes more than 60
Hi,
This will display minutes greater than 60 whilst maintaining seconds. [mm]:ss Similar approach can be used for hours. [hh]:mm:ss Cheers Andy hmm wrote: How do I display the length of a time interval of more than 60 minutes as mmm:ss? (i.e., don't roll over 60 minutes to one hour). And if you will say just convert the time value from days to minutes, you would lose the mm:ss format (60:30 would be displayed as 60.5); I am looking to have more than 60 minutes while maintaining separation of the seconds. A similar question for hours more than 24. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display minutes more than 60
Try:
[mm]:ss or [m]:ss hmm wrote: How do I display the length of a time interval of more than 60 minutes as mmm:ss? (i.e., don't roll over 60 minutes to one hour). And if you will say just convert the time value from days to minutes, you would lose the mm:ss format (60:30 would be displayed as 60.5); I am looking to have more than 60 minutes while maintaining separation of the seconds. A similar question for hours more than 24. Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display minutes ONLY and calc difference | Excel Discussion (Misc queries) | |||
| Hours and minutes display as date in formula box | Excel Discussion (Misc queries) | |||
| display minutes and seconds in excel | Excel Worksheet Functions | |||
| How do I display the h:mm minutes in hundreds? | Excel Worksheet Functions | |||
| How do I get a cell to display degrees, minutes, seconds? | Excel Worksheet Functions | |||
Linear Mode
