Time Spent on a Page in a Session

[bigfun]

Alright, so I am trying to calculate the average time spent on each page, and the only way I could think of doing it would be by way of looking at each session and calc the time difference between rows.

URL is the Column that identifies best which page the user is spending time on.

My Datatable has the following columns:

Here is a sample of the data

I'm just not clear how I go about managing the calculation when I have the start time and end time within the same column

[tamerj1]

Hi @bigfun 
This is  sample of the data filtered for one userID and sourted by URL. Can you please advise which advise how to decide which one is the start time and which one is the end time for each URL and what is the criteria?

[bigfun]

Hey thank you for taking a look at it.... I was chatting with my data folks Friday about this exact thing (found that sessions weren't as unique as I thought they were).. I am going to concat the sessionID and InstanceID.. That should break down the sessions in the correct manner.

I want to grab the earliest time per UnqSession calc the time spent per page, till the last page in the session.

A session that is over 3600 seconds we will call an abandoned sesson.

I updated the sheet with the new column