I have coded and worked with Excel for years now, but I have never used pivot tables.
Log Name Date Time
Logon, mmcguinness, 01/07/2011, 9:04:29
Logoff, mmcguinness, 01/07/2011, 10:46:52
Logon, mmcguinness, 01/07/2011, 11:02:01.64
Logoff, mmcguinness, 01/07/2011, 11:19:01.36
I have the above information in a log file from a server log. I need to summarize the information by:
- subtracting the logon time from the logoff time for each user
- then total those time differences per day
- total the time per month
I was wondering if pivot tables would provide an easy way of doing this as opposed to attacking the problem programitcally.
Thanks,
Michael
Bookmarks