# Math Column showing result wrong

**URL:** <https://community.glideapps.com/t/math-column-showing-result-wrong/75202>\
**Category:** Ask for Help\
**Tags:** date-math\
**Created:** [July 27, 2024, 6:28am UTC](https://community.glideapps.com/t/math-column-showing-result-wrong/75202 "2024-07-27T06:28:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Terence\_Vrugtman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/terence_vrugtman/32/29358_2.png) [@Terence\_Vrugtman](https://community.glideapps.com/u/Terence_Vrugtman)\
**Post date:** [July 27, 2024, 6:28am UTC](https://community.glideapps.com/t/math-column-showing-result-wrong/75202/1 "2024-07-27T06:28:18Z")

</div>

I have a math column. I am working out a timestamp - Start Time to get the length of time or duration. The app/column keeps showing the format in a date and time format rather than a duration format. All other tables are represented right, just this one is refusing to show duration.

---

<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:** [July 27, 2024, 6:29am UTC](https://community.glideapps.com/t/math-column-showing-result-wrong/75202/2 "2024-07-27T06:29:34Z")

</div>

Can you share a screen shot that shows all 3 columns please?

---

<div class="post-metadata">

**Author:** ![Terence\_Vrugtman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/terence_vrugtman/32/29358_2.png) [@Terence\_Vrugtman](https://community.glideapps.com/u/Terence_Vrugtman)\
**Post date:** [July 27, 2024, 4:22pm UTC](https://community.glideapps.com/t/math-column-showing-result-wrong/75202/3 "2024-07-27T16:22:54Z")

</div>

![Screenshot 2024-07-27 at 18.22.09](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/44d9144745596bbb4e95e39e2cf975ca56218929.png)  
 ![Screenshot 2024-07-27 at 18.22.22](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/82d70749acd6ba86a4295f207003d3e7bbc365f6.png)  
 ![Screenshot 2024-07-27 at 18.22.36](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/eab8ecbc0199f4dee42da151b20e5cb320c3fee9.png)

---

<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:** [July 27, 2024, 5:53pm UTC](https://community.glideapps.com/t/math-column-showing-result-wrong/75202/4 "2024-07-27T17:53:43Z")

</div>

The problem is with your Gun Start lookup column. It’s returning an array, and that won’t work properly in your math formula.

I suspect that your EventRace relation column is a multiple relation. The solution is most likely just to change that to a single relation.

---

<div class="post-metadata">

**Author:** ![Terence\_Vrugtman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/terence_vrugtman/32/29358_2.png) [@Terence\_Vrugtman](https://community.glideapps.com/u/Terence_Vrugtman)\
**Post date:** [July 29, 2024, 7:40pm UTC](https://community.glideapps.com/t/math-column-showing-result-wrong/75202/5 "2024-07-29T19:40:41Z")

</div>

Thanks.