View Single Post
  #2   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default Convert mins:secs to seconds only

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


"ronedwards" wrote
in message ...

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

TIA!!!


--
ronedwards
------------------------------------------------------------------------
ronedwards's Profile:

http://www.excelforum.com/member.php...o&userid=28521
View this thread: http://www.excelforum.com/showthread...hreadid=481766