Produce WIFI stats on an excel spreadsheet from .txt file

We have log files from a WIFI system which output in .txt file- see attached sample We want to do the following: 1. Method to take .txt file and compile the below in excel 2. Count the number of times “GET /[login to view URL]” is displayed each day and display in a table for each day of the month- this is the number of unique users who accessed the WIFI 3. Count the number of times “GET /[login to view URL]” is displayed each hour and display in a table for each hour of the day (total this over the month)- this is the number of unique users per hour to show the busiest hours 4. Take each “GET/************.html” listing and count the numbers each page was accessed and display in a table 5. When a mac address (78:ca:39:86:9e:69) is first seen, take its time and when last seen, take its time, then subtract the two to display the minutes and seconds. Count each of these and put into a table for 0-30secs, 31-60secs,61-120secs,121-240secs,241secs+- this will show the length of time people were on the site 6. There will be further modifications in the future