# Convert time **URL:** https://community.glideapps.com/t/convert-time/77259 **Category:** Ask for Help **Created:** [October 22, 2024, 4:01pm UTC](https://community.glideapps.com/t/convert-time/77259 "2024-10-22T16:01:34Z") **Posts on this page:** 1 **Showing post:** 2
### Author: ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn) #### Post date: [October 22, 2024, 4:36pm UTC](https://community.glideapps.com/t/convert-time/77259/2 "2024-10-22T16:36:41Z")
I’ve used [Chuck’s](https://community.glideapps.com/t/chuck-norris-aka-jeff/26818) solution before > [@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/convert-time/77259)._