But the result is not 100% acurate, as the caculation is based on 365days/year and 30days/month. Only when you have the start date and finish date then you can get the acurate result
Member for
19 years 5 months
Member for19 years5 months
Submitted by Svein Myklebust on Mon, 2006-07-24 04:22
Member for
19 years 4 monthsRE: Alter of Excel cell
Many Thanks zhang
keep in tuch
Member for
20 years 6 monthsRE: Alter of Excel cell
you need some formula,
cell A1 = 11.6 then
year: int(a1)
month: int(mod(a1*365,365)/30)
day:: int(mod(a1*365,30))
you can input the following formula in Cell B1
=int(a1)&"y:"&int(mod(a1*365,365)/30)&"m:"&int(mod(a1*365,30))&"d"
But the result is not 100% acurate, as the caculation is based on 365days/year and 30days/month. Only when you have the start date and finish date then you can get the acurate result
Member for
19 years 5 monthsRE: Alter of Excel cell
Why do you need this?
Excels calcualtions on time ar based on days.
Why cant you just use days?
Svein