Evaluate if an activity is happening during a given time interval

[SecretProject5]

Hello community, i have start and end times for events throughout a given day. I can calculate the length in time for each event and the amount of events, but I'm trying to evaluate if there was an active event in specific 5 minutes intervals.

For example:

2 events, the first one starts at 6:23pm and ends at 6:38pm, next event starts at 6:47pm and ends at 6:54. When evaluating the 5 minute intervals with this information, i'd like to get something like this:

6:20pm NO
6:25pm YES
6:30pm YES
6:35pm YES
6:40pm NO
6:45pm NO
6:50pm YES
6:55pm NO

I figured one way could be using an IF AND with "greater than or equal to" and "less than or equal to", but i was wondering if anyone had another idea. Thanks

[SecretProject5]

Found a useful suggestion in the excel subreddit "/r/excel/comments/q710ot/evaluate_if_an_activity_is_happening_during_a/"

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Administrative Note:

Welcome to the forum.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.