Rounding time down to nearest 30 minute Interval

harson — Tue, 22 Jul 2025 17:59:49 GMT

Hello,

Does anyone know how to round down to the nearest 30 minute interval with date and time stamps?

Ex :

01/01/2018 07 :05 :00 to 07 :00 :00

01/01/2018 07 :29 :00 to 07 :00 :00

01/01/2018 07 :30 :00 to 07 :30 :00

01/01/2018 07 :59 :00 to 07 :30 :00

01/01/2018 08 :00 :00 to 08 :00 :00

Thanks,

Tsiry

Re: Rounding time down to nearest 30 minute Interval

marcus_sommer — Tue, 13 Feb 2018 08:07:29 GMT

You could use:

= time(floor(frac(YourTimestamp), 1/48))

- Marcus