Converting time

D

Dave

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

Bob Phillips

=LEFT(A21,FIND("m",A21)-1)*60+MID(A21,FIND("m",A21)+1,FIND("s",A21)-FIND("m"
,A21)-1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Converting decimal degrees to degrees, minutes & seconds 2
Converting URLs in comments to Markdown-formatted links 2
Merging from an Excel file with graphics 1
Using project as a resource tracker 0
Countdown macro - display settings 2
Converting Seconds to Hours, Minutes, Seconds 3
Averaging by half hour time intervals. 0

Top