# Compare time in glide
**URL:** https://community.glideapps.com/t/compare-time-in-glide/80436
**Category:** Ask for Help
**Created:** [March 2, 2025, 4:35am UTC](https://community.glideapps.com/t/compare-time-in-glide/80436 "2025-03-02T04:35:46Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Razan](https://community.glideapps.com/u/Razan)
#### Post date: [March 2, 2025, 4:35am UTC](https://community.glideapps.com/t/compare-time-in-glide/80436/1 "2025-03-02T04:35:46Z")
Hello
In the column this is a time completed come from the form in [typeform.com](http://typeform.com)
this form should completed in 3 hours or less …so I want to calculate if the user exceed 3 hours the glide give the user alert
How to do that in Glide?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 2, 2025, 6:52am UTC](https://community.glideapps.com/t/compare-time-in-glide/80436/2 "2025-03-02T06:52:49Z")
Glide calculates dates and times in days, so 3 hours would equal 0.125. Your numbers would indicate a time of a minute or two, which probably isn’t the same type of measurement, so you need to figure out what the equivalent of 3 hours is in decimal form and check if your number is less than or greater than that number.
---
### Author:  [@Razan](https://community.glideapps.com/u/Razan)
#### Post date: [March 2, 2025, 6:01pm UTC](https://community.glideapps.com/t/compare-time-in-glide/80436/3 "2025-03-02T18:01:34Z")
I can’t deal with this time foramt ☹
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 3, 2025, 1:03am UTC](https://community.glideapps.com/t/compare-time-in-glide/80436/4 "2025-03-03T01:03:08Z")
You can just use a math column to convert that to hours, no?
Just to confirm: Is that a duration, or the timestamp completed somehow formatted in that way?
Can you show us how you get that number from Typeform?
---
### Author:  [@Razan](https://community.glideapps.com/u/Razan)
#### Post date: [March 3, 2025, 7:10am UTC](https://community.glideapps.com/t/compare-time-in-glide/80436/5 "2025-03-03T07:10:49Z")
I received from typeform like in the pic
But when send it to googlesheet became like the time in the column above @ThinhDinh
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 3, 2025, 7:19am UTC](https://community.glideapps.com/t/compare-time-in-glide/80436/7 "2025-03-03T07:19:14Z")
Go to the Glide Data Editor, and change the column type to Duration. I suspect that is all you need to do.
---
### Author:  [@Razan](https://community.glideapps.com/u/Razan)
#### Post date: [March 3, 2025, 8:07am UTC](https://community.glideapps.com/t/compare-time-in-glide/80436/8 "2025-03-03T08:07:23Z")
Thank yo very much . The format now is solved but still I can’t compare by if conditions or do math on these two columns …here is screenshot
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 3, 2025, 8:23am UTC](https://community.glideapps.com/t/compare-time-in-glide/80436/9 "2025-03-03T08:23:08Z")
To convert the duration to number of hours, use the following in a math column:
```auto
Round(Duration*24,2)
```
