I have a large number of cells that contain time duration in the form:
41m 9s
How do I convert the duration into seconds, and then replace the old value of the cell with the converted value ?
I attempted using the following formula for the minutes part:
=LEFT(CELL, FIND("m", J8,1) - 1)*60