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 as time out. could you help me with how to do this?

 

 

the result should be like this:-

 

user,  time in,   time out

22203  8:27,  5:47

222304  8:30, 5:40

 

pls help me to solve this issue.

 

Need Help

2 Replies

  • 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.