View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mftr mftr is offline
external usenet poster
 
Posts: 2
Default Time format conversion

How can I convert a three digit seconds figure to minutes and seconds in a
mm:ss format (i.e. 162 seconds as 2:42)? I can get the right raw number by
dividing by 1440, but that seems to produce an h:mm format, albeit with the
right digits.