98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conerting time in minutes (4:18) to seconds (258 secs)
Conerting time in minutes (4:18) to seconds (258 secs)
Resolved · High Priority · Version 2007
Wed 15 Jul 2009, 13:24Delegate Wendy said...
Wendy has attended:
Excel Introduction course
Conerting time in minutes (4:18) to seconds (258 secs)
Is it possible to set up a formula that turns minutes and seconds into seconds i.e. we currently use a formula whereby we have two columns, one which turns minutes into seconds and then we add this to another column of just seconds.
Please advise if there is a set formula to do this?
Thanks
Wendy
Wed 15 Jul 2009, 13:51Trainer Amanda said...
RE: Conerting time in minutes (4:18) to seconds (258 secs)
Hello Wendy
Thank you for your question.
Try multiplying the time in minutes and seconds by 1440, to get the number of seconds only.
I found this solution on the following page - the poster here suggests formatting the time in mins and secs as text, but I don't think it will be necessary to do this. I tried using the formula with the cell containing the time in mins and secs with a custom format (mm:ss) applied and it still seemed to work ok.
http://answers.yahoo.com/question/index?qid=20080707124301AAsy1Lz
Kind regards
Amanda
Wed 22 Jul 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Printing spreadsheets without opening them firstHere's a fast way of printing a spreadsheet from Windows Explorer/My Computer. |
