Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
harson
Contributor III
Contributor III

Rounding time down to nearest 30 minute Interval

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

1 Reply
marcus_sommer

You could use:

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

- Marcus