convert to mm:ss to just seconds

[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

 

[Biff]

Hi!

Multiply by 86400 and format as GENERAL.

=A1*86400

Biff