convert to mm:ss to just seconds

G

Guest

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

Converting MM:SS to seconds only. 1
formatting cells for minutes:seconds 1
Timeformat (mm:ss) 4
Formating seconds into mm:ss 4
Multiplying time by cost 2
How do I convert time as text 'mm:ss to time value in Excel 5
How can I convert or format an elapsed time to show mm:ss 4
Formatting time 6

Top