converting seconds into minutes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a number of seconds eg 186.4 in one cell and would like to convert
this into minutes & seconds eg 03:06.4. Can this be done, I have tried
formatting and the TIME and CONVERT functions but seem unable to to this ??

Thanks
 
I hope Niek will not mind me explaining his answer.
Excel keeps time values as fractions of a day.
You have N seconds so dividing by 60 gives minutes, dividing again by 60
gives hours and finally dividing by 24 gives days.
best wishes
 
Thanks. I've been having the same problem trying to use the CONVERT function
to no avail.
 
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

Convert text entered as minutes/seconds to minutes 1
Converting minutes to seconds 4
Which is the best MBOX Converter Tool different formats conversion? 4
Need to convert Minutes:Seconds format to minutes with seconds con 2
How can I migrate MBOX to PST? 2
Convert time in number of seconds 2
dispay numbers as minutes and seconds in excel 2
Converting Minutes and Seconds ([mm]:ss) to Decimal 6

Back
Top