# 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:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@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")

</div>

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…

---

_[View the full topic](https://community.glideapps.com/t/how-to-convert-hhss-to-just-hh-mm/51152)._