convert to mm:ss to just seconds
 

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

convert to mm:ss to just seconds
 

Hi!

Multiply by 86400 and format as GENERAL.

=A1*86400

Biff

"Jack" wrote in message
...
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