topic Re: Converting HH.MM to TIME. in QlikView https://community.qlik.com/t5/QlikView/Converting-HH-MM-to-TIME/m-p/458564#M171193 <HTML><HEAD></HEAD><BODY><P>You may use</P><P></P><P>Interval(Interval#('15.13','hh.mm'),'hh:mm')</P><P></P><P>to get the time in HH:MM format.</P><P></P><P>If you need the internal representation of time for further calculation, you may use</P><P></P><P>Num(Interval#('15.13','hh.mm'))</P></BODY></HTML> Tue, 02 Oct 2012 09:55:15 GMT nagaiank 2012-10-02T09:55:15Z Converting HH.MM to TIME. https://community.qlik.com/t5/QlikView/Converting-HH-MM-to-TIME/m-p/458562#M171191 <HTML><HEAD></HEAD><BODY><P>Good Day,</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have a TIME here but not formatted into time.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sample:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; 15.13 late means 15 hours 13 minute late. how can i convert it into a TIME.?</P><P></P><P></P><P></P><P></P><P>Thanks.</P></BODY></HTML> Tue, 02 Oct 2012 09:46:51 GMT https://community.qlik.com/t5/QlikView/Converting-HH-MM-to-TIME/m-p/458562#M171191 2012-10-02T09:46:51Z Re: Converting HH.MM to TIME. https://community.qlik.com/t5/QlikView/Converting-HH-MM-to-TIME/m-p/458563#M171192 <HTML><HEAD></HEAD><BODY><P><EM>interval(interval#('15.13','hh.mm'))</EM></P></BODY></HTML> Tue, 02 Oct 2012 09:54:52 GMT https://community.qlik.com/t5/QlikView/Converting-HH-MM-to-TIME/m-p/458563#M171192 Anonymous 2012-10-02T09:54:52Z Re: Converting HH.MM to TIME. https://community.qlik.com/t5/QlikView/Converting-HH-MM-to-TIME/m-p/458564#M171193 <HTML><HEAD></HEAD><BODY><P>You may use</P><P></P><P>Interval(Interval#('15.13','hh.mm'),'hh:mm')</P><P></P><P>to get the time in HH:MM format.</P><P></P><P>If you need the internal representation of time for further calculation, you may use</P><P></P><P>Num(Interval#('15.13','hh.mm'))</P></BODY></HTML> Tue, 02 Oct 2012 09:55:15 GMT https://community.qlik.com/t5/QlikView/Converting-HH-MM-to-TIME/m-p/458564#M171193 nagaiank 2012-10-02T09:55:15Z