S
swimtimes
How do I format cells in Excel spreadsheet for time in minutes, seconds, and
hundreds of seconds specifically for logging swim times?
hundreds of seconds specifically for logging swim times?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ragdyer
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
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
S
swimtimes
Thank you!
Ragdyer said: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 said:How do I format cells in Excel spreadsheet for time in minutes, seconds, and
hundreds of seconds specifically for logging swim times?
V
Very Timely
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?
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 said:Thank you!
Ragdyer said: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 said:How do I format cells in Excel spreadsheet for time in minutes, seconds, and
hundreds of seconds specifically for logging swim times?