I would like to build a report that will show how long in hours or minutes a person took to go from STEP 1 to STEP 3. ( sample data in below table).
Effectively, i am trying to understand on how to do a time difference between rows for same set of data (same person in this case).
|P1||Step 1||06/20/18 08:06:39 AM|
|P1||Step 2||06/20/18 09:06:36 AM|
|P1||Step 3||06/20/18 10:06:29 AM|
|P2||Step 1||06/05/18 12:06:34 PM|
|P2||Step 2||06/06/18 05:06:05 AM|
|P2||Step 3||06/06/18 07:06:24 AM|