I have a history list which refers to any request that has been made on a certain website.
All request timestamps are in column A.
The value in column B is the user who made that request.
My goal is :
- for each user, get the connection duration by day, week or month
We consider that if there is 2 (or more) consecutive requests in less than 10 minutes, we can add the time difference as "connection time".
2011-07-04 10:16:20 326
2011-07-04 10:17:17 326
=> connection time = 0:57mn
Thank you for your suggestions !