time format in formule

[Anonymous]

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]

hiiiii

see the attached file

hope it helps

[sreenivas]

PFA t may help you.

[#4]

hi

try this

a:

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;