View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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