Example; Cell reads 114.4 Need to convert to 74.4 Seconds. Any thoughts?
R Ron Coderre May 16, 2007 #2 With A1: 114.4 If I understand correctly....try this: B1: =INT(A1/100)*60+MOD(A1,100) Does that help? *********** Regards, Ron XL2002, WinXP
With A1: 114.4 If I understand correctly....try this: B1: =INT(A1/100)*60+MOD(A1,100) Does that help? *********** Regards, Ron XL2002, WinXP
D David Biddulph May 16, 2007 #3 If the A1 had been entered as 1:14.4, you could use =A1*24*3600 (and format as number or general).
