|
Convert mins:secs to seconds only
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 |
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 |
Convert mins:secs to seconds only
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 |
Convert mins:secs to seconds only
Thanks, that's perfect! Perfect, appreciate the prompt reply! -- ronedwards ------------------------------------------------------------------------ ronedwards's Profile: http://www.excelforum.com/member.php...o&userid=28521 View this thread: http://www.excelforum.com/showthread...hreadid=481766 |
| All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com