converting seconds to mins

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

Guest

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
 
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
 
Back
Top