topic Re: time format in formule in QlikView

time format in formule

Anonymous — Mon, 04 Feb 2013 06:23:49 GMT

hi,

i had 2 feild that show time - in & out

i want to know how i need to write in expresion the formule (out - in ) .

the answer need to be at the same format ( time format ).

thanks'

yarin.

er_mohit — Mon, 04 Feb 2013 06:30:06 GMT

hiiiii

see the attached file

hope it helps

sreenivas — Mon, 04 Feb 2013 06:33:00 GMT

PFA t may help you.

Mon, 04 Feb 2013 07:14:02 GMT

try this

LOAD name,

time_in,

time_out

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD

name,

Min(Time(time_in,'hh:mm:ss')) as TIMEIN,

max(Time(time_out,'hh:mm:ss')) as TIMEOUT

Resident a

Group By name;