Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need A Start to Excel Programming Code
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need A Start to Excel Programming Code
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) wrote in message oups.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get excel to start a numberwith a zero as in a zip code? | Excel Discussion (Misc queries) | |||
Need A Start to Excel Programming Code | Excel Programming | |||
How to start a VB6 program form Excel VBA macro code ? | Excel Programming | |||
EXCEL Jump Start CORE Workbook w/Code | Excel Programming | |||
Where to start programming??? | Excel Programming |