We must parse the data because these are string texts rather than actual integers. The components of the string will be extracted and converted to numbers using the following:
=LEFT(A1, FIND("'",A1)-1)*12 + MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1)
