🆕 Date-time Math

[Jeff_Hager]

Yes, in the data editor, the ceiling function only works with a math column.

This may or may not be useful for you.

New Math functions

@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. [image] The kicker here is that this will require a seed date.…