topic Re: Time format in QlikView https://community.qlik.com/t5/QlikView/Time-format/m-p/775709#M274999 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P>Timeformat:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; time_minuts</P><P>&nbsp;&nbsp;&nbsp; 0600</P><P>&nbsp;&nbsp;&nbsp; 0610</P><P>&nbsp;&nbsp;&nbsp; 0630</P><P>&nbsp;&nbsp;&nbsp; 0640</P><P>&nbsp;&nbsp;&nbsp; 0645</P><P>&nbsp;&nbsp;&nbsp; 0650</P><P>&nbsp;&nbsp;&nbsp; 0655</P><P>];</P><P></P><P></P><P>LOAD *,</P><P></P><P>Left(time_minuts,2)&amp;':'&amp;right(time_minuts,2) as times</P><P></P><P></P><P>Resident Timeformat;</P><P>DROP Table Timeformat;</P></BODY></HTML> Tue, 24 Mar 2015 07:04:38 GMT sagarkharpude 2015-03-24T07:04:38Z Time format https://community.qlik.com/t5/QlikView/Time-format/m-p/775706#M274996 <HTML><HEAD></HEAD><BODY><P>Hi QV team,</P><P></P><P>This is actual script.</P><P>Timeformat:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; time_minuts</P><P>&nbsp;&nbsp;&nbsp; 0600</P><P>&nbsp;&nbsp;&nbsp; 0610</P><P>&nbsp;&nbsp;&nbsp; 0630</P><P>&nbsp;&nbsp;&nbsp; 0640</P><P>&nbsp;&nbsp;&nbsp; 0645</P><P>&nbsp;&nbsp;&nbsp; 0650</P><P>&nbsp;&nbsp;&nbsp; 0655</P><P>];</P><P></P><P>I require above time format like this </P><P> 06:00</P><P> 06:10</P><P> 06:30</P><P> 06:40</P><P> 06:45</P><P> 06:50</P><P> 06:55</P></BODY></HTML> Tue, 24 Mar 2015 06:59:32 GMT https://community.qlik.com/t5/QlikView/Time-format/m-p/775706#M274996 2015-03-24T06:59:32Z Re: Time format https://community.qlik.com/t5/QlikView/Time-format/m-p/775707#M274997 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use</P><P>time(time#(time_minuts,'hhmm'),'hh:mm')</P><P></P><P>Regards</P></BODY></HTML> Tue, 24 Mar 2015 07:01:04 GMT https://community.qlik.com/t5/QlikView/Time-format/m-p/775707#M274997 PrashantSangle 2015-03-24T07:01:04Z Re: Time format https://community.qlik.com/t5/QlikView/Time-format/m-p/775708#M274998 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Like this???</P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Tue, 24 Mar 2015 07:04:29 GMT https://community.qlik.com/t5/QlikView/Time-format/m-p/775708#M274998 amit_saini 2015-03-24T07:04:29Z Re: Time format https://community.qlik.com/t5/QlikView/Time-format/m-p/775709#M274999 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P>Timeformat:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; time_minuts</P><P>&nbsp;&nbsp;&nbsp; 0600</P><P>&nbsp;&nbsp;&nbsp; 0610</P><P>&nbsp;&nbsp;&nbsp; 0630</P><P>&nbsp;&nbsp;&nbsp; 0640</P><P>&nbsp;&nbsp;&nbsp; 0645</P><P>&nbsp;&nbsp;&nbsp; 0650</P><P>&nbsp;&nbsp;&nbsp; 0655</P><P>];</P><P></P><P></P><P>LOAD *,</P><P></P><P>Left(time_minuts,2)&amp;':'&amp;right(time_minuts,2) as times</P><P></P><P></P><P>Resident Timeformat;</P><P>DROP Table Timeformat;</P></BODY></HTML> Tue, 24 Mar 2015 07:04:38 GMT https://community.qlik.com/t5/QlikView/Time-format/m-p/775709#M274999 sagarkharpude 2015-03-24T07:04:38Z Re: Time format https://community.qlik.com/t5/QlikView/Time-format/m-p/775710#M275000 <HTML><HEAD></HEAD><BODY><P>Hi Max,</P><P></P><P>&nbsp;&nbsp;&nbsp; Thank you for gave correct answer. </P></BODY></HTML> Tue, 24 Mar 2015 08:40:22 GMT https://community.qlik.com/t5/QlikView/Time-format/m-p/775710#M275000 2015-03-24T08:40:22Z