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
