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. |
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. |
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 |
All times are GMT +1. The time now is 04:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com