# Second part of split

**URL:** <https://community.glideapps.com/t/second-part-of-split/26465>\
**Category:** Ask for Help\
**Created:** [May 6, 2021, 1:25am UTC](https://community.glideapps.com/t/second-part-of-split/26465 "2021-05-06T01:25:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Augusto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/augusto/32/25004_2.png) [@Augusto](https://community.glideapps.com/u/Augusto)\
**Post date:** [May 6, 2021, 1:25am UTC](https://community.glideapps.com/t/second-part-of-split/26465/1 "2021-05-06T01:25:33Z")

</div>

Good night.  
I have a problem and i need help with it.  
So i need to get the second part of a time, i tried split it but without success.  
The first part was easy, i got but using the MATH column and ‘precision’ set as 1.  
How i get the second part?

**→** 2,34 **→** 2  
I need the part after ‘ **,** ’.

---

<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:** [May 6, 2021, 1:36am UTC](https://community.glideapps.com/t/second-part-of-split/26465/2 "2021-05-06T01:36:18Z")

</div>

You can use the following formulas to get specific parts of a time.

HOUR(date)  
MINUTE(date)  
SECOND(date)

---

<div class="post-metadata">

**Author:** ![Augusto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/augusto/32/25004_2.png) [@Augusto](https://community.glideapps.com/u/Augusto)\
**Post date:** [May 6, 2021, 1:58am UTC](https://community.glideapps.com/t/second-part-of-split/26465/3 "2021-05-06T01:58:47Z")

</div>

Hi @Jeff_Hager, thanks for the reply.  
How I use it on my GlideTable?

---

<div class="post-metadata">

**Author:** ![Augusto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/augusto/32/25004_2.png) [@Augusto](https://community.glideapps.com/u/Augusto)\
**Post date:** [May 6, 2021, 2:12am UTC](https://community.glideapps.com/t/second-part-of-split/26465/4 "2021-05-06T02:12:34Z")

</div>

> [@Jeff\_Hager](#):
>
> SECOND(date)

Found it. Using the MATH column. I had to use a second MATH column to get the result I wanted.

If you use without ‘ **:** ’, it won’t work. So had to replace ‘ **,** ’ to ‘ **:** ’.

Other thing is that alone it did not work as well, so I had a sum after. Like this:

**→** 2,34 **→** 2:34  
**Math Column:**  
SECOND(date) + (s\*60)

> **date** was ‘ **2:34** ’;  
> **s** was equal ‘ **2** ’, using a MATH column with precision 1.  
> got 9240, then I divided by 60 with another MATH column.  
> .

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/second-part-of-split/26465/5 "2024-01-17T16:52:21Z")

</div>