topic Re: Convert hh:mm:ss into mm:ss in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Convert-hh-mm-ss-into-mm-ss/m-p/793979#M2310 <HTML><HEAD></HEAD><BODY><P>What is the format of the opened time field</P><P></P><P>You can try with</P><P></P><P>Time( [opened time],'hh:mm')</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Sun, 28 Dec 2014 11:41:41 GMT its_anandrjs 2014-12-28T11:41:41Z Convert hh:mm:ss into mm:ss https://community.qlik.com/t5/Qlik-Learning-Discussions/Convert-hh-mm-ss-into-mm-ss/m-p/793977#M2308 <HTML><HEAD></HEAD><BODY><P>hi all ,</P><P>I&nbsp; have a field like "opened time" -&gt; it's showing like this&nbsp; "'1.22:43:8.000'' s but my requirement need to display into MM:SS format can anyone help me soon</P></BODY></HTML> Sun, 28 Dec 2014 10:16:35 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Convert-hh-mm-ss-into-mm-ss/m-p/793977#M2308 divianjani 2014-12-28T10:16:35Z Re: Convert hh:mm:ss into mm:ss https://community.qlik.com/t5/Qlik-Learning-Discussions/Convert-hh-mm-ss-into-mm-ss/m-p/793978#M2309 <HTML><HEAD></HEAD><BODY><P>Use the time() function: Time([opened time],'hh:mm:ss')</P></BODY></HTML> Sun, 28 Dec 2014 10:43:16 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Convert-hh-mm-ss-into-mm-ss/m-p/793978#M2309 Gysbert_Wassenaar 2014-12-28T10:43:16Z Re: Convert hh:mm:ss into mm:ss https://community.qlik.com/t5/Qlik-Learning-Discussions/Convert-hh-mm-ss-into-mm-ss/m-p/793979#M2310 <HTML><HEAD></HEAD><BODY><P>What is the format of the opened time field</P><P></P><P>You can try with</P><P></P><P>Time( [opened time],'hh:mm')</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Sun, 28 Dec 2014 11:41:41 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Convert-hh-mm-ss-into-mm-ss/m-p/793979#M2310 its_anandrjs 2014-12-28T11:41:41Z