converting seconds to mins

T

time convertions

I needs to convert seconds to mins how d o i do it in excel

Eg: i need to convert 236 secs to mins how do i do this..

the answer should be 3 mins and 56 secs how do i do this

please help me
 
A

Arvin Meyer [MVP]

Assuming the number of seconds is in A1, the formula would be:


=INT(A1/60) & " mins., " & MOD(A1,60) & " secs."

In the future, your Excel questions may be better answered in an Excel
newsgroup which is more appropriate to your problem. This newsgroup is
dedicated to the Microsoft Access database product. The Microsoft website is
not all that clear and may have misdirected you.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 

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