Forum Discussion

RAKESH1986's avatar
RAKESH1986
Icon for Helper II rankHelper II
3 years ago

Timein and Time out from attendance record

Hi All,   Please help me solve this issue, I have attendance card swipe records and need to show time in and time out in separate columns.   first swipe considers as time in and the last swipe is a...
Need Help
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

=Table.Group(PreviousStepName,{"User","Date"},{{"TimeIn",each [TimeInOut]{0}},{"TimeOut",each [TimeInOut]{1}?}})

RAKESH1986's avatar
RAKESH1986
Icon for Helper II rankHelper II
3 years ago

wdx223_Daniel  thanks for the response. the code you send it working but the output is not correct. pls have a look at the below output. 

all in time value is in PM and few values of out time is in AM 

 

THIS IS MY ORIGIONAL DATA, but new code is giving wrong output.

 

 

pls help me to solve this.