From timestamps to time difference

Hi there,

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.
  history.xls

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".
i.e.:
2011-07-04 10:16:20	326
2011-07-04 10:17:17	326

Open in new window

=> connection time = 0:57mn

Thank you for your suggestions !

Eric
LVL 1
eirikurAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
anjosConnect With a Mentor Commented:
ie you can use this to get a timespan:
public TimeSpan dateTimeDifference(string d1, string d2)
        {
            DateTime startDate, endDate;

            if (DateTime.TryParse(d1, out startDate) && DateTime.TryParse(d2, out endDate))
                if (DateTime.Compare(startDate, endDate) < 0)
                {
                    TimeSpan span = endDate.Subtract(startDate);
                    return span;
                }

            return TimeSpan.Zero;
        }

And this to get a time difference:
public string makeTimeString(TimeSpan t)
        {
            string H = "", M = "";

            if (t.Hours < 10)
                H = "0";
            if (t.Minutes < 10)
                M = "0";

            H += t.Hours.ToString();
            M += t.Minutes.ToString();

            return H + ":" + M;
        }
0
All Courses

From novice to tech pro — start learning today.