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.

formatting cells for minutes:seconds
 

Enter it as 0:17:05 and format it as [mm]:ss

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"b" wrote in message
...
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.