topic Round Time Down in QlikView https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845358#M296836 <HTML><HEAD></HEAD><BODY><P>I am looking for a way to always round time down to the nearest :45. For example if the time is 12:38, it would round down to 11:45. Any help would be greatly appreciated. Thank you. </P></BODY></HTML> Wed, 17 Jun 2015 16:54:48 GMT tchovanec 2015-06-17T16:54:48Z Round Time Down https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845358#M296836 <HTML><HEAD></HEAD><BODY><P>I am looking for a way to always round time down to the nearest :45. For example if the time is 12:38, it would round down to 11:45. Any help would be greatly appreciated. Thank you. </P></BODY></HTML> Wed, 17 Jun 2015 16:54:48 GMT https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845358#M296836 tchovanec 2015-06-17T16:54:48Z Re: Round Time Down https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845359#M296837 <HTML><HEAD></HEAD><BODY><P>Add 15 minutes, round down to the hour, and subtract 15 minutes?</P></BODY></HTML> Wed, 17 Jun 2015 16:58:51 GMT https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845359#M296837 m_woolf 2015-06-17T16:58:51Z Re: Round Time Down https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845360#M296838 <HTML><HEAD></HEAD><BODY><P>Use floor with an offset:</P><P></P><P>=interval(floor(time#('12:38','hh:mm'), Interval#('1:00','h:mm'), Interval#('00:45','hh:mm')))</P></BODY></HTML> Wed, 17 Jun 2015 17:01:44 GMT https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845360#M296838 swuehl 2015-06-17T17:01:44Z Re: Round Time Down https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845361#M296839 <HTML><HEAD></HEAD><BODY><P>Great idea <A _jive_internal="true" href="https://community.qlik.com/people/mwoolf">mike woolf</A>, but I was <SPAN style="font-size: 13.3333330154419px;">trying to think of scenarios where it may not work. </SPAN>12:48 may round down to 11:45 also, right?</P></BODY></HTML> Wed, 17 Jun 2015 17:01:55 GMT https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845361#M296839 sunny_talwar 2015-06-17T17:01:55Z Re: Round Time Down https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845362#M296840 <HTML><HEAD></HEAD><BODY><P>12:48 + 15 minutes = 13:03</P><P>13:03 rounds down to 13:00</P><P>13:00 - 15 minutes = 12:45</P><P></P><P>I would look at swuehl's reply. He knows everything.</P></BODY></HTML> Wed, 17 Jun 2015 17:05:19 GMT https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845362#M296840 m_woolf 2015-06-17T17:05:19Z Re: Round Time Down https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845363#M296841 <HTML><HEAD></HEAD><BODY><P>Genius <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 17 Jun 2015 17:09:53 GMT https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845363#M296841 sunny_talwar 2015-06-17T17:09:53Z Re: Round Time Down https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845364#M296842 <HTML><HEAD></HEAD><BODY><P>This also works perfect</P></BODY></HTML> Wed, 17 Jun 2015 17:13:38 GMT https://community.qlik.com/t5/QlikView/Round-Time-Down/m-p/845364#M296842 tchovanec 2015-06-17T17:13:38Z