Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to know how many users are logged in...
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to know how many users are logged in...
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to know how many users are logged in...
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to know how many users are 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 -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Logged in User Name in formula... | Excel Discussion (Misc queries) | |||
Getting Logged in User Name in formula... | Excel Worksheet Functions | |||
Auto Updating the Logged in User | Excel Discussion (Misc queries) | |||
Sharing Problems- users keep reappearing even though logged out. | Excel Discussion (Misc queries) | |||
How do you reference the logged on user name in excel? | Excel Discussion (Misc queries) |