R Raja Aurongzeb New Member Mar 7, 2016 #1 Need help to convert 2.33 in years and months. thanks Raja Aurongzeb
Luke M Excel Ninja Staff member Mar 7, 2016 #2 What should the result of 2.33 be? Is that February of 1933? February 2033?
David Evans Active Member Mar 7, 2016 #3 Luke M said: What should the result of 2.33 be? Is that February of 1933? February 2033? Click to expand... Maybe he's looking for 2 years 3 months? But whatever it is, it would be helpful to know! If that's what the goal is, the attached will do it ... Attachments Decimal Years to YrsMon.xlsx Decimal Years to YrsMon.xlsx 9.5 KB · Views: 7
Luke M said: What should the result of 2.33 be? Is that February of 1933? February 2033? Click to expand... Maybe he's looking for 2 years 3 months? But whatever it is, it would be helpful to know! If that's what the goal is, the attached will do it ...
R Raja Aurongzeb New Member Mar 8, 2016 #4 David Evans said: Maybe he's looking for 2 years 3 months? But whatever it is, it would be helpful to know! If that's what the goal is, the attached will do it ... Click to expand... Thanks David for your help. Raja Aurongzeb
David Evans said: Maybe he's looking for 2 years 3 months? But whatever it is, it would be helpful to know! If that's what the goal is, the attached will do it ... Click to expand... Thanks David for your help. Raja Aurongzeb
R Raja Aurongzeb New Member Mar 8, 2016 #5 Luke M said: What should the result of 2.33 be? Is that February of 1933? February 2033? Click to expand... Dear Luke, its like you calculated a figure and it comes out in fractions and you want to know how much exact years and months if we convert fraction e.g. 2.5 means 2 years & 6 Months.
Luke M said: What should the result of 2.33 be? Is that February of 1933? February 2033? Click to expand... Dear Luke, its like you calculated a figure and it comes out in fractions and you want to know how much exact years and months if we convert fraction e.g. 2.5 means 2 years & 6 Months.