topic Re: Loading Data From Excel in QlikView https://community.qlik.com/t5/QlikView/Loading-Data-From-Excel/m-p/733254#M1073441 <HTML><HEAD></HEAD><BODY><P>Thank you so much.</P></BODY></HTML> Thu, 07 Aug 2014 14:22:47 GMT 2014-08-07T14:22:47Z Loading Data From Excel https://community.qlik.com/t5/QlikView/Loading-Data-From-Excel/m-p/733251#M1073438 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp; I am new to Qlikview. I am loading data from Excel. Time field 'Estimated Start time' in Excel is in 'hh:mm TT' format&nbsp; e.g '<STRONG>6.00 AM</STRONG>'. But&nbsp; in qlikview after loading , Time field 'Estimated Start time' is coming like '<STRONG>6.00 a</STRONG>' inside of '<STRONG>6.00 AM</STRONG>'. So I use timestamp function.</P><P><STRONG>Timestamp(Timestamp#([Estimated Start time (EST)],'hh:mm:ss TT'),'h:mm:ss TT') as Estimated_Start_time </STRONG></P><P>&nbsp;&nbsp; But after this I am not getting any data in <STRONG>Estimated_Start_time </STRONG>listbox.&nbsp; Please suggest something.</P></BODY></HTML> Thu, 07 Aug 2014 13:34:53 GMT https://community.qlik.com/t5/QlikView/Loading-Data-From-Excel/m-p/733251#M1073438 2014-08-07T13:34:53Z Re: Loading Data From Excel https://community.qlik.com/t5/QlikView/Loading-Data-From-Excel/m-p/733252#M1073439 <HTML><HEAD></HEAD><BODY><P>Please try this: </P><P>date(<STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">[Estimated Start time (EST)]</STRONG>, 'h:mm:ss TT')</P><P></P><P>Kind regards</P></BODY></HTML> Thu, 07 Aug 2014 13:38:32 GMT https://community.qlik.com/t5/QlikView/Loading-Data-From-Excel/m-p/733252#M1073439 2014-08-07T13:38:32Z Re: Loading Data From Excel https://community.qlik.com/t5/QlikView/Loading-Data-From-Excel/m-p/733253#M1073440 <HTML><HEAD></HEAD><BODY><P>try with<STRONG style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P><P><STRONG style="font-size: 12.727272033691406px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Timestamp#([Estimated Start time (EST)],'hh:mm TT')</STRONG></P></BODY></HTML> Thu, 07 Aug 2014 13:44:37 GMT https://community.qlik.com/t5/QlikView/Loading-Data-From-Excel/m-p/733253#M1073440 maxgro 2014-08-07T13:44:37Z Re: Loading Data From Excel https://community.qlik.com/t5/QlikView/Loading-Data-From-Excel/m-p/733254#M1073441 <HTML><HEAD></HEAD><BODY><P>Thank you so much.</P></BODY></HTML> Thu, 07 Aug 2014 14:22:47 GMT https://community.qlik.com/t5/QlikView/Loading-Data-From-Excel/m-p/733254#M1073441 2014-08-07T14:22:47Z