DattatraycitehrHi 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
From India, Mumbai
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Hr & Administrtion
Sharmila DasDear 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.
From India, Visakhapatnam
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.
From India, Chennai
JAWAHAR LAL MOONDRAIt 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
From India, Jodhpur
praveenpathak538Why 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
From India, Mumbai
manojsoni78For 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.
M K Soni
From India, Kolkata
saidaiganesanThe 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
From India, Madras
Dattatraycitehrhii 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.
From India, Mumbai
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.
From India, Hyderabad
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
Date of Joining Previous Experience (Months) in ur co. Experience (Months) Total Exp.
1-Apr-07 38 70 9 0
From India, Ranchi