| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
| How do I convert 00:03:54 to get 234 seconds? | Excel Worksheet Functions | |||
| Convert time to all seconds | Excel Discussion (Misc queries) | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Hybrid Mode
