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