Rounding time down to nearest 30 minute Interval

[harson]

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

[marcus_sommer]

You could use:

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

- Marcus