I am looking for a little help. I have a list of times (in text format from 0020 to 2330) and I need to lookup to a table and return number 1-14 depending on which time frame it falls into. For example if the time is 0600, return 1, 1030 return 5, etc.
This is the lookup table I created. I am not very familiar with INDEX function, maybe that would work?
A B C
301 615 1
616 720 2
721 820 3
821 1000 4
1001 1200 5
1201 1315 6
1316 1500 7
1501 1645 8
1646 1815 9
1816 2000 10
2001 2116 11
2117 2230 12
2231 2330 13
2331 300 14

Thanks in advance!