# Countdown **URL:** \ **Category:** Ask for Help\ **Created:** [March 30, 2021, 8:03pm UTC](https://community.glideapps.com/t/countdown/24940 "2021-03-30T20:03:40Z")\ **Posts on this page:** 1\ **Showing post:** 10
**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:** [March 31, 2021, 7:21pm UTC](https://community.glideapps.com/t/countdown/24940/10 "2021-03-31T19:21:12Z")
This should help you. > [@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… You can probably remove the part about seconds if you don’t need it. All you will need is column that contains a future date, then a math column to calculate the duration by subtracting Now from your date column. This will give you a duration in days. The rest of the column will split that in the proper Days, Hours, Minutes, and Seconds. --- _[View the full topic](https://community.glideapps.com/t/countdown/24940)._