Order data

[Antonio74]

Hello, I have this situation. My point control clock gives me 1 line for each movement. As you can see in the file in green, the operator 1552 it's in at 08:06:00 and gets out at 16:09:00.  In this case he works 08:03:00   
how can I get thease values in the same line ( time in and time out ) in Power query ?

 

[wdx223_Daniel]

if all the ENTRADA and SAIDA come in pairs in the column of DIRECTION, then try this code:

NewStep=let a={"ENTRADA","SAIDA"} in Table.Combine(Table.Group(PreviousStepName,{"COLABORADOR","DATA REGISTO"},{"n",each #table({"COLABORADOR","Date","TotalTime"}&List.TransformMany({1..Table.RowCount(_)/2},each a,(x,y)=>Text.From(x)&"# "&y),{{[COLABORADOR]{0},[DATA REGISTO]{0},List.Sum(List.Transform(List.Split([HORA PICAGEM],2),each _{1}-_{0}))}&[HORA PICAGEM]})})[n])

[Antonio74]

 Good morning, first of all thanks for the help. when applying this step I get the error "Expression.Error: The number is out of range of a 32-bit integer value.
Details: 0.5"
I suppose it's because someone forgot some record

[wdx223_Daniel]

you may get a odd number of rows