Help with minute function

Hi, trying to create simple app to track time in 15 minute increments. The minute function doesn’t seem to want to compute. This is how my math line looks “green * MINUTE(15)”. Any help would be much appreciated. Thanks!

I assume that you’re trying to use the Glide Math column?

With date math, you need at least one input that should be a datetime value. This can be the current datetime (Now), or a datetime value from a table column.

For example, let’s say you wanted to add 15 minutes to the current time, the formula would be:

Now + 15/1440

Not sure if that helps. If it doesn’t, can you explain what you are attempting to do with the formula you’ve tried and isn’t working?

1 Like


Thanks for the response. I did come across an old thread which did explain what you described so I did apply the same formula and that worked! I just thought the MINUTE(15) function would have returned the same 15 minutes.

Thanks again!


Glide does have a Minute() function (as well as year, month, day, etc), but they work a little differently to that. Each of those will extract an integer value from the datetime that is supplied.

For example, if the current datetime is *Jan 26th 2023, 9:24am, then:

  • Year(Now) returns 2023
  • Month(Now) returns 1
  • Day(Now) returns 26
  • Hour(Now) returns 9
  • Minute(Now) returns 24

(Weekday() & Second() are also supported)

* Happy Australia Day! :australia: :kangaroo:


Ah nice! Thanks for the explanation!