Anyone tell me an easy formula to use to change say 3.27 in one cell to 207 secs in another? TIA!!!
R ronedwards Nov 3, 2005 #1 Anyone tell me an easy formula to use to change say 3.27 in one cell to 207 secs in another? TIA!!!
S Stefi Nov 3, 2005 #2 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:
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:
