# Time Calculations - hh:mm:ss conversion to hh

**URL:** https://community.glideapps.com/t/time-calculations-hhss-conversion-to-hh/60081
**Category:** Ask for Help
**Created:** [April 3, 2023, 5:37pm UTC](https://community.glideapps.com/t/time-calculations-hhss-conversion-to-hh/60081 "2023-04-03T17:37:54Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![James\_McIntosh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james_mcintosh/32/55885_2.png) [@James\_McIntosh](https://community.glideapps.com/u/James_McIntosh)
#### Post date: [April 3, 2023, 5:37pm UTC](https://community.glideapps.com/t/time-calculations-hhss-conversion-to-hh/60081/1 "2023-04-03T17:37:54Z")

</div>

Hi,

I am making an app that tracks time sheet entries. The user logs and “in” and “out” time with the date and time field picker, this is done daily. I want to calculate the hours logged by subtracting the “out” from the “in”, this gives me the time worked in format: hh:mm:ss.

How do I convert this to simple hh format?

Thanks for the help!

J

---

<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: [April 3, 2023, 5:56pm UTC](https://community.glideapps.com/t/time-calculations-hhss-conversion-to-hh/60081/2 "2023-04-03T17:56:29Z")

</div>

Date math will give you a duration in days/hour/minute I believe. Are you saying that you only want hours?

Have you tried the Date Difference column to see if that works for you?

Otherwise we might need to do some creative math in a math column to just return hours, which should be reasonably doable.