Time Entry hours

Hello,

I had posted a question before and thought it had been resolved, because i thought i could figure out the rest, but after many failed attempts i have to come back to forum.

In my previous post parry2k (He is away for a while that is why i am posting again) had added a Power bi file as solution. I thought that was the solution, but once you make a table and just put "Member ID", "Date" and "time in office in Hours" it does not show the correct numbers.

It will only show the correct numbers if you create a table with "member ID", "date", "in time for this out time " and "time in office in Hours".

I understand why it doesn't work and i think if it was possible to change "In time for Out time" measure into a calculated column it would work, but i dont tihnk that's possible.

Is there a way to show just Member ID, DATE and total hours in a table per day.

FYI  i found this link   , but unfortunetly my data isn't perfect because sometimes people will swipe in and forget to swipe out or vice versa.

Any help would be appreciated (all the files can be found in the old post)

Thanks