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