View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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.