formatting cells for minutes:seconds

[b]

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.

 

[Peo Sjoblom]

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com