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?
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.
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
Second() are also supported)
* Happy Australia Day!
Ah nice! Thanks for the explanation!