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.

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"b" <[email protected]> wrote in message
news:[email protected]...
> 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.
>