Trying to make sense of what you are doing here. Let's start with Column C.
You have =IF(AND(AND(A2 > Events!B2, A2 < Events!C2),Events!A2=O2), B2,0)
which is comparing the value in A2 only to the first entry in the Events tab. Wouldn't you want to compare it to all the data in Events to see if it falls anywhere in any event?
If so, your formula (assuming that if it does, you want to return "Usage") should be
I'm not not sure what you want in Column D or how you would want it calculated.
So if the time in A2, falls within an event, do you then want to subtract this time from the end time of an event (or a max of 15 minutes)
What if the time in A2 doesn't fall within an event but somewhere in the next 15 minutes does? Do you want that overlap captured?
Bookmarks