SecretProject5
New Member
- Joined
- Oct 12, 2021
- Messages
- 4
- Office Version
- 2019
- Platform
- Windows
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
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