formatting cells for minutes:seconds

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top