How to figure out the duration in the format “00 Years 00 Months 00 Days”
Welcome to Glide.
Have you tried wrapping the duration column inside the math column? By dividing by 24 for hours, 1440 for minutes and 86400 for seconds if and when necessary, subtracting days or minutes when you don’t need them, and playing around with the floor function, you should be able to get the values you need. Finally, put everything together in a template column.
You could probably achieve what you want with a single JavaScript column. You could ask an LLM to generate the code for you.
I think you need to fiddle around a little and try to minimize the amount of computed columns you create for performance.
1 Like