topic Help with formatting Time in QlikView https://community.qlik.com/t5/QlikView/Help-with-formatting-Time/m-p/262298#M1203996 <HTML><HEAD></HEAD><BODY><P>Thanks for your answer, thats not exactly what i wanted though. i have several thousand different transactions at different times, i want the format for every transaction time to be displayed as HH:MM. at the moment they are all displayed as hhmmss.</P><P>Any ideas?</P></BODY></HTML> Wed, 16 Jun 2010 14:09:41 GMT hopkinsc 2010-06-16T14:09:41Z Help with formatting Time https://community.qlik.com/t5/QlikView/Help-with-formatting-Time/m-p/262296#M1203994 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a Dimension set up for 'Transaction Time'. I would like to change the format in which the time is displayed. It currently shows as 211024 which is basically 9:10pm and 24secs but i want it to display as 21:10.</P><P>Can anyone help?</P></BODY></HTML> Wed, 16 Jun 2010 13:13:42 GMT https://community.qlik.com/t5/QlikView/Help-with-formatting-Time/m-p/262296#M1203994 hopkinsc 2010-06-16T13:13:42Z Help with formatting Time https://community.qlik.com/t5/QlikView/Help-with-formatting-Time/m-p/262297#M1203995 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>time(time#('211024', 'HHMMSS'), 'HH:MM:SS')</P></BODY></HTML> Wed, 16 Jun 2010 13:19:59 GMT https://community.qlik.com/t5/QlikView/Help-with-formatting-Time/m-p/262297#M1203995 sparur 2010-06-16T13:19:59Z Help with formatting Time https://community.qlik.com/t5/QlikView/Help-with-formatting-Time/m-p/262298#M1203996 <HTML><HEAD></HEAD><BODY><P>Thanks for your answer, thats not exactly what i wanted though. i have several thousand different transactions at different times, i want the format for every transaction time to be displayed as HH:MM. at the moment they are all displayed as hhmmss.</P><P>Any ideas?</P></BODY></HTML> Wed, 16 Jun 2010 14:09:41 GMT https://community.qlik.com/t5/QlikView/Help-with-formatting-Time/m-p/262298#M1203996 hopkinsc 2010-06-16T14:09:41Z Help with formatting Time https://community.qlik.com/t5/QlikView/Help-with-formatting-Time/m-p/262299#M1203997 <HTML><HEAD></HEAD><BODY><P>you can do it load script:</P><P>LOAD</P><P>....</P><P>TimeField,</P><P>time(time#(Left(TimeField, 4), 'HHMM'), 'HH:MM') AS FormattedTimeField</P><P>FROM ...</P></BODY></HTML> Wed, 16 Jun 2010 14:13:20 GMT https://community.qlik.com/t5/QlikView/Help-with-formatting-Time/m-p/262299#M1203997 sparur 2010-06-16T14:13:20Z