|
tech
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
converting seconds to minsI 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 TimeInSeconds \ 60 & " Mins, " & (TimeInSeconds Mod 60) & " secs.
-- Show quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "time convertions" <time converti***@discussions.microsoft.com> wrote in message news:1C2B0736-0A90-444A-9178-C77C07FA099D@microsoft.com... >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. -- Show quoteArvin Meyer, MCP, MVP Free MS-Access downloads: http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "time convertions" <time converti***@discussions.microsoft.com> wrote in message news:1C2B0736-0A90-444A-9178-C77C07FA099D@microsoft.com... >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  |
|||||||||||||||||||||||
Other interesting topics