Hi all,
I am looking for some help calculating the time difference between 2 dates for values at different intervals throughout my data. Sample of the data is below.
Example: I need to find the time duration between User ABC = License Count 1 and User ABC = License Count -1, time duration between User XYZ = License Count 1 and User XYZ = License Count -1.
As you can see from the User ADE, there can be some number of rows between a license count = 1 and = -1 for the same user.
Any help gladly appreciated, thank you.
| Timestamp (UTC) | File Acquired | License Count | User |
| 18/12/2017 0:01 | Acquired | 1 | ABC |
| 18/12/2017 0:13 | Acquired | 1 | XYZ |
| 18/12/2017 0:20 | Released | -1 | ABC |
| 18/12/2017 0:31 | Acquired | 1 | ADE |
| 18/12/2017 0:31 | Released | -1 | XYZ |
| 18/12/2017 0:37 | Acquired | 1 | FBA |
| 18/12/2017 0:38 | Released | -1 | FBA |
| 18/12/2017 0:41 | Released | -1 | NRA |
| 18/12/2017 0:41 | Acquired | 1 | NRA |
| 18/12/2017 0:52 | Released | -1 | ADE |
