Need A Start to Excel Programming Code

[kpschroeder]

I have logon and logoff scripts I run on users where the results are
sent to a text file which looks like this:


User MKEARCLAP02\Processor logged on computer MKEARCLAP02 8/11/2006
1:51:57 PM
User MKEARCLAP02\Processor logged off computer MKEARCLAP02 8/11/2006
1:53:28 PM
User MKEARCGX150\Processor logged on computer MKEARCGX150 8/11/2006
1:53:30 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
1:56:07 PM
User MKEARCLAP02\Processor logged on computer MKEARCLAP02 8/11/2006
1:56:07 PM
User MKEARCLAP02\Processor logged off computer MKEARCLAP02 8/11/2006
1:59:07 PM
User MKEARCGX150\Processor logged on computer MKEARCGX150 8/11/2006
1:59:09 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
2:17:58 PM
User MKEARCGX150\Processor logged on computer MKEARCGX150 8/11/2006
2:21:21 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
2:21:34 PM
User MKEARCLAP02\Processor logged on computer MKEARCLAP02 8/11/2006
2:21:58 PM
User MKEARCLAP02\Processor logged off computer MKEARCLAP02 8/11/2006
2:22:35 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
2:24:21 PM
User MKEARCGX150\Processor logged on computer MKEARCGX150 8/11/2006
2:24:44 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
2:24:55 PM
User MKEARCLAP02\Processor logged off computer MKEARCLAP02 8/11/2006
2:27:02 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
2:28:29 PM

From here I import these results into excel which looks like this:

MKEARCLAP02\Processor on MKEARCLAP02 8/11/2006
13:51:57
MKEARCLAP02\Processor off MKEARCLAP02 8/11/2006
13:53:28
MKEARCGX150\Processor on MKEARCGX150 8/11/2006
13:53:30
MKEARCGX150\Processor off MKEARCGX150 8/11/2006
13:56:07
MKEARCLAP02\Processor on MKEARCLAP02 8/11/2006
13:56:07
MKEARCLAP02\Processor off MKEARCLAP02 8/11/2006
13:59:07
MKEARCGX150\Processor on MKEARCGX150 8/11/2006
13:59:09
MKEARCGX150\Processor off MKEARCGX150 8/11/2006
14:17:58
MKEARCGX150\Processor on MKEARCGX150 8/11/2006
14:21:21
MKEARCGX150\Processor off MKEARCGX150 8/11/2006
14:21:34
MKEARCLAP02\Processor on MKEARCLAP02 8/11/2006
14:21:58
MKEARCLAP02\Processor off MKEARCLAP02 8/11/2006
14:22:35
MKEARCGX150\Processor off MKEARCGX150 8/11/2006
14:24:21
MKEARCGX150\Processor on MKEARCGX150 8/11/2006
14:24:44
MKEARCGX150\Processor off MKEARCGX150 8/11/2006
14:24:55
MKEARCLAP02\Processor off MKEARCLAP02 8/11/2006
14:27:02
MKEARCGX150\Processor off MKEARCGX150 8/11/2006
14:28:29


I would like to take my macro a step further and calculate the total
time a user was logged in and the total time the user was logged out.

What functions am I looking at here? I'm not sure where to begin. Is
this possible?



I would like to take my macro a step further and calculate the total
time a user was logged in and the total time the user was logged out.

What functions am I looking at here? I'm not sure where to begin.

 

[Bob Phillips]

I would change the output text file to have separate columns for

User
Computer
Logged on
Logged off

Then you could just open that in Excel and use worksheet formulae, or a
pivot table, to analyse it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)