# Format duration in minutes as hh:mm

**URL:** https://community.glideapps.com/t/format-duration-in-minutes-as-hh-mm/36430
**Category:** Ask for Help
**Tags:** custom-code
**Created:** [December 28, 2021, 5:09pm UTC](https://community.glideapps.com/t/format-duration-in-minutes-as-hh-mm/36430 "2021-12-28T17:09:26Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### 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 28, 2021, 5:45pm UTC](https://community.glideapps.com/t/format-duration-in-minutes-as-hh-mm/36430/2 "2021-12-28T17:45:46Z")

</div>

This had been my previous attempt from a while back. Definitely not elegant by any means. Your javascript solution makes way more sense.

> [@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/format-duration-in-minutes-as-hh-mm/36430)._