topic Re: Time Format in QlikView https://community.qlik.com/t5/QlikView/Time-Format/m-p/494014#M184807 <HTML><HEAD></HEAD><BODY><P>i did the same thing , but i got :</P><P></P><P>12:12</P><P>12:12</P><P>12:13</P><P>12:13</P></BODY></HTML> Thu, 20 Jun 2013 15:35:49 GMT Anonymous 2013-06-20T15:35:49Z Time Format https://community.qlik.com/t5/QlikView/Time-Format/m-p/494012#M184805 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm wondering how to change the format of my time field ? exempl:</P><P></P><P>12:12:03</P><P>12:12:45</P><P>12:13:03</P><P>12:13:54</P><P></P><P>i want to change this time to :</P><P></P><P>12:12</P><P>12:13</P><P></P><P>???</P><P></P><P>regards</P></BODY></HTML> Thu, 20 Jun 2013 15:28:17 GMT https://community.qlik.com/t5/QlikView/Time-Format/m-p/494012#M184805 Anonymous 2013-06-20T15:28:17Z Re: Time Format https://community.qlik.com/t5/QlikView/Time-Format/m-p/494013#M184806 <HTML><HEAD></HEAD><BODY><P>If it's already a time field then<EM> time(MyTime, 'hh:mm') </EM>will do. If it's a string you need <EM>time(time#(MyTime,'hh:mm:ss'),'hh:mm'). </EM>Replace MyTime with the name of your time field.</P></BODY></HTML> Thu, 20 Jun 2013 15:31:55 GMT https://community.qlik.com/t5/QlikView/Time-Format/m-p/494013#M184806 Gysbert_Wassenaar 2013-06-20T15:31:55Z Re: Time Format https://community.qlik.com/t5/QlikView/Time-Format/m-p/494014#M184807 <HTML><HEAD></HEAD><BODY><P>i did the same thing , but i got :</P><P></P><P>12:12</P><P>12:12</P><P>12:13</P><P>12:13</P></BODY></HTML> Thu, 20 Jun 2013 15:35:49 GMT https://community.qlik.com/t5/QlikView/Time-Format/m-p/494014#M184807 Anonymous 2013-06-20T15:35:49Z Re: Time Format https://community.qlik.com/t5/QlikView/Time-Format/m-p/494015#M184808 <HTML><HEAD></HEAD><BODY><P>ah, in that case use <EM>time(floor(MyTime,1/1440),'hh:mm')</EM></P></BODY></HTML> Thu, 20 Jun 2013 15:41:11 GMT https://community.qlik.com/t5/QlikView/Time-Format/m-p/494015#M184808 Gysbert_Wassenaar 2013-06-20T15:41:11Z Re: Time Format https://community.qlik.com/t5/QlikView/Time-Format/m-p/494016#M184809 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try using</P><P></P><P>time(ceil(num(F1),0.001),'hh:mm')</P></BODY></HTML> Thu, 20 Jun 2013 15:48:25 GMT https://community.qlik.com/t5/QlikView/Time-Format/m-p/494016#M184809 vivek_niti 2013-06-20T15:48:25Z