# 🆕 Date-time Math **URL:** \ **Category:** General\ **Tags:** data-editor\ **Created:** [September 17, 2020, 5:47pm UTC](https://community.glideapps.com/t/date-time-math/15963 "2020-09-17T17:47:41Z")\ **Posts on this page:** 1\ **Showing post:** 77
**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:** [January 16, 2021, 12:18am UTC](https://community.glideapps.com/t/date-time-math/15963/77 "2021-01-16T00:18:40Z")
Yes, in the data editor, the ceiling function only works with a math column. This may or may not be useful for you. > [@abacus New Math functions](https://community.glideapps.com/t/new-math-functions/16761/52): > > @Rasha I think I got it. I feel pretty good about this one. This formula will calculate the time to the next half hour. It does float between 0 and 1 seconds after the minute, but appears to stick on the exact minute of the next half hour and switching to not show seconds will give you a good view. I did watch the time switch from 5:59 to 6:00 and after that, the value changed from 6:00 to 6:30, so I feel pretty good about it. The kicker here is that this will require a seed date.… --- _[View the full topic](https://community.glideapps.com/t/date-time-math/15963)._