I have to compile a Cisco report monthly and the format is crazy. I looks like this:
12/27/2009 15:59 12/27/2009 16:24 00:24:2b:24:e6:80 Marion_branch 25 min 21 sec 192.168.254.124
12/27/2009 22:08 12/27/2009 22:14 00:23:4d:43:19:1e Marion_branch 5 min 44 sec 10.10.9.196
12/27/2009 22:14 12/27/2009 22:43 00:23:4d:43:19:1e Marion_branch 28 min 48 sec 10.10.9.196
The goal is to calculate the amount of time the wireless access was used on this day without having to add the minutes and seconds manually. Each entry is in a seperate column. A is the connect time, B is the disconnect time, C is the mac address of the laptop, C is the branch name, D is the amount of time the person was connected, and E is the ip address. If there is a way to calcuate the total time per mac address or per branch, it would help so much. Can anyone help me?
Thanks.
Bookmarks