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