Display minutes more than 60

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Try:
[mm]:ss
or
[m]:ss


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.
Click to expand...
 
Back
Top