topic Re: Time Conversion in QlikView https://community.qlik.com/t5/QlikView/Time-Conversion/m-p/478822#M178870 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=floor(interval#('2:15:31','h:mm:ss'),1/(24*60))*24</P><P></P><P>or</P><P>=floor(interval#(TIMEFIELD,'h:mm:ss'),1/(24*60))*24</P></BODY></HTML> Thu, 12 Dec 2013 14:33:34 GMT swuehl 2013-12-12T14:33:34Z Time Conversion https://community.qlik.com/t5/QlikView/Time-Conversion/m-p/478821#M178869 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P>i have a time like<STRONG> <SPAN style="color: #000000;">2:15:31</SPAN></STRONG>&nbsp; that&nbsp;&nbsp; i want convert like this <STRONG style="color: #000000;">2.25</STRONG> HR, by ignoring seconds if required</P><P>is its possible in qlikview</P></BODY></HTML> Thu, 12 Dec 2013 14:27:49 GMT https://community.qlik.com/t5/QlikView/Time-Conversion/m-p/478821#M178869 2013-12-12T14:27:49Z Re: Time Conversion https://community.qlik.com/t5/QlikView/Time-Conversion/m-p/478822#M178870 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=floor(interval#('2:15:31','h:mm:ss'),1/(24*60))*24</P><P></P><P>or</P><P>=floor(interval#(TIMEFIELD,'h:mm:ss'),1/(24*60))*24</P></BODY></HTML> Thu, 12 Dec 2013 14:33:34 GMT https://community.qlik.com/t5/QlikView/Time-Conversion/m-p/478822#M178870 swuehl 2013-12-12T14:33:34Z