Also, i think it will b always good to give a solution for the question
instead of finding mistakes in the questions.

"David Biddulph" wrote:

I am intrigued as to what sort of Excel you have that gives 3.13 as the
result for 2.10+1.3. For the rest of us, 2.10+1.3 is the same as 2.1+1.3,
and it returns 3.4. If you wanted 3.13, you'd have to enter 2.10+1.03.
Similarly if you had 2 years and 1 month, that would have to be entered as
2.01 to distinguish it from your 2.10.

If you do want to enter data in that format, you might try
=INT(A1+A2)+INT((MOD(A1,1)*100+MOD(A2,1)*100)/12)+MOD((MOD(A1,1)*100+MOD(A2,1)*100),12)/100but you would be better off either entering everything in months, orentering years and months in separate columns.--David Biddulph"Sandeep Nair" <Sandeep wrote in ... How can i add months or years and get the answer in the same format. For example, adding 2 years 10 months and 1 year 3 months. The answer shouldbe 4 years 1 month. If we do this calculation in excel, as usual it will givethe answer as 3.13 (2.10+1.3). Regards Sandeep Nair