Formating seconds into mm:ss

N

Nelson B.

How do you format a cell to convert a "seconds" input into minutes and
seconds? Whenever I try to select the format mm:ss, it converts into a date
with the month and year etc.

Thanks!
 
P

Pete_UK

If you have seconds as an integer in cell A1, put this in B1:

=A1/60/60/24

and apply a custom format to cell B1 of:

[mm]:ss

Times are stored internally in Excel as fractions of a 24-hour day,
hence the need for those divisions.

Hope this helps.

Pete
 
M

Mike H

Hi,

I assume these 'seconds' are simply numbers so try this

=A1/(60*60*24)

Format as [mm]:ss

Mike
 
N

Nelson B.

Thanks for the help. This works, but I was hoping to be able to simply
change the format of a cell, so an input of 80 sec would show as 01:20. Is
that possible or does it require the use of a formula?

Mike H said:
Hi,

I assume these 'seconds' are simply numbers so try this

=A1/(60*60*24)

Format as [mm]:ss

Mike

Nelson B. said:
How do you format a cell to convert a "seconds" input into minutes and
seconds? Whenever I try to select the format mm:ss, it converts into a date
with the month and year etc.

Thanks!
 
M

Mike H

Hi,

I don't believe that is possible to do as a format.


Mike



Nelson B. said:
Thanks for the help. This works, but I was hoping to be able to simply
change the format of a cell, so an input of 80 sec would show as 01:20. Is
that possible or does it require the use of a formula?

Mike H said:
Hi,

I assume these 'seconds' are simply numbers so try this

=A1/(60*60*24)

Format as [mm]:ss

Mike

Nelson B. said:
How do you format a cell to convert a "seconds" input into minutes and
seconds? Whenever I try to select the format mm:ss, it converts into a date
with the month and year etc.

Thanks!
 

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

Top