topic Re: Rounding down hour/minutes in QlikView https://community.qlik.com/t5/QlikView/Rounding-down-hour-minutes/m-p/417482#M155247 <HTML><HEAD></HEAD><BODY><P>Try following :</P><P></P><P></P><P><EM><STRONG>time(round( time#([Time],'hh.mm.ss'),maketime(0,30))) as RoundedTime</STRONG></EM></P></BODY></HTML> Thu, 07 Feb 2013 21:53:05 GMT 2013-02-07T21:53:05Z Rounding down hour/minutes https://community.qlik.com/t5/QlikView/Rounding-down-hour-minutes/m-p/417481#M155246 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have captured the time intervals between to date/time fields.&nbsp; An example of my result is:&nbsp; 52:15:00.&nbsp; This represents 52 hour and 15 min between the two dates.&nbsp; I would like to round down to 52.&nbsp; I don't need the minutes and seconds.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 07 Feb 2013 21:49:19 GMT https://community.qlik.com/t5/QlikView/Rounding-down-hour-minutes/m-p/417481#M155246 2013-02-07T21:49:19Z Re: Rounding down hour/minutes https://community.qlik.com/t5/QlikView/Rounding-down-hour-minutes/m-p/417482#M155247 <HTML><HEAD></HEAD><BODY><P>Try following :</P><P></P><P></P><P><EM><STRONG>time(round( time#([Time],'hh.mm.ss'),maketime(0,30))) as RoundedTime</STRONG></EM></P></BODY></HTML> Thu, 07 Feb 2013 21:53:05 GMT https://community.qlik.com/t5/QlikView/Rounding-down-hour-minutes/m-p/417482#M155247 2013-02-07T21:53:05Z Re: Rounding down hour/minutes https://community.qlik.com/t5/QlikView/Rounding-down-hour-minutes/m-p/417483#M155248 <HTML><HEAD></HEAD><BODY><P>I was able to accomplish it by doing this</P><P></P><P>num(Left(TimeField, Len(TimeField)-6))</P><P></P><P></P><P></P></BODY></HTML> Fri, 08 Feb 2013 04:16:03 GMT https://community.qlik.com/t5/QlikView/Rounding-down-hour-minutes/m-p/417483#M155248 2013-02-08T04:16:03Z