hours import Excel

realpixel — Tue, 03 Dec 2013 16:02:19 GMT

Hello,

In excel file, I have a field "HEURE2" with hour at format 23:02:09 (hh:mm:ss)

I try different kind of cell format in Excel, standard, hh:mm:ss, etc.

When this field is loaded in QV, "HEURE2" appears like that

0,959826388888889

I use this script unders to format the hours

LOAD HMIMMAT1,

LOCATIONS,

HMDATE1,

HEURE3,

HEURE2,

if(Hour(time#([HEURE2],'hh:mm:ss'))>= 07,if(Hour(time#([HEURE2],'hh:mm:ss' ) ) <= 18 ,'SHIFT1','SHIFT2'),'SHIFT2') as HEURE1

Someone have an idea?

Re: hours import Excel

hic — Tue, 03 Dec 2013 16:22:35 GMT

Which means that the formatting is lost. Just load HEURE2 like

Hour(HEURE2, 'hh:mm') as HEURE2

And it will work.

HIC