convert to mm:ss to just seconds

J

Jack

How can I convert minutes:seconds (mm:ss) to just seconds in excel?

E.g. 01:00 to 60seconds, 02:00 to 120 seconds?

Your help would be greatly appreciated.

Cheers
 

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

Formating seconds into mm:ss 6
Converting MM:SS to seconds only. 1
convert time 2
formatting cells for minutes:seconds 1
Multiplying time by cost 2
Time Conversion issue 6
How do I convert time as text 'mm:ss to time value in Excel 5
number formatting 4

Top