Alter of Excel cell

Z
Zhang Haixiang 👤 Member for 21 years 2 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 1 month

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

Soheil Barekat
4 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts
Vahidazimi01
0 posts
David Smith
4 posts