Converting MM:SS to seconds only.

G

Guest

Hi

Does anyone know how to convert minutes:seconds (mm:ss) to just seconds in
excel?
E.g. Converted 2:00 = 120 seconds.

Your help would be greatly appreciated.
Cheers
Jack
 
A

Arvin Meyer [MVP]

This isn't an Excel newsgroup, but the answer is probably the same. Multiply
the minutes field by 60. Remember an increment of time is not time, so 2
minutes is actually 2.0 minutes, not 2:00 (which is 2:00 AM)

Your question may be better answered in a newsgroup 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

Similar Threads

convert to mm:ss to just seconds 1
Converting :mm:ss to ss 8
Timeformat (mm:ss) 4
How do I convert time as text 'mm:ss to time value in Excel 5
How to convert 243 seconds to 4:03 (mm:ss) 2
how to convert whole numbers representing seconds to mm:ss 2
Decimal minutes to mm:ss format 4
problem working with time data imported from text file 1

Top