Calculating time between check in and check out in one day

[PowerVisualBI]

Hi all.
I have a problem, how to calculate check in and check out times that are done multiple times in one day?
I just need an early checkin and late checkout time of the day.
So it applies if he checks in before 08:00 AM, then he is on time, and if he checks out after 05:00 PM, then he is on time too every user

[Dhacd]

Hi, Sorry for the late reply,
Try the file attached in the below link.

link 

[Dhacd · Accepted solution]

Hi @PowerVisualBI ,

Try the below dax to create a new table,

CALCULATETABLE (
    SUMMARIZE (
        TableName,
        'TableName'[Tgl]
        "In",Min('TableName'[In]),
        "Out",Max('TableName'[Out]),

    )
)

  And use the below dax as a calculated column

If(and([in]<=Time(08,00,00),out>=time(17,00,00)),"On Time", "Not On time")

If there is any issue please copy and paste a sample table from excel. And mention the issue so that I can Create a file that I can share with you.

Thanks and regards, 
Atma.

[PowerVisualBI]

Thank you @Dhacd 
I've found a way based on your solution.

[PowerVisualBI]

Hello @Dhacd 
What about the user? because if I use the DAX formula above, I can only see the earliest check-in and the last checkout. I want to see it by user. Because users can check in and check out many times a day. But I just want to count this check, he's the earliest and his checkout is the last

[PowerVisualBI]

Hi @Dhacd 
I've tried the DAX you provided, but I haven't found a solution yet. You can check my file below
https://drive.google.com/drive/folders/1plQwa5E0C2k7n21-cZUO2EoUnONRMXpd?usp=sharing