convert Seconds to Minutes

  • Thread starter Thread starter Jon Brett
  • Start date Start date
J

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
 
Hi

You need to divide your initial figure (80) by 86400 (60*60*24) and then
format the result as mm:ss
 
You must log in or register to reply here.

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

Need to convert Minutes:Seconds format to minutes with seconds con 2
convert decimal figure to minutes and seconds 3
Using time formats in minute units 4
convert minutes to seconds 2
Timeformat (mm:ss) 4
Create a custom format to convert seconds to minutes. 3
Adding Minutes & Seconds expressing time differnce if total is over an hour 2
Change Time Format to only seconds 3

Back
Top