Thread: formatting cells for minutes:seconds
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
b
 
Posts: n/a
Default formatting cells for minutes:seconds
How can I format a cell for minutes and seconds? When I enter in 17:05
(minutes:seconds) it shows up as 5 hrs 5 minutes 0 seconds. If I reformat
the cell for mm:ss, it shows up as 05:00.

Reply With QuoteReply With Quote