topic Rounding durations in QlikView https://community.qlik.com/t5/QlikView/Rounding-durations/m-p/1222957#M390786 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an expression for rounding durations, with a variable for the rounding step:</P><P>Interval(Round(ParkingDuration,(1/$(vDurationFrac))),'hh:mm'))</P><P>vDurationFrac can be 24,48,96&nbsp; (for 15,30,60 minutes).</P><P>When selecting fractions of 30 minutes, it's not clear how the rounding is done.</P><P>For example, duration range from 1:45 to 2:14 hours are rounded to 2:00 hours.</P><P>There are values 1:44 or 2:15 which are not taken into account.</P><P></P><P>Can someone clarify please?</P><P></P><P>Thanks!</P></BODY></HTML> Sun, 19 Feb 2017 18:47:38 GMT dafnis14 2017-02-19T18:47:38Z Rounding durations https://community.qlik.com/t5/QlikView/Rounding-durations/m-p/1222957#M390786 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an expression for rounding durations, with a variable for the rounding step:</P><P>Interval(Round(ParkingDuration,(1/$(vDurationFrac))),'hh:mm'))</P><P>vDurationFrac can be 24,48,96&nbsp; (for 15,30,60 minutes).</P><P>When selecting fractions of 30 minutes, it's not clear how the rounding is done.</P><P>For example, duration range from 1:45 to 2:14 hours are rounded to 2:00 hours.</P><P>There are values 1:44 or 2:15 which are not taken into account.</P><P></P><P>Can someone clarify please?</P><P></P><P>Thanks!</P></BODY></HTML> Sun, 19 Feb 2017 18:47:38 GMT https://community.qlik.com/t5/QlikView/Rounding-durations/m-p/1222957#M390786 dafnis14 2017-02-19T18:47:38Z Re: Rounding durations https://community.qlik.com/t5/QlikView/Rounding-durations/m-p/1222958#M390787 <HTML><HEAD></HEAD><BODY><P>I guess I figured it ..</P><P>according to Round Help:</P><P>"... If <SPAN class="Italic">x</SPAN> is exactly in the middle of an interval, it is rounded upwards..."</P></BODY></HTML> Sun, 19 Feb 2017 19:12:30 GMT https://community.qlik.com/t5/QlikView/Rounding-durations/m-p/1222958#M390787 dafnis14 2017-02-19T19:12:30Z Re: Rounding durations https://community.qlik.com/t5/QlikView/Rounding-durations/m-p/1222959#M390788 <HTML><HEAD></HEAD><BODY><P>please post some sample data with expected output</P></BODY></HTML> Sun, 19 Feb 2017 19:26:02 GMT https://community.qlik.com/t5/QlikView/Rounding-durations/m-p/1222959#M390788 vinieme12 2017-02-19T19:26:02Z