XLS time format - messed up in QlikView

[#1]

Have 5 columns in an XLS. First column is time in format 1:30 PM. Second Column is Network.

Issue:

Time in QV is messed up.

Second Column get the AM/PM

Please see the attachments if I could explain better.

Appreciate help.

thanks

Rajesh

[Clever_Anjos · Accepted solution]

Check if this fix your issue

LOAD time(Time) as Time,

     text(Network) as Network,

     Server,

     Browser,

     Total

FROM

(ooxml, embedded labels);

[#3]

Thanks. It worked.

[its_anandrjs]

Try with this load scripts

LOAD

     Time(Time) as Time,

     Network as Network,

     Server,

     Browser,

     Total

FROM

SNOW_0709.xlsx

(ooxml, embedded labels, table is Sheet2);

I use your data from second sheet by copy and paste the data from sheet one and then use it from sheet 2 may be some formatting problem.

Hope this helps