Formating seconds into mm:ss
 

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!

Formating seconds into mm:ss
 

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

On Dec 14, 2:26*pm, Nelson B.
wrote:
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!

Formating seconds into mm:ss
 

Hi,

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

=A1/(60*60*24)

Format as [mm]:ss

Mike

"Nelson B." wrote:

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!

Formating seconds into mm:ss
 

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" wrote:

Hi,

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

=A1/(60*60*24)

Format as [mm]:ss

Mike

"Nelson B." wrote:

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!

Formating seconds into mm:ss
 

Hi,

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


Mike



"Nelson B." wrote:

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" wrote:

Hi,

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

=A1/(60*60*24)

Format as [mm]:ss

Mike

"Nelson B." wrote:

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!