Total Break Time for Employees

[Anonymous]

Hi Team,

I have a dataset containing the biometric time of each employees:

I need to calculate the total break time for each employees. There are multiple entry and exit time for each employee for a day.
Break time should be calculated as : (each Log out time - Immediate next log in time),

Please help.

Thanks
Amit

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

Try this column:

Break time = 
var _f = TOPN(1,FILTER('Table',[Date & Time]>EARLIER('Table'[Date & Time])&&[User ID]=EARLIER('Table'[User ID])),[Date & Time],ASC)
VAR _S = MAXX(_f,[Date & Time])
VAR _D = IF(ISBLANK(_S),0,DATEDIFF([Date & Time],_S,MINUTE))
RETURN
IF([Event Type]="LOGIN",0,_D)

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks a lot, It works 🙂

[Shreeram04]

Hi @Anonymous 

Please find the below link for your reference.

https://youtu.be/KTgrgdvqO4Y

Thanks,

[Anonymous]

Hi Ram,

My dataset is different than the dataset mentioned in the vedio.

I dont have log in and log out time in the same row.