topic Re: Time Formatting on a create time field in QlikView https://community.qlik.com/t5/QlikView/Time-Formatting-on-a-create-time-field/m-p/1073897#M928864 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Interval(Interval#(Num(253, '000000'), 'hhmmss'), 'hh:mm:ss')</STRONG></P><P><STRONG>=Interval(Interval#(Num(20904, '000000'), 'hhmmss'), 'hh:mm:ss')</STRONG></P></BODY></HTML> Tue, 15 Mar 2016 09:57:54 GMT sunny_talwar 2016-03-15T09:57:54Z Time Formatting on a create time field https://community.qlik.com/t5/QlikView/Time-Formatting-on-a-create-time-field/m-p/1073896#M928863 <HTML><HEAD></HEAD><BODY><P>Hi guys </P><P></P><P>Please find the attached and Advice on how i can get this right</P><P></P><P>E.G .. 253 is suppose to be 00:02:53</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20904 is suppose to be 02:09:04</P><P></P><P></P><P></P><P>Thank you very much</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Time-Formatting-on-a-create-time-field/m-p/1073896#M928863 2020-11-25T16:16:04Z Re: Time Formatting on a create time field https://community.qlik.com/t5/QlikView/Time-Formatting-on-a-create-time-field/m-p/1073897#M928864 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Interval(Interval#(Num(253, '000000'), 'hhmmss'), 'hh:mm:ss')</STRONG></P><P><STRONG>=Interval(Interval#(Num(20904, '000000'), 'hhmmss'), 'hh:mm:ss')</STRONG></P></BODY></HTML> Tue, 15 Mar 2016 09:57:54 GMT https://community.qlik.com/t5/QlikView/Time-Formatting-on-a-create-time-field/m-p/1073897#M928864 sunny_talwar 2016-03-15T09:57:54Z Re: Time Formatting on a create time field https://community.qlik.com/t5/QlikView/Time-Formatting-on-a-create-time-field/m-p/1073898#M928865 <HTML><HEAD></HEAD><BODY><P>chk ds</P><P>=interval(urfield,'hhmmss')</P><P></P><P><A href="https://community.qlik.com/message/984490">Timestamp</A></P><P><A href="https://community.qlik.com/message/957970">Date &amp;amp; Time format</A></P></BODY></HTML> Tue, 15 Mar 2016 10:05:26 GMT https://community.qlik.com/t5/QlikView/Time-Formatting-on-a-create-time-field/m-p/1073898#M928865 Chanty4u 2016-03-15T10:05:26Z Re: Time Formatting on a create time field https://community.qlik.com/t5/QlikView/Time-Formatting-on-a-create-time-field/m-p/1073899#M928866 <HTML><HEAD></HEAD><BODY><P>Sunny You are the best , it work fine .</P><P></P><P>Thank You very Much .</P></BODY></HTML> Tue, 15 Mar 2016 10:10:11 GMT https://community.qlik.com/t5/QlikView/Time-Formatting-on-a-create-time-field/m-p/1073899#M928866 2016-03-15T10:10:11Z