topic Create Date Time Formatting in QlikView https://community.qlik.com/t5/QlikView/Create-Date-Time-Formatting/m-p/1073949#M928819 <HTML><HEAD></HEAD><BODY><P>Hi Community </P><P></P><P>Please find the attached QVW file and advice on how i can format my time field .</P><P></P><P>e.g</P><P>253 to 00:02:53</P><P>20904 to 02:09:04</P><P></P><P>Regards</P><P>Mutshidzi </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Create Date Time Formatting https://community.qlik.com/t5/QlikView/Create-Date-Time-Formatting/m-p/1073949#M928819 <HTML><HEAD></HEAD><BODY><P>Hi Community </P><P></P><P>Please find the attached QVW file and advice on how i can format my time field .</P><P></P><P>e.g</P><P>253 to 00:02:53</P><P>20904 to 02:09:04</P><P></P><P>Regards</P><P>Mutshidzi </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Create-Date-Time-Formatting/m-p/1073949#M928819 2020-11-25T16:16:04Z Re: Create Date Time Formatting https://community.qlik.com/t5/QlikView/Create-Date-Time-Formatting/m-p/1073950#M928820 <HTML><HEAD></HEAD><BODY><P>Try something like this:</P><P></P><P><STRONG>LOAD&nbsp; </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; WI_CT as [Creation Time],</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Interval(Interval#(Num(WI_CT, '000000'), 'hhmmss'), 'hh:mm:ss') as NewCreationTime</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG><C></C></STRONG></P><P><STRONG>(ooxml, embedded labels, table is Multi0103);</STRONG></P></BODY></HTML> Tue, 15 Mar 2016 10:04:45 GMT https://community.qlik.com/t5/QlikView/Create-Date-Time-Formatting/m-p/1073950#M928820 sunny_talwar 2016-03-15T10:04:45Z Re: Create Date Time Formatting https://community.qlik.com/t5/QlikView/Create-Date-Time-Formatting/m-p/1073951#M928821 <HTML><HEAD></HEAD><BODY><P>Did you check this?</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/4002">The Date Function</A></P><P></P><P><A href="https://community.qlik.com/thread/73387">Date/Time format</A></P></BODY></HTML> Tue, 15 Mar 2016 10:33:04 GMT https://community.qlik.com/t5/QlikView/Create-Date-Time-Formatting/m-p/1073951#M928821 Anonymous 2016-03-15T10:33:04Z