# Convert Seconds to Duration

**URL:** <https://community.glideapps.com/t/convert-seconds-to-duration/40820>\
**Category:** Ask for Help\
**Created:** [April 18, 2022, 1:01am UTC](https://community.glideapps.com/t/convert-seconds-to-duration/40820 "2022-04-18T01:01:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\
**Post date:** [April 18, 2022, 1:01am UTC](https://community.glideapps.com/t/convert-seconds-to-duration/40820/1 "2022-04-18T01:01:27Z")

</div>

I have a spreadsheet with a SECONDS column for how long of a run I have done.

I would like to convert this to a the HH:MM:SS format.

How do I do that?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 18, 2022, 2:12am UTC](https://community.glideapps.com/t/convert-seconds-to-duration/40820/2 "2022-04-18T02:12:53Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e940bcf8d92e1cc1d4000e50e8e98f21cf771f7f.jpeg)

You can use this in a JavaScript column.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f5a62a88be818326ddbc26035e235216ae88e7ba.png)

```auto
return new Date(p1 * 1000).toISOString().substr(11, 8)

```

Original answer:

> <https://stackoverflow.com/questions/1322732/convert-seconds-to-hh-mm-ss-with-javascript/1322771#1322771>

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 19, 2022, 2:13am UTC](https://community.glideapps.com/t/convert-seconds-to-duration/40820/3 "2022-04-19T02:13:38Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.