| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Converting time
How can I convert 1m38.15s or 0m58.98s into seconds in decimals ie:98.15 or
58.98. I've tried formatting the column next to the data "ss.00" but it does not work. Any help would be appreciated. |
|
#2
|
|||
|
|||
|
=LEFT(A21,FIND("m",A21)-1)*60+MID(A21,FIND("m",A21)+1,FIND("s",A21)-FIND("m"
,A21)-1) -- HTH Bob Phillips "Dave" wrote in message ... How can I convert 1m38.15s or 0m58.98s into seconds in decimals ie:98.15 or 58.98. I've tried formatting the column next to the data "ss.00" but it does not work. Any help would be appreciated. |
|
#3
|
|||
|
|||
|
Hi Bob
Thanks that works perfectly. regards "Bob Phillips" wrote: =LEFT(A21,FIND("m",A21)-1)*60+MID(A21,FIND("m",A21)+1,FIND("s",A21)-FIND("m" ,A21)-1) -- HTH Bob Phillips "Dave" wrote in message ... How can I convert 1m38.15s or 0m58.98s into seconds in decimals ie:98.15 or 58.98. I've tried formatting the column next to the data "ss.00" but it does not work. Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting time worked to dollars earned. | New Users to Excel | |||
| Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) | |||
| Converting to Time Format | Excel Discussion (Misc queries) | |||
| Converting time figures into 24-hour format & sorting them... | Excel Worksheet Functions | |||
| Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) | |||
Linear Mode
