# Hours HH:MM format to decimal format

**URL:** https://community.glideapps.com/t/hours-hh-mm-format-to-decimal-format/84512
**Category:** Ask for Help
**Created:** [September 22, 2025, 12:25am UTC](https://community.glideapps.com/t/hours-hh-mm-format-to-decimal-format/84512 "2025-09-22T00:25:14Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Guillaume\_Belanger](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/guillaume_belanger/32/91919_2.png) [@Guillaume\_Belanger](https://community.glideapps.com/u/Guillaume_Belanger)
#### Post date: [September 22, 2025, 12:25am UTC](https://community.glideapps.com/t/hours-hh-mm-format-to-decimal-format/84512/1 "2025-09-22T00:25:14Z")

</div>

Hello everyone,

I’m building a piece work productivity app where employees enter their time at the beginnig and end of a period, eg. : 13H00 to 17H00 in two time columns and in a third I want do have the time difference so I can use it to calculate their efficiency per hours then.

I’ve tried substrating the two to each other in a math column but it give me akward long strain of numbers.. clearly I can’t make a piece work ratio out of it haha 😜

I’d like to know if there is a formula of another computed column to change HH:MM hour format to decimal hour format like this : 13H30 would equal 1,5PM or 13,5.

Thanks in advance 🙂

---

<div class="post-metadata">

### Author: ![Swift\_Struck\_24](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/swift_struck_24/32/91605_2.png) [@Swift\_Struck\_24](https://community.glideapps.com/u/Swift_Struck_24)
#### Post date: [September 22, 2025, 5:49am UTC](https://community.glideapps.com/t/hours-hh-mm-format-to-decimal-format/84512/2 "2025-09-22T05:49:47Z")

</div>

> [@Guillaume\_Belanger](#):
>
> I’d like to know if there is a formula of another computed column to change HH:MM hour format to decimal hour format like this : 13H30 would equal 1,5PM or 13,5.

hello, i would try this approach:

1. first, create a “[date difference](https://www.glideapps.com/docs/date-difference)” computed column and ensure the output is in seconds and accuracy is longterm
2. Then create a [“format duration”](https://www.glideapps.com/docs/automation/computed-columns/format-duration) computed column.. in this, link the date difference column and set the format to something like “hh:mm”

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 22, 2025, 11:52pm UTC](https://community.glideapps.com/t/hours-hh-mm-format-to-decimal-format/84512/3 "2025-09-22T23:52:43Z")

</div>

What column type are you using to store “13H00” or “17H00”?