Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hiiiii
see the attached file
hope it helps
PFA t may help you.
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;