Discussion Board for collaboration on QlikView Scripting.
Hi, how can I round down time 'hh:mm' to hours? eg. 07:55 will round down to '07:00'
Go to Solution.
I don't know, if there's a simplier solution, but "maketime(hour(<TimeField>))" should do the trick. If you only set the format, the value stays at 07:55, it's only displayed as 07:00.