How to show the years of Duration?

1

image
image1171×510 23.4 KB

115 years
24 years
14 years

Thanks.

1 Like
2

Hi @Steve_Yang,

I post this some time ago (though I can’t find it…):

It’s a workaround implementation to show durations longer than a day.
Let me know if it’s useful.

Cheers!

2 Likes
3

image
image1259×204 16.6 KB

The trick is concatenate()

And if()

image
image991×168 14.9 KB

Thanks @Federico_Stefanato

Coda should add Years ,Months duration option. .

image

2 Likes
4

Thanks @Steve_Yang, @Federico_Stefanato for the trick but the result is text. It will therefore be impossible to use the value in a formula, apart from having 2 columns: 1 text, 1 duration.

Does the Coda team plan to add months or years to the durations?

3 Likes