# Change Duration Format from HH:MM:SS to HH.MM
**URL:** https://community.glideapps.com/t/change-duration-format-from-hhss-to-hh-mm/40178
**Category:** Ask for Help
**Created:** [March 28, 2022, 7:50pm UTC](https://community.glideapps.com/t/change-duration-format-from-hhss-to-hh-mm/40178 "2022-03-28T19:50:44Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@dylgarcia97](https://community.glideapps.com/u/dylgarcia97)
#### Post date: [March 28, 2022, 7:50pm UTC](https://community.glideapps.com/t/change-duration-format-from-hhss-to-hh-mm/40178/1 "2022-03-28T19:50:44Z")
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 Time)\*24) and the calculation is correct, but the displayed value is not in the correct format. If I double click a value in the math column to “change” the text/number within the cell, the number turns white and displays correctly (1.5) but once I click outside the number turns blue and changes to HH:MM:SS format (01:30:00).
Thanks for any help in advance.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 28, 2022, 7:58pm UTC](https://community.glideapps.com/t/change-duration-format-from-hhss-to-hh-mm/40178/2 "2022-03-28T19:58:12Z")
Try something like this:
```auto
TRUNC((End-Start)*2400)/100
```
---
### Author:  [@dylgarcia97](https://community.glideapps.com/u/dylgarcia97)
#### Post date: [March 28, 2022, 8:02pm UTC](https://community.glideapps.com/t/change-duration-format-from-hhss-to-hh-mm/40178/3 "2022-03-28T20:02:47Z")
> [@Jeff\_Hager](#):
>
> `TRUNC((End-Start)*2400)/100`
That worked!
Thank you so much!
---
### Author:  [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)
#### Post date: [March 28, 2022, 8:02pm UTC](https://community.glideapps.com/t/change-duration-format-from-hhss-to-hh-mm/40178/4 "2022-03-28T20:02:48Z")
Oh, I’ll have to try that one, @Jeff_Hager .
What I did is used a template column because I was bringing the value in from another table and the calc didn’t like the rollup. So, did a template column of the rollup with shows in time format and this did a math column using this formula FLOOR(T/60) / 60. This gives you the value in hours, so 1 hour, 30 mins would be 1.5 hours.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 28, 2022, 8:12pm UTC](https://community.glideapps.com/t/change-duration-format-from-hhss-to-hh-mm/40178/5 "2022-03-28T20:12:20Z")
> [@DarrenHumphries](#):
>
> FLOOR(T/60) / 60
Interesting. Just tried that out and it works too. Seems like it required the template for some reason, in between the math duration and the second math with your formula, which was weird.
---
### Author:  [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)
#### Post date: [March 28, 2022, 8:13pm UTC](https://community.glideapps.com/t/change-duration-format-from-hhss-to-hh-mm/40178/6 "2022-03-28T20:13:55Z")
I honestly don’t know why, but ya, it works. 🙂 Been using it for contract work timesheet and it all works fine.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 29, 2022, 8:14pm UTC](https://community.glideapps.com/t/change-duration-format-from-hhss-to-hh-mm/40178/7 "2022-03-29T20:14:40Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.