[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

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
0
eirikur
Asked:
eirikur
1 Solution
 
anjosCommented:
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now