Prev: User form
Next: Moving information from one spreadsheet to another
From: Nicholas on 13 Jan 2010 16:56
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
From: Jim Thomlinson on 13 Jan 2010 17:04
Logged into what? A specific computer... A server... A file... A Workbook.
--
HTH...

Jim Thomlinson


"Nicholas" wrote:

> 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
From: Nicholas on 13 Jan 2010 17:10
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.

"Jim Thomlinson" wrote:

> Logged into what? A specific computer... A server... A file... A Workbook.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Nicholas" wrote:
>
> > 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
From: Jim Thomlinson on 13 Jan 2010 18:52
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
--
HTH...

Jim Thomlinson


"Nicholas" wrote:

> 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.
>
> "Jim Thomlinson" wrote:
>
> > Logged into what? A specific computer... A server... A file... A Workbook.
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "Nicholas" wrote:
> >
> > > 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
 | 
Pages: 1
Prev: User form
Next: Moving information from one spreadsheet to another