=IF($B$3$C$3,IF(AND($B$3<F$3,$C$3F$3),"X",""),IF (OR($C$3F$3,F$3$B$3),"X",""))

Should get it

"bpc" wrote:

I have a start time(22:13) in b3 and an end time(3:06) in c3. All times are
entered in 24:00 format. In column F, I have one hour increment time values
(00:00 in f3, 01:00 in f4, 02:00 in f5, etc. In column G next to the
appropriate hour I would like to place an X if the event occurred during that
time hour. So in the example above (22:13 - 3:06) X's would be placed for
22:00, 23:00, 00:00, 01:00, 02:00, 03:00. Suggestions? The two formulas I
create both work but not 100%. The first formula works when the time range
goes over the midnight hour (22:13 - 06:12)but does not work on time ranges
over a one day period (2:04 - 6:03). The second formula works on same day
ranges but not ranges crossing 24:00.
Help, I need one formula to do both.

=IF(OR(AND($B$3=F3,$B$3<F4),AND($C$3=F3,$C$3<F4) ,OR(F3=$B$3,F3<=$C$3)),"x","")

=IF(OR(AND($B$3=F3,$B$3<F4),AND($C$3=F3,$C$3<F4) ,OR(AND(F3=$B$3,F3<=$C$3))),"x","")