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

M

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)
 
F

FSt1

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

Peo Sjoblom

With your value in A1


=A1/24/60/60


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

--


Regards,


Peo Sjoblom
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert time 2
Custom format mm:ss 3
Time format conversion 7
How do I convert time as text 'mm:ss to time value in Excel 5
Converting time (raw) into ss:mm 1
convert to mm:ss to just seconds 1
How to calculate speed given distance and mm:ss time format? 1
Time Format 4

Top