# How to convert HH:MM:SS to just HH:MM?
**URL:** https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152
**Category:** Ask for Help
**Created:** [October 7, 2022, 6:26pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152 "2022-10-07T18:26:58Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [October 7, 2022, 6:26pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/1 "2022-10-07T18:26:58Z")
Hi. I calculated the time between my date using End - Start formula.
The result is coming in as HH:MM:SS but I need to get rid of the seconds and just keep HH:MM.
How do I do that?
I don’t want to see Hours or minutes in decimals. I want to see the actual time taken. Like 1 hour 30 minutes as **01:30** , not as **1.5** or **01:30:00**
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [October 7, 2022, 7:16pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/2 "2022-10-07T19:16:17Z")
Just by the way my answer isn’t in this thread as the formula in this thread converts the time to decimals which I don’t. I just want to get rid of Seconds and keep the HH:MM format as it is. 🙂
> [@Change Duration Format from HH:MM:SS to HH.MM](https://community.glideapps.com/t/change-duration-format-from-hhss-to-hh-mm/40178):
>
> Hello, I am running into an issue with my time calculation. We are calculating a duration (End Time - Start Time) and the Math Column is displaying the results in HH:MM:SS format when we are needing it in HH.MM format. For example, if the start time was 6:00 am and the end time was 7:30 am that would calculate to 01 hour and 30 minutes. We need this to display at 1.5 hours, but glide is displaying the results as 01:30:00. How can I change this? I changed the formula to ((End Time - Start Tim…
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 7, 2022, 7:28pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/3 "2022-10-07T19:28:54Z")
> [@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:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [October 7, 2022, 7:41pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/4 "2022-10-07T19:41:06Z")
Thanks for sharing that so quick. This is what I have got using your code.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 7, 2022, 9:34pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/5 "2022-10-07T21:34:34Z")
For simplicity, I’d probably pass it into a javascript column, split the value on ‘:’ and then rejoin only the first two parts of the array.
To do it with glide columns, you could create a Split Text column to split each part into an array. Create two single value columns to get the hour and minute values, then a template column to join it back together.
Might intially need a template column to lock the duration as a string before either method.
Also another method would be to use some mildly complex math to end up with 8.44 instead of 8:44:00, then replace ‘.’ with ‘:’
Maybe I should ask…do you only need the duration to be a string or does it have to be a number for further calculations?
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [October 7, 2022, 10:12pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/6 "2022-10-07T22:12:22Z")
It has to be used for Donut Chart to calculate how much time in HH:MM I have spent on any activity.
So on the center it should show the total HH:MM I have spent, and in the legend it should show how much I have spent on each activity.
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [October 7, 2022, 11:18pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/7 "2022-10-07T23:18:33Z")
I tried using Split Text column, separated the values by ‘:’
Used Slice Array to just get HH:MM and get rid of :SS.
Now the problem is, if the duration is 9 minutes 50 seconds lets say like shown in the screenshot in the last entry, the HH doesn’t show up at all. This would have worked if the HH:MM:SS column would have shown the duration as **00:09:50** , instead it just shows up as **9:50**. which invalidates our theory.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 7, 2022, 11:21pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/8 "2022-10-07T23:21:32Z")
glide has a great time conversion column… and an Excel formulas column… use it…
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 7, 2022, 11:24pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/9 "2022-10-07T23:24:50Z")
I’m at my computer now, so I’ll play with this a little bit. Do you need to add several durations together, or is your graph only showing one duration per row?
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [October 7, 2022, 11:25pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/10 "2022-10-07T23:25:26Z")
I need exactly like this, just have to get rid of seconds.
And I don’t need the Hours in decimals since 1.9 hours would be confusing for the users. They need to see it in the HH:MM format 🙂
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [October 7, 2022, 11:27pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/11 "2022-10-07T23:27:16Z")
@Uzo , if you could suggest a solution to this that would be awesome…
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 7, 2022, 11:27pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/12 "2022-10-07T23:27:42Z")
i did
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [October 7, 2022, 11:28pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/13 "2022-10-07T23:28:46Z")
> [@Uzo](#):
>
> glide has a great time conversion column… and an Excel formulas column… use it…
Kindly elaborate 🙂
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 7, 2022, 11:29pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/14 "2022-10-07T23:29:46Z")
> **[Schedule Appointment](https://schedule-appointment.glideapp.io/)**
>
> Schedule paid appointments, for Google Meet, get calendar reminders, block booked dates and time slots, duration auto adjust to booked time slots, custom stripe checkout
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [October 7, 2022, 11:30pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/15 "2022-10-07T23:30:47Z")
It’s not loading.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 7, 2022, 11:31pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/16 "2022-10-07T23:31:50Z")
I know… I believe @Jeff_Hager Je will take time to solve it
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 7, 2022, 11:32pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/17 "2022-10-07T23:32:25Z")
what is not loading?
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [October 7, 2022, 11:32pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/18 "2022-10-07T23:32:44Z")
> [@Uzo](#):
>
> [https://schedule-appointment.glideapp.io/](https://schedule-appointment.glideapp.io/)
this
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 7, 2022, 11:34pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/19 "2022-10-07T23:34:10Z")
wow… my App is working for non accepted browser settings LOL
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 7, 2022, 11:40pm UTC](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152/20 "2022-10-07T23:40:04Z")
anyway… just use the column to convert the date… in any format
[Next page](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152.md?page=2)