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

[Mark]

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)

 

[FSt1]

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

 

[Peo Sjoblom]

With your value in A1


=A1/24/60/60


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

--


Regards,


Peo Sjoblom

 

[FSt1]

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

 

[David Biddulph]

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

 

[FSt1]

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

regards
FSt1