Need to know how many users are logged in...

  • Thread starter Thread starter Nicholas
  • Start date Start date
N

Nicholas

I have an excel sheet, with a list of users, login and logout date & time.
I need to know how many users were logged in over the course of time every
30 minutes.

Excel 2007.

Thanks
 
This is a set of data from a table that tells me login/logout times for a
user on a server.

So what I need to do is parse/calculate the data to determine at every 30
minutes how many users are currently logged in.
 
Without seeing your data it is hard to get specific. The general theory
behind this is to create a table of times which is in 30 minute increments
(12:00, 12:30, 1:00, ...)
placing those time in rows is probably the easiest. Now you need to count up
how many peolple logged in prior to that time and how many people logged out.
(logged in by the end of that time period and logged out prior to the
beginning). The difference should be that active users. As a guess sumproduct
formulas will be the best way to get the individual counts...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
 
Back
Top