Formating seconds into mm:ss

  • Thread starter Thread starter Nelson B.
  • Start date Start date
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!
 
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
 
Hi,

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

=A1/(60*60*24)

Format as [mm]:ss

Mike
 
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!
Click to expand...
Click to expand...
 
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!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top