If then request

[bpc]

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

 

[Pete_UK]

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