# Date relative translation **URL:** \ **Category:** Ask for Help\ **Created:** [December 6, 2021, 9:54pm UTC](https://community.glideapps.com/t/date-relative-translation/35598 "2021-12-06T21:54:53Z")\ **Posts on this page:** 1\ **Showing post:** 18
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 7, 2021, 4:13pm UTC](https://community.glideapps.com/t/date-relative-translation/35598/18 "2021-12-07T16:13:21Z")
Take a look at this and let me know if you have questions. > [@Time duration not presenting correctly in glide chart stopwatch](https://community.glideapps.com/t/time-duration-not-presenting-correctly-in-glide-chart/24014/6): > > I took it a step further and included Days as well. You can exclude it if you don’t need it. It’s a little involved, but I’ll explain the best I can. Here is my results: First we have the Duration column, which is obvious and what you already have. Next we have the Days column: FLOOR(D)/100 This is simply taking the duration and dropping off the decimals. The division by 100 will be explained later. Next we have the Hours column: FLOOR(MOD(D,1)\*24)/100 Th… --- _[View the full topic](https://community.glideapps.com/t/date-relative-translation/35598)._