topic Rounding time down to nearest 30 minute Interval in QlikView

Rounding time down to nearest 30 minute Interval

harson — Tue, 13 Feb 2018 06:07:02 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

zhadrakas — Tue, 13 Feb 2018 07:58:23 GMT

try like this

=time(round(frac(Time), 1/24/2) , 'hh:mm:ss')

tresB — Tue, 13 Feb 2018 09:31:23 GMT

Or, may be using floor() to round it down ? like:

time(floor(frac(date#(time,'dd/MM/yyyy hh :mm :ss')), 1/24/2) , 'hh:mm:ss')

marcus_sommer — Tue, 13 Feb 2018 09:36:32 GMT

Miguel_Angel_Baeyens — Tue, 13 Feb 2018 10:55:43 GMT

Basically it has been said already but you can find more examples here: