# How to format seconds to duration HH:MM

**URL:** <https://community.glideapps.com/t/how-to-format-seconds-to-duration-hh-mm/50847>\
**Category:** Ask for Help\
**Created:** [October 4, 2022, 10:46am UTC](https://community.glideapps.com/t/how-to-format-seconds-to-duration-hh-mm/50847 "2022-10-04T10:46:56Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 4, 2022, 11:13am UTC](https://community.glideapps.com/t/how-to-format-seconds-to-duration-hh-mm/50847/2 "2022-10-04T11:13:37Z")

</div>

That JavaScript method is a bit of a hack. Here is a better option:

> [@Format duration in minutes as hh:mm](https://community.glideapps.com/t/format-duration-in-minutes-as-hh-mm/36430):
>
> This is a classic example of where a single experimental code column can save you a bunch of Glide computed columns. My use case: I have a column where the value in each row represents a duration in minutes, and I need to format that for display as hh:mm. So, for example… 2914 =\> 48:34 804 =\> 13:24 63 =\> 01:03 5 =\> 00:05 0 =\> blank As far as I could tell, none of the plugin columns will handle this. But it looks easy, right? Well, the best I could do with Glide computed columns was 6 (!!) …

---

_[View the full topic](https://community.glideapps.com/t/how-to-format-seconds-to-duration-hh-mm/50847)._