converting seconds into minutes

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
 
B

Bernard Liengme

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
 
G

Guest

Thanks. I've been having the same problem trying to use the CONVERT function
to no avail.
 

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

Top