If then request
 

Start times in column A and finish times in column B (formatted as text not
time, although I could change that.) Column C consists of one hour time
periods for all 24 hours of the day. In column D, E, F... I am looking for a
function (probably if/then) to place an X if the time range of A through B
includes the corresponding one hour time periods of column C.


ColumnA Column B Column C Column D Column E Column F
Start Time FinishTime Labels Case#1 Case #2 Case #3
#1. 1234 126 1200 €“ 100 X
#2. 147 312 100 €“ 200 X X
#3. 256 527 200 €“ 300 X
X
300 €“ 400 X
X
400 €“ 500 X
ETC

If then request
 

In your example, does 1200 - 100 mean from midday to 1:00 pm? If so,
shouldn't it be 1200 - 1300 ?

Are your finish times (126, 312 etc) in the morning or afternoon? Are
you using a 24-hour clock notation?

Pete

On Sep 22, 5:01*pm, bpc wrote:
Start times in column A and finish times in column B (formatted as text not
time, although I could change that.) Column C consists of one hour time
periods for all 24 hours of the day. *In column D, E, F... I am looking for a
function (probably if/then) to place an X if the time range of A through B
includes the corresponding one hour time periods of column C.

ColumnA * * *Column B * *Column C * Column D *Column E *Column F * * * * * * * *
Start Time * *FinishTime * *Labels * * * Case#1 * * *Case #2 * * Case #3
#1. 1234 * * * * * * 126 * * * * * * *1200 – 100 * * *X
#2. 147 * * * * * * * 312 * * * 100 – 200 * * * X * * * * * * *X
#3. 256 * * * * * * * 527 * * * *200 – 300 * * * * * * * * * * *X * * * * * *
* *X
* * * * * * * * * * * * * * * * * * * *300 – 400 * * * * * * * * * * * X * * * * *
* * * * *X
* * * * * * * * * * * *400 – 500 * * * * * * * * * * * * * * * * * * * *X
* * * * * * * * * * * * * * * * * * * * * *ETC