# Add time to a date, time specific to Row

**URL:** <https://community.glideapps.com/t/add-time-to-a-date-time-specific-to-row/72739>\
**Category:** Ask for Help\
**Created:** [April 19, 2024, 9:07pm UTC](https://community.glideapps.com/t/add-time-to-a-date-time-specific-to-row/72739 "2024-04-19T21:07:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aiden\_Anderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aiden_anderson/32/67692_2.png) [@Aiden\_Anderson](https://community.glideapps.com/u/Aiden_Anderson)\
**Post date:** [April 19, 2024, 9:07pm UTC](https://community.glideapps.com/t/add-time-to-a-date-time-specific-to-row/72739/1 "2024-04-19T21:07:40Z")

</div>

I have an app and I want it to open to users one at time in 20 second increments from when a action is triggered.  
Each row has a different value to correspond to the amount of seconds, 0,20,40,60,80 ect. Currently I have the time the button was pushed in a column, then i was going to use a math column to add the seconds to the date. But when I put the seconds column into the equation on the math column I get an error invalid operation for date/time. How can I do this?

---

<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 19, 2024, 9:45pm UTC](https://community.glideapps.com/t/add-time-to-a-date-time-specific-to-row/72739/2 "2024-04-19T21:45:55Z")

</div>

What does your math look like?

---

<div class="post-metadata">

**Author:** ![Aiden\_Anderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aiden_anderson/32/67692_2.png) [@Aiden\_Anderson](https://community.glideapps.com/u/Aiden_Anderson)\
**Post date:** [April 19, 2024, 10:06pm UTC](https://community.glideapps.com/t/add-time-to-a-date-time-specific-to-row/72739/3 "2024-04-19T22:06:11Z")

</div>

![Screenshot 2024-04-19 at 3.05.19 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2e9532822cbd0fcd59a119ace6b59d5e84ad1067.png)  
 ![Screenshot 2024-04-19 at 3.05.14 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b19cc624c7d652d503180ba8215939adc82a1054.png)  
Its not giving me an error now, but its also not adding the time.

---

<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 19, 2024, 10:37pm UTC](https://community.glideapps.com/t/add-time-to-a-date-time-specific-to-row/72739/4 "2024-04-19T22:37:25Z")

</div>

Math needs numbers or dates to work. Your format date column does not return a number. It’s a text based character string. You are better off using the original numeric WAIT column in your math instead.

Also, date math in glide is based on days. 1 equals 1 whole day. You need the decimal version of seconds, so change your math to look like this and make sure WAIT is referring to the unformatted version of seconds.

`TURN + (WAIT/86400)`

---

<div class="post-metadata">

**Author:** ![Aiden\_Anderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aiden_anderson/32/67692_2.png) [@Aiden\_Anderson](https://community.glideapps.com/u/Aiden_Anderson)\
**Post date:** [April 19, 2024, 10:53pm UTC](https://community.glideapps.com/t/add-time-to-a-date-time-specific-to-row/72739/5 "2024-04-19T22:53:53Z")

</div>

Thank you!