Display minutes more than 60

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

Andy Pope

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
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Start Time to End Time... Minutes On Each Hour... How to distribute proportionately? 5
Working with duration data 3
Calculating hours on a timeclock form 7
minutes seconds days weeks years 2
Time Function 3
Calculating number of hours and minutes 6
Adding minutes & seconds 5
dividing a number into hours and minutes 1

Top