I am trying to populate a series of calendar/time cells which show whether a test activity was being performed based a countifs formula.
In columns c and d I have the start date/time and end date/time of each test activity.
In columns h and I have a the start and end dates/times (in one minute increments) that I want to determine if there was test activity in.
In column j I have a formula
that I intend will go compare each of the test events for to see if they happened on or after the calendar date/time in column h and on or before the date/time in column I. The intent is to populate column j with true values when there was test activity during that 1 minute increment for all of the dates/times listed in columns h and I.
This is probably simple and I'm overlooking something.
Thanks for your help.