calculate duration

[alevandenes]

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

[alevandenes]

duration for example between 4 and 5, 6 and 7. but also 10 and 12

[danextian]

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 ?

[alevandenes]

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

[danextian · Accepted solution]

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.

[alevandenes]

amazing! thanks a lot!