Forum Discussion
alevandenes
Helper IV
Helper IVcalculate duration
Hi community, i would like to calculate the duration of each clock in-clock out, considering that: - Start and Stop rows will not follow each other most of the time - there might be more clock ...
Hi alevandenes ,
Assuming the id column corresponds to the order of timestamps, you first need to calculate the start of each stop time where teamMember is equal to the current row teamMember and [id] is < the current row [id] and deduct that from stop. You can then sum the result of a calculated column and show it in a visual.
Pleasae see attached pbix for details.
alevandenesHelper IV
Helper IVduration for example between 4 and 5, 6 and 7. but also 10 and 12