topic string to time(hh:mm) in QlikView https://community.qlik.com/t5/QlikView/string-to-time-hh-mm/m-p/399883#M148804 <HTML><HEAD></HEAD><BODY><P>Hi-I have a string field which looks like <SPAN style="color: #0000ff;">20120927-00:00:01.<SPAN style="color: #000000;">Can you please let me know how can I extract only HH:MM.Thanks-Pooja</SPAN></SPAN></P></BODY></HTML> Wed, 10 Oct 2012 14:18:09 GMT 2012-10-10T14:18:09Z string to time(hh:mm) https://community.qlik.com/t5/QlikView/string-to-time-hh-mm/m-p/399883#M148804 <HTML><HEAD></HEAD><BODY><P>Hi-I have a string field which looks like <SPAN style="color: #0000ff;">20120927-00:00:01.<SPAN style="color: #000000;">Can you please let me know how can I extract only HH:MM.Thanks-Pooja</SPAN></SPAN></P></BODY></HTML> Wed, 10 Oct 2012 14:18:09 GMT https://community.qlik.com/t5/QlikView/string-to-time-hh-mm/m-p/399883#M148804 2012-10-10T14:18:09Z Re: string to time(hh:mm) https://community.qlik.com/t5/QlikView/string-to-time-hh-mm/m-p/399884#M148805 <HTML><HEAD></HEAD><BODY><P>I think this should work: time(time#('<SPAN style="color: #0000ff;">20120927-00:00:01</SPAN>','yyyyMMdd-hh:mm:ss'),'hh:mm')</P></BODY></HTML> Wed, 10 Oct 2012 14:20:43 GMT https://community.qlik.com/t5/QlikView/string-to-time-hh-mm/m-p/399884#M148805 Gysbert_Wassenaar 2012-10-10T14:20:43Z Re: string to time(hh:mm) https://community.qlik.com/t5/QlikView/string-to-time-hh-mm/m-p/399885#M148806 <HTML><HEAD></HEAD><BODY><P>Thanks a lot for your quick response.</P></BODY></HTML> Wed, 10 Oct 2012 14:52:31 GMT https://community.qlik.com/t5/QlikView/string-to-time-hh-mm/m-p/399885#M148806 2012-10-10T14:52:31Z