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.
|