Alter of Excel cell
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
Many Thanks zhang
keep in tuch
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
Why do you need this?
Excels calcualtions on time ar based on days.
Why cant you just use days?
Svein