formatting cells for minutes:seconds

Giganews Newsgroups
Subject: formatting cells for minutes:seconds
Posted by:  B
Date: Wed, 10 May 2006

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.

Replies