Excel formula help with dates

[Formulahelp]

Hello Excel Gurus,

I have an excel worksheet that shows length of service in one cell like this: 30 year(s), 10 month(s), 5 day(s)
Is there a Date excel formula I can use that will easily format this to a decimal for me?

Thank you so much.

 

[Cubist]

Try:

Book2
	A	B
1	30 year(s), 10 month(s), 5 day(s)	30.85
Sheet1

Cell Formulas
Range	Formula
B1	B1	=SUM(TEXTSPLIT(A1,{"year(s)","month(s)","day(s)",","},,1)/{1,12,365.25})

 

[Formulahelp]

Try:

Book2
	A	B
1	30 year(s), 10 month(s), 5 day(s)	30.85
Sheet1

Cell Formulas
Range	Formula
B1	B1	=SUM(TEXTSPLIT(A1,{"year(s)","month(s)","day(s)",","},,1)/{1,12,365.25})

@Cubist - you are amazing. This work as expected. Thank you SO much.