convert Seconds to Minutes

[Jon Brett]

Is there a way of automatically converting seconds (integer) to
display minutes:seconds in a cell?

E.G. 80 becomes 1:20

I've had a look at the cell format options and I can't work it out.

Thanks,

Jon Brett

 

[Andy B]

Hi

You need to divide your initial figure (80) by 86400 (60*60*24) and then
format the result as mm:ss

 

[Norman Harker]

Hi Jon:

Use:
=A1/(24*60*60)
Format mm:ss