topic Formatting Time in QlikView https://community.qlik.com/t5/QlikView/Formatting-Time/m-p/298525#M1199804 <HTML><HEAD></HEAD><BODY><P>Hi, these are the options for your need</P><P></P><UL><LI>Use time(field,'hh:mm:ss TT'), TT means AM or PM</LI><LI>Change the value for the variable TimeFormat = 'hh:mm:ss TT', but this is going to change every time field</LI></UL><BR /><BR /> <P>Hope this will help you</P><P>rgds</P></BODY></HTML> Thu, 06 Jan 2011 18:12:30 GMT hector 2011-01-06T18:12:30Z Formatting Time https://community.qlik.com/t5/QlikView/Formatting-Time/m-p/298524#M1199803 <HTML><HEAD></HEAD><BODY><P>Is there a way to format the hour of the day in a table and/or graph to show 1:00pm, 2:00 pm rather than 13, 14?</P><P>Thank you,</P><P>Karen</P></BODY></HTML> Thu, 06 Jan 2011 18:03:59 GMT https://community.qlik.com/t5/QlikView/Formatting-Time/m-p/298524#M1199803 2011-01-06T18:03:59Z Formatting Time https://community.qlik.com/t5/QlikView/Formatting-Time/m-p/298525#M1199804 <HTML><HEAD></HEAD><BODY><P>Hi, these are the options for your need</P><P></P><UL><LI>Use time(field,'hh:mm:ss TT'), TT means AM or PM</LI><LI>Change the value for the variable TimeFormat = 'hh:mm:ss TT', but this is going to change every time field</LI></UL><BR /><BR /> <P>Hope this will help you</P><P>rgds</P></BODY></HTML> Thu, 06 Jan 2011 18:12:30 GMT https://community.qlik.com/t5/QlikView/Formatting-Time/m-p/298525#M1199804 hector 2011-01-06T18:12:30Z