topic Anyone knowns what function to change a time? in QlikView https://community.qlik.com/t5/QlikView/Anyone-knowns-what-function-to-change-a-time/m-p/224493#M76894 <HTML><HEAD></HEAD><BODY><P>I have a data with 9:00 AM and 9:00 PM, and i need instead of 9:00 PM, 21:00.</P><P></P><P>Anyone knowns what function i need to solve this??</P><P></P><P>Tks a lot!!!</P></BODY></HTML> Thu, 30 Sep 2010 19:05:05 GMT 2010-09-30T19:05:05Z Anyone knowns what function to change a time? https://community.qlik.com/t5/QlikView/Anyone-knowns-what-function-to-change-a-time/m-p/224493#M76894 <HTML><HEAD></HEAD><BODY><P>I have a data with 9:00 AM and 9:00 PM, and i need instead of 9:00 PM, 21:00.</P><P></P><P>Anyone knowns what function i need to solve this??</P><P></P><P>Tks a lot!!!</P></BODY></HTML> Thu, 30 Sep 2010 19:05:05 GMT https://community.qlik.com/t5/QlikView/Anyone-knowns-what-function-to-change-a-time/m-p/224493#M76894 2010-09-30T19:05:05Z Anyone knowns what function to change a time? https://community.qlik.com/t5/QlikView/Anyone-knowns-what-function-to-change-a-time/m-p/224494#M76895 <HTML><HEAD></HEAD><BODY><P>If the time 9:00 AM is text, it would be time(time#(Field, 'h:mm tt'),'H:mm') and 9:00 AM is already considered time in QlikView it would be time(Field,'H:mm').</P><P>Regards.</P></BODY></HTML> Thu, 30 Sep 2010 19:10:30 GMT https://community.qlik.com/t5/QlikView/Anyone-knowns-what-function-to-change-a-time/m-p/224494#M76895 pover 2010-09-30T19:10:30Z