Dear All,

Please refer to the attachment.


For green cells, is it possible to use formula to determine if each of the Time cells (F2:AH2) is within the Section range specified (E3:E5) from the Section Table. Thanks All.

Regards.

Attached Files

Sample.xlsx (9.6 KB, 13 views)

I've always found the easiest way to work with times is to..... well, work with times.
If the times you have were real times rather than text, you could put this in F3 and drag across and down.

=IFERROR(IF(AND(F$2>=VLOOKUP($E3,$A$3:$C$7,2,FALSE ),F$2<=VLOOKUP($E3,$A$3:$C$7,3,FALSE)),"Yes","")," ")

see attached file.

Attached Files

Sample_with_real_times.xlsx (10.8 KB, 12 views)