Alter of Excel cell

Z
Zhang Haixiang 👤 Member for 21 years 3 months

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 2 months

Why do you need this?



Excels calcualtions on time ar based on days.

Why can’t you just use days?



Svein

Featured Partner

Top Posters

Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts