View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gfkbob[_2_] gfkbob[_2_] is offline
external usenet poster
 
Posts: 5
Default Displaying Time in Excel

I would like to display time in minutes and seconds only even if over
an hour. If the amount of time is 65 minutes I would like it
displayed as 65:00 not 1:05:00. Is this possible in excel?