How To Add Two Cells? - Xls Download - CiteHR
Malay.kumar1
Hr & Administrtion
Praveenpathak538
Manager-corporate Hr
Manojsoni78
Senior Manager
+11 Others

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Hi friends, I have two excel cell;first excel cell contain 5.2 Years and second cell contain 1.11 years.Now my question is that how to add these two cells so that i can get answer 7.1 years
Dear Mr. Dattatraycitehr,
SUM in excel is quiet simple, if you want the sum of both you need to try this - In a excel box type "=5.2+1.11" and press enter. You shall automatically get the addition of both numbers.

Hi
This is basic and simple step in the excel sheet in any cell type this =5.2+1.11 then you will get the answer.
One request before posted please take help from online.
It is simple even school students will do.
Eswar

It is not that simple as thought by answerer. The querist numbers are in year and month and not the numbers in decimal. 5 Years and 2 months and 1 Year 11 months gets one 7 Years and 1 month.
If the querist follow what has been suggested then answer would be 5.2+1.11=6.31 and not 7 Years and 1 month. In such cases the number in cell must be fed like =5+2/12 and 1+11/12. The answer in the result shall shall be 7.083333 or 7+1/12
If the querist wants the answer in year and month then he should write like this
Cell A1 - 5, Cell B1 - 2, Cell C1 - 1, Cell D1 - 11
In cell E1 - The formula should be =A1+B1/12+C1+D1/12
In Cell F1 - The formula should be =rounddown(E1,0)
In Cell G1 - The formula should be =(E1-D1)*12
A1 B1 C1 D1 E1 F1 G1
5 2 1 11 7.0833 7 1
The answer will be Years (F1) and Months (G1)
You may hide cell E1, If you wish
Jawaharlal Moondra
9829028028

Why do you making this more complicated fist 5.1 years and 1.11 years convert them in months i.e. 62 months and 23 months and add both cell. Result divide by 12.
Cell C1 =62 Cell C2=23 Cell C3=(C1+C2)/12 i.e.7.1 Years

For getting number of days, years or month between two dates, use DATEDIF function.
Suppose if cell A1 contains 01-01-2010 and B1 contains 01-12-2010, then use "=DATEDIF(A1,B1,"Y")" THIS WILL GIVEN NUMBER OF YEARS between two dates. Replace "y" with "m"or "d", to get number of days also.
If you have more question about excel automation in HR area you can post question to me.
Regards,
M K Soni

The important thing is, the answer should be 7.1 years.
You are advising to add 62+ 23 and divide the result by 12 to get the answer.
But how did you arrive at 62 & 23. If it one or two cell, you can do this manually. If the excel sheet is long and needs the total to be filled in by formula, you can't do that manually.
If you simply multiply by 12, you will get (5.1 * 12 = 61.2 months) which should actually be 61 months. and similarly 1.11 * 12 =13.32 which in fact should be 23 months

hii mam, its not solution what i want? actually i want answer 7.1 Years bt using ur formula i get answer 6.31 which i hv tried before posting this query on this site.
Hi,
You can never get 7.1 years with the values you have posted. 5.21 if converted in months is 61.2 and 1.11 is 13.32, the total is 74.52, which by no means can make 7.1 years. as it is equal to 85.2 months. Please review your question to get the correct answer.

Dear Dattatraycitehr,
You can use previous Exp. of Individuals in months like that individuals have 3.2 months previous experience then you can enter 38 months and it's not changeable, in another cell that contains Exp. in your company you will calculate using this formula
=round(Today()-Date of Joining cell address)/30,0)
i.e. the date of joining of Individual 1-Apr-2007 this formula will return you 70 months.
When you calculate Total Exp. of individual that time you create two separate column first will contain years and second will contain months and the formula for calculating years and months provided for our friends given below respectively
For Years =int((cell reference that contains previous exp.+cell value that contains in your organization exp.)/12)
For Months=(total exp.+in your company exp.)-12*Years
Ex.
Date of Joining Previous Experience (Months) in ur co. Experience (Months) Total Exp.
Years Months
1-Apr-07 38 70 9 0


This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™