Hello, I need some help on getting time intervals between activities and summing up the total time taken to accomplish all the activities.
S I have table in the format below:
UserName | Activity | Timestamp | Duration( Either Hours or Minutes) |
---|
A | Activity1 | T1 | |
B | Activity2 | T2 | |
D | Activity1 | T3 | |
A | Actvity3 | T4 | T4-T1 |
B | Activity3 | T5 | |
A | Activity4 | T6 | T6-T4 |
I would like to get the time interval between activities per user, which can be plotted on graph, and then also get the sum of the total time taken for all the activities.
There is only start time. So the start of an activity marks end of the previous. execpt the first activity that has no predecessor. The start of the first activity marks the start of it all. T1->T4->T6
Thank you.