# 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:** 8
**Page:** 1
### Author:  [@KPT](https://community.glideapps.com/u/KPT)
#### Post date: [October 4, 2022, 10:46am UTC](https://community.glideapps.com/t/how-to-format-seconds-to-duration-hh-mm/50847/1 "2022-10-04T10:46:56Z")
I’ve been using the below example using a javascript column to convert seconds to a date format.
> [@Convert Seconds to Duration](https://community.glideapps.com/t/convert-seconds-to-duration/40820/2):
>
> You can use this in a JavaScript column.
>
> 
>
> ```auto
> return new Date(p1 * 1000).toISOString().substr(11, 8)
>
> ```
>
> Original answer:
Does anyone know how to change the the format to HH:MM instead of HH:MM:SS - I’ve looked around the internet, but no luck.
---
### Author:  [@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")
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 (!!) …
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 4, 2022, 11:15am UTC](https://community.glideapps.com/t/how-to-format-seconds-to-duration-hh-mm/50847/3 "2022-10-04T11:15:47Z")
use the format date column:
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 4, 2022, 11:25am UTC](https://community.glideapps.com/t/how-to-format-seconds-to-duration-hh-mm/50847/4 "2022-10-04T11:25:15Z")
Except when it [doesn’t work…](https://community.glideapps.com/t/time-format/50074/8)
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 4, 2022, 11:27am UTC](https://community.glideapps.com/t/how-to-format-seconds-to-duration-hh-mm/50847/5 "2022-10-04T11:27:46Z")
I belive he just wants to display it… for any other purposes, use the math column
---
### Author:  [@KPT](https://community.glideapps.com/u/KPT)
#### Post date: [October 4, 2022, 11:31am UTC](https://community.glideapps.com/t/how-to-format-seconds-to-duration-hh-mm/50847/6 "2022-10-04T11:31:59Z")
Yes you’re right just for display purpose.
---
### Author:  [@KPT](https://community.glideapps.com/u/KPT)
#### Post date: [October 4, 2022, 11:32am UTC](https://community.glideapps.com/t/how-to-format-seconds-to-duration-hh-mm/50847/7 "2022-10-04T11:32:17Z")
Works like a charm.
Thank you.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [October 5, 2022, 11:32am UTC](https://community.glideapps.com/t/how-to-format-seconds-to-duration-hh-mm/50847/8 "2022-10-05T11:32:33Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.