How can I convert or format an elapsed time to show mm:ss
 

I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or
hh:mm:ss if the number is large enough)

How can I convert or format an elapsed time to show mm:ss
 

hi
excel keeps time as a percent of a day.
12 hour = .5 day
1 hour = 0.041666667 day
1 minute =


"Mark" wrote:

I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or
hh:mm:ss if the number is large enough)

How can I convert or format an elapsed time to show mm:ss
 

With your value in A1


=A1/24/60/60


format as either [m]:ss or [h]:mm:ss

--


Regards,


Peo Sjoblom

"Mark" wrote in message
...
I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or
hh:mm:ss if the number is large enough)

How can I convert or format an elapsed time to show mm:ss
 

hi again.
clicked the wrong button on the last post. sorry.
excel keeps time as a percent of a day.
12 hours = .5 day
1 hour = 0.041666667 day or =1/24
1 minute = 0.000694444 day or =1/24/60
1 second = 0.00001157407407 day or =1/24/60/60

unless your 229.92 seconds are a decimal value of a day, you will have to do
some math.
multiply 229.92 by 0.00001157407407.
format as time. about 3 minutes 50 seconds.(00:03:50)

regards
FSt1

"Mark" wrote:

I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or
hh:mm:ss if the number is large enough)

How can I convert or format an elapsed time to show mm:ss
 

Better to divide by 86400, or by 24 and 60 and 60, rather than multiplying
by 0.00001157407407 which is an approximation.
--
David Biddulph

"FSt1" wrote in message
...
hi again.
clicked the wrong button on the last post. sorry.
excel keeps time as a percent of a day.
12 hours = .5 day
1 hour = 0.041666667 day or =1/24
1 minute = 0.000694444 day or =1/24/60
1 second = 0.00001157407407 day or =1/24/60/60

unless your 229.92 seconds are a decimal value of a day, you will have to
do
some math.
multiply 229.92 by 0.00001157407407.
format as time. about 3 minutes 50 seconds.(00:03:50)

regards
FSt1

"Mark" wrote:

I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or
hh:mm:ss if the number is large enough)

How can I convert or format an elapsed time to show mm:ss
 

hi
another way of getting at it. you might be right.

regards
FSt1

"David Biddulph" wrote:

Better to divide by 86400, or by 24 and 60 and 60, rather than multiplying
by 0.00001157407407 which is an approximation.
--
David Biddulph

"FSt1" wrote in message
...
hi again.
clicked the wrong button on the last post. sorry.
excel keeps time as a percent of a day.
12 hours = .5 day
1 hour = 0.041666667 day or =1/24
1 minute = 0.000694444 day or =1/24/60
1 second = 0.00001157407407 day or =1/24/60/60

unless your 229.92 seconds are a decimal value of a day, you will have to
do
some math.
multiply 229.92 by 0.00001157407407.
format as time. about 3 minutes 50 seconds.(00:03:50)

regards
FSt1

"Mark" wrote:

I have a value of 224.92 seconds that I want to 'convert' to mm:ss (or
hh:mm:ss if the number is large enough)