converting seconds to mins

[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

 

[Douglas J. Steele]

TimeInSeconds \ 60 & " Mins, " & (TimeInSeconds Mod 60) & " secs.

 

[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