Simple scenario: We have three computers in an office. Employees come in and out all day, using them. We want to know if we can reduce the office to two computers, by finding out if three people are using computers at the same time.
I have 3 columns: A is the name of the PC, B is date/time that a user starts a session, C is session end time.
I'm trying to figure out an equation that'll tell me how much overlap I have for these sessions. I've Googled around a bit, but haven't found something that fits this scenario.