Converting year and month into year

[baidya91]

How can I convert 19 years 6 months into 19.5 years in excel?

A1= 19 years 6 months, B1=19.5 years

 

[BENNASR]

(gauche(a1;2)*1)+((gauche(droite(a1;8);1)*1)/12)

 

[Sanjeev1976]

=VALUE(TRIM(LEFT(A1,2)))+VALUE(TRIM(MID(A1,SEARCH("month",A1,1)-3,2))/12)

 

[BENNASR]

(left(a1;2)*1)+((left(RIGHT(a1;8);1)*1)/12)

 

[jtakw]

Hi,

Try this, format the result cells to round to # of digits of your choice:

Book1
	A	B
1	19 years 6 months	19.5
2	9 years 11 months	9.916667
3	10 years 10 months	10.83333
4	9 years 9 months	9.75
Sheet423

Cell Formulas
Range	Formula
B1	=LEFT(A1,2)+MID(A1,SEARCH("years",A1)+6,2)/12

 

[baidya91]

Thanks

 

[jtakw]

You're welcome.