If A1=3:27 (3 mins 27 secs formatted like mm:ss), then in B1 =A1, and format
B1 as [s]
Regards,
Stefi
€˛ronedwards€¯ ezt Ć*rta:
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