Alter of Excel cell

Z
Zhang Haixiang 👤 Member for 21 years 1 month

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

S
Svein Myklebust 👤 Member for 20 years

Why do you need this?



Excels calcualtions on time ar based on days.

Why can’t you just use days?



Svein

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