Convert mins:secs to seconds only

[ronedwards]

Anyone tell me an easy formula to use to change say 3.27 in one cell to
207 secs in another?

TIA!!!

 

[R.VENKATARAMAN]

if 3.25 is in A1
then in any empty cell type
=INT(A1)*60+MOD(A1,INT(A1))*100

 

[Guest]

If A1=3:27 (3 mins 27 secs formatted like mm:ss), then in B1 =A1, and format
B1 as

Regards,
Stefi

„ronedwards†ezt írta:

 

[ronedwards]

Thanks, that's perfect! Perfect, appreciate the prompt reply!