» Converting Text Representing Minutes and Seconds into Numerical Values

Problem:

Column A contains text strings representing time values in the "Xm Ys" format.
X represents the number of minutes and Y represents the number of seconds.
We want to calculate the total number of seconds represented by each string in column A.
Solution:

Use the LEFT, FIND, LEN, and MID functions as shown in the following formula:
=(LEFT(A2,FIND("m",A2)-1)*60)+LEFT(MID(A2,FIND(" ",A2)+1,99),LEN(MID(A2,FIND(" ",A2)+1,99))-1)