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 formNext: Moving information from one spreadsheet to another