topic Re: Ignore time formatting when loading file in QlikView https://community.qlik.com/t5/QlikView/Ignore-time-formatting-when-loading-file/m-p/454857#M696758 <HTML><HEAD></HEAD><BODY><P>change in your script. </P><P>time(time#(Servicing,'mm:ss'),'hh:mm:ss') as Servicing</P><P></P><P>Hope that helps you.</P></BODY></HTML> Tue, 19 Mar 2013 10:42:05 GMT fdelacal 2013-03-19T10:42:05Z Ignore time formatting when loading file https://community.qlik.com/t5/QlikView/Ignore-time-formatting-when-loading-file/m-p/454856#M696757 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I'm trying to load an excel file that has a column of rows that is wrongly formatted as hh:mm:ss but the actual format should be mm:ss.</P><P></P><P>So, for example i have a field that shows 07:22:00 but it should be 00:07:22.</P><P>When I try to load this file into QlikView I can't make it ignore this format.</P><P></P><P>If you open the csv-file in excel it will at first glance look like its correctly formatted but when you look in the expression field you will see the problem.</P><P></P><P>This is in reality a very large file that will be loaded daily so I really can't chenge anything in the csv-file, it has to be done in QV.</P><P></P><P>Will really appreciate any help with this.</P></BODY></HTML> Tue, 19 Mar 2013 10:35:57 GMT https://community.qlik.com/t5/QlikView/Ignore-time-formatting-when-loading-file/m-p/454856#M696757 2013-03-19T10:35:57Z Re: Ignore time formatting when loading file https://community.qlik.com/t5/QlikView/Ignore-time-formatting-when-loading-file/m-p/454857#M696758 <HTML><HEAD></HEAD><BODY><P>change in your script. </P><P>time(time#(Servicing,'mm:ss'),'hh:mm:ss') as Servicing</P><P></P><P>Hope that helps you.</P></BODY></HTML> Tue, 19 Mar 2013 10:42:05 GMT https://community.qlik.com/t5/QlikView/Ignore-time-formatting-when-loading-file/m-p/454857#M696758 fdelacal 2013-03-19T10:42:05Z Re: Ignore time formatting when loading file https://community.qlik.com/t5/QlikView/Ignore-time-formatting-when-loading-file/m-p/454858#M696759 <HTML><HEAD></HEAD><BODY><P>Thank you so much for your help, it works great!!!</P></BODY></HTML> Tue, 19 Mar 2013 10:57:57 GMT https://community.qlik.com/t5/QlikView/Ignore-time-formatting-when-loading-file/m-p/454858#M696759 2013-03-19T10:57:57Z