Problem with hour calculation

Hi JARONN 

If i understand you correctly, 

first add a index column in Edit queries,

then create calculated columns in Data model view,

out =
CALCULATE (
    LASTNONBLANK ( Sheet1[Code], 0 ),
    FILTER (
        ALLEXCEPT ( Sheet1, Sheet1[person id ] ),
        Sheet1[Index 1]
            = EARLIER ( Sheet1[Index 1] ) + 1
            && Sheet1[Index] > EARLIER ( Sheet1[Index] )
    )
)

condition = IF([out]="out","in",IF([out]="<>out","out"))

in/out cal =
CALCULATE (
    LASTNONBLANK ( Sheet1[condition], 0 ),
    FILTER (
        ALLEXCEPT ( Sheet1, Sheet1[person id ] ),
        Sheet1[Index] <= EARLIER ( Sheet1[Index] )
    )
)