4 year + 10 months

[Maddy]

Hi All,

Please advise how to converts 4 years + 10 months into total Months.

Thanks Maddy

 

[AliGW]

What are the EXACT contents of the cell whose value you wish to convert?

Maybe this:

=(TRIM(LEFT(A1,2))*12)+TRIM(MID(A1,FIND("m",A1)-3,3))

 

[Maddy]

What are the EXACT contents of the cell whose value you wish to convert?

Maybe this:

=(TRIM(LEFT(A1,2))*12)+TRIM(MID(A1,FIND("m",A1)-3,3))

Hi AliGW,

Tenure Year	Tenure Month
2	10
5	9
2	7
2	4
8	8
2	9
6	2
9	0
5	8

 

[AliGW]

OK - assuming TY is in A and TM is in B:

=(A2*12)+B2

This is pretty simple, so I hope I haven't missed something ...

 

[Maddy]

OK - assuming TY is in A and TM is in B:

=(A2*12)+B2

This is pretty simple, so I hope I haven't missed something ...

yup.. Thanks Ali

 

[AliGW]

OK - you can click on 'Like' if I helped.