x
Solved

# From timestamps to time difference

Posted on 2011-09-26
Medium Priority
258 Views
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
``````
=> connection time = 0:57mn

Thank you for your suggestions !

Eric
0
Question by:eirikur
1 Comment

LVL 3

Accepted Solution

anjos earned 2000 total points
ID: 36599946
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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.