View My Drafts
Hi - I have a similar problem I hope you can help me with! I have a table of network access data. I have IP addresses and then the date and time of when the device gets on and off the network throughout the day. I want to look at the IP address on a given day, and get the Max sign off time (example Sept 8th 5:15 PM) and subtract the min sign on time (example: Sept 8th 8:03 AM) to understand approximately how long that person was at the office on a given day. I want to plot this daily average over time. Can you help with this one?