would it always be 220 y and not 220y and not 220y344d12h
are you assuming 365 days for every year and not including leap years ?
what happens if there are no days or no years
would that be
220 y 0 d 0 h
=VALUE(LEFT(A1,FIND("y",A1)-1))*365+VALUE(MID(A1,FIND("y",A1)+2,FIND("d",A1)-FIND("y",A1)-2))+VALUE(MID(A1,FIND("d",A1)+2,LEN(A1)-FIND("d",A1)-3))/24