ExcelBanter - Converting time

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Converting time (https://www.excelbanter.com/new-users-excel/45652-converting-time.html)

Dave

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.

Bob Phillips

=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.

Dave

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.

All times are GMT +1. The time now is 05:57 AM.