I have a date and time column that I wish to round either up or down to the nearest 5 minutes.

Oh! That’s even better! Just instead of the non-obvious 0.0347222 value you can use Minutes(5): RoundTo([Any time], Minutes(5)).ToTime() I had a feeling I saw a function for arbitrary rounding but wasn’t sure. Great catch @Saul_Garcia

Round up/down to nearest 5 minutes

Mike_Hewitt July 16, 2020, 10:39pm 11

I will see what I can do.

Topic		Replies	Views
Truncate Time in a Date	5	1005	November 15, 2022
Bug in hour() formula Bugs	7	496	November 4, 2022
Calculate now()-date, including hours?	3	714	October 6, 2022
How to avoid using Now() to reduce the calculation time of a Doc to check the hour?	3	823	December 11, 2020
(Solved) Bug: thisRow.Created() off by -1 seconds when adding hours(x) Suggestion Box	1	430	June 16, 2018

Round up/down to nearest 5 minutes

Related topics