Need to dax to calculate Employee work hours

[BhanuPBI]

Hi Team,

Can any one help me to write dax function to find out how many hours he worked in office based on his first checkin and check out as given below screen shot. can any one do some sample pbix for reference and share me please.

[v-yiruan-msft]

Hi @BhanuPBI ,

You can refer the following links to get the duration between two time:

Calculate Minutes Between Two Times in Power BI

How To Get The Duration Between Two Datetime Or Date Fields In Power BI

And as checked your screenshot, we can't identify which one is check-in or check-out time. Could you please provide more details to explain it and final expected result? Thank you.

Best Regards