Hello. I have 6 times ranges. I have durations of videos, and im trying to assign range ID's to them. Basically, i dont know if i should use IF, or countIFs and vlookup. Example, if you look at the workbook and look at E2, it would fall under range ID 5. Any help is appreciated.
https://postimg.cc/TLKQtPXy
https://postimg.cc/TLKQtPXy