How to format cells in Excel for time in format mm:ss.00
 

I need to record times in the format mm:ss then convert these to seconds to
manipulate them, however when I format my cells as this:[mm]:ss.0 my format
does not seem to follow. If I enter 1:00.0 (for 1 minute) into the cell, I
get: 12:01:00 AM in the formula bar. When I convert this to seconds (via this
formula =CONVERT(B3,"mn","sec")), I get 0.041667 when I should get 60
seconds. Any clues?

"swimtimes" wrote:

Thank you!

"Ragdyer" wrote:

Make a custom format exactly as you did in your subject line.

If you're going to add them up, you could perhaps prevent the minutes from
rolling over into hours with this slight modification:

[mm]:ss.00
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"swimtimes" wrote in message
...
How do I format cells in Excel spreadsheet for time in minutes, seconds,
and
hundreds of seconds specifically for logging swim times?