# Can I convert seconds to minutes?

**URL:** <https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958>\
**Category:** Ask for Help\
**Created:** [December 21, 2022, 7:18pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958 "2022-12-21T19:18:38Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [December 21, 2022, 7:18pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/1 "2022-12-21T19:18:38Z")

</div>

This is it in the database:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/c/9ccb70c15a262c5493b42bf2b11719204fe03951.jpeg)  
This is what it looks like on the screen:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/9/d9aa39ae001c835c4747a966b3c95bffd5b99fa0.jpeg)

At least it converts it to only .00 but I’d still like to display in minutes if possible

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2022, 7:31pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/2 "2022-12-21T19:31:15Z")

</div>

divide by 60… 😉

`floor(avarage/60)`

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [December 21, 2022, 7:39pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/3 "2022-12-21T19:39:46Z")

</div>

lol thank you for the math break down. Where and how do I plug in that formula?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2022, 7:40pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/4 "2022-12-21T19:40:13Z")

</div>

math column

 ![Screen Shot 2022-12-21 at 2.43.10 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/351c10834271f63dc947e25b7fba754b744cf35a.jpeg)

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [December 21, 2022, 7:46pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/5 "2022-12-21T19:46:15Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/5473ac13fbb7d91ff1aa097d656b4c99a5ab1110.jpeg)

seems to be rounding up to only minutes and not including seconds as well?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2022, 7:47pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/6 "2022-12-21T19:47:08Z")

</div>

is your average in seconds?.. that was your question… to convert to minutes… take out floor from the formula, if you wanna have numbers after decimal point

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [December 21, 2022, 7:48pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/7 "2022-12-21T19:48:52Z")

</div>

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

I want it to be able to say 2 minutes and 31 seconds 2:31

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [December 21, 2022, 7:50pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/8 "2022-12-21T19:50:51Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d07f2cfa781fa40e20655bfc4d580ffeb39788fb.png)

Can I template it somehow so it reads 2:31 instead of 2.31?

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [December 21, 2022, 7:51pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/9 "2022-12-21T19:51:50Z")

</div>

never mind, easy, i got it. Thank you!

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [December 21, 2022, 7:56pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/10 "2022-12-21T19:56:28Z")

</div>

never mind again, it’s not displaying right on the screen side  
i made the template:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/9/193d6b44f319e430365f92d331421e35b8804897.jpeg)  
and then plugged it in here and it came out like this:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b60ba0b55861bf1e9cdd89b0051dc320c09a1d8a.jpeg)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2022, 7:58pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/11 "2022-12-21T19:58:00Z")

</div>

are you average in seconds?

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [December 21, 2022, 7:59pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/12 "2022-12-21T19:59:39Z")

</div>

yes average column is seconds

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2022, 8:01pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/13 "2022-12-21T20:01:17Z")

</div>

![Screen Shot 2022-12-21 at 3.01.05 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1de7d2896c5bade3cdbbc87c0cd480713df93c30.jpeg)

edit your average column… switch from number to duration type… in the math column change formula to: average/24/60/60

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [December 21, 2022, 8:03pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/14 "2022-12-21T20:03:55Z")

</div>

yes thats what i want it to look like but it’s not converting right

this is the one we were just looking

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/263b8479d4bb057abb180169a4b27dd62375413f.jpeg)  
it’s 51 second coverted to 0.86 which is right, it should say 0:51

Do i first need to remove the milliseconds?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2022, 8:05pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/15 "2022-12-21T20:05:55Z")

</div>

> [@Uzo](#):
>
> edit your average column… switch from number to duration type… in the math column change formula to: average/24/60/60

follow that

@Katelyn_Alberts is it working?

 ![Screen Shot 2022-12-21 at 3.17.30 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c9cdf07cf37a245adde18c6b4281c55b2003e2f6.jpeg)

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [December 21, 2022, 9:15pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/16 "2022-12-21T21:15:01Z")

</div>

Not sure if i can/should edit that column type because it comes straight from Google Analytics that way and updates daily? Should I transfer the date into another column type first?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2022, 9:16pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/17 "2022-12-21T21:16:34Z")

</div>

yes, you can change… unless you need that format somewhere else in your app… data will not change… only how is displayed… so no worries

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [December 21, 2022, 9:36pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/18 "2022-12-21T21:36:38Z")

</div>

perfect, all set! thanks!!

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [December 21, 2022, 9:46pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/19 "2022-12-21T21:46:22Z")

</div>

@Katelyn_Alberts we’ve just added a `Format Duration` column to help you with this:

> **[Glide • Format Duration column](https://www.glideapps.com/plugins/format-duration)**
>
> Format a duration in seconds into text like '1:30'.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2022, 9:52pm UTC](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958/20 "2022-12-21T21:52:58Z")

</div>

great… @david i can’t find that column

[Next page](https://community.glideapps.com/t/can-i-convert-seconds-to-minutes/55958.md?page=2)