# Need help calculating length of time

**URL:** <https://community.glideapps.com/t/need-help-calculating-length-of-time/27696>\
**Category:** Ask for Help\
**Created:** [June 6, 2021, 1:45am UTC](https://community.glideapps.com/t/need-help-calculating-length-of-time/27696 "2021-06-06T01:45:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\
**Post date:** [June 6, 2021, 1:45am UTC](https://community.glideapps.com/t/need-help-calculating-length-of-time/27696/1 "2021-06-06T01:45:05Z")

</div>

Trying to calculate the length of an event as end time - start time

 ![Screen Shot 2021-06-06 at 03.42.45](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/d/9d516649ff75c2e1e30c59c8356aefa4a45cce64.png)

Result is not correct. Please help

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [June 6, 2021, 1:59am UTC](https://community.glideapps.com/t/need-help-calculating-length-of-time/27696/2 "2021-06-06T01:59:56Z")

</div>

Hola @Ganymed

Would something like this help?

 ![Screen Shot 2021-06-05 at 8.58.28 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a686cea648bd6b3cfefcbc0e3f3c379a2061678f.png)

 ![Screen Shot 2021-06-05 at 8.58.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6de412d8c59f9cdae45c30dfbdee62332dc459e3.png)

---

<div class="post-metadata">

**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\
**Post date:** [June 6, 2021, 2:16am UTC](https://community.glideapps.com/t/need-help-calculating-length-of-time/27696/3 "2021-06-06T02:16:29Z")

</div>

Thanks, but not really

 ![Screen Shot 2021-06-06 at 04.14.48](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/316ee5b5008e84b6cc4eff3e47564112282221bb.png)

Not sure why…

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 6, 2021, 2:19am UTC](https://community.glideapps.com/t/need-help-calculating-length-of-time/27696/4 "2021-06-06T02:19:19Z")

</div>

If you change the format of the 2 time columns to show date and time, what do you see?  
Are they both the same date?  
Even though you might set a column to show time only, the full date and time is still stored internally.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [June 6, 2021, 10:13am UTC](https://community.glideapps.com/t/need-help-calculating-length-of-time/27696/5 "2021-06-06T10:13:52Z")

</div>

It should be y-x in your math column, you have x-y … that’s why result is negative

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/need-help-calculating-length-of-time/27696/6 "2024-01-17T16:51:53Z")

</div>