Forum Discussion
calculate 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 ins per day for the same team member
Can someone help me?
Kind regards,
Alessandra
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.
5 Replies
Hi alevandenes ,
Can you please post your sample data as a text that anyone can copy paste as a table in Exel and not an image? Also to confirm, the duration is ids 5-4, 6-5 etc ?
id entryType timeStamp teamMember 4 Start 2023-10-16 13:19:45.628 12382 5 Stop 2023-10-16 13:21:10.793 12382 6 Start 2023-10-16 13:21:40.157 12382 7 Stop 2023-10-16 13:21:44.88 12382 8 Start 2023-10-16 13:22:28.313 16230 9 Stop 2023-10-16 13:23:24.242 16230 10 Start 2023-10-16 13:24:27.739 12073 11 Start 2023-10-16 13:26:05.893 16230 12 Stop 2023-10-16 13:26:23.473 12073 13 Start 2023-10-16 13:28:49.522 12382 14 Stop 2023-10-16 13:29:36.053 12382 15 Start 2023-10-16 13:29:48.392 12382 16 Start 2023-10-16 13:30:00.596 12382 17 Stop 2023-10-16 13:30:12.309 12382 18 Start 2023-10-16 13:30:16.384 12382 19 Stop 2023-10-16 13:30:57.837 12382 20 Start 2023-10-16 13:31:17.914 12382 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.
duration for example between 4 and 5, 6 and 7. but also 10 and 12
