Ignore time formatting when loading file

[#1]

Hi!

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.

So, for example i have a field that shows 07:22:00 but it should be 00:07:22.

When I try to load this file into QlikView I can't make it ignore this format.

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.

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.

Will really appreciate any help with this.

[fdelacal · Accepted solution]

change in your script.

time(time#(Servicing,'mm:ss'),'hh:mm:ss') as Servicing

Hope that helps you.

[#3]

Thank you so much for your help, it works great!!!