Originally Posted by lomaca

You can play around with this, if you have this "2-30.3" in A1 then put this formula in B1 =LEFT(A1,1)*60+MID(A1,3,2)+RIGHT(A1)
and would give you the result 150.3 sec


I haven't used Excel for programming for, well never, but it should give you a start.

Good luck