I'm working on a sheet that uses vlookup to check the current time against students' schedules. My issue is that I have to split the now function to show just the hour and minute, and when I use vlookup with that as the reference against the schedule, the formatting seems to not work right. Even if I set them to the same formatting. It returns N/A saying that value couldn't be found, even when that exact value is in the list. Any thoughts on how to work around this, or even just an easier way to make the sheet in general?
Note: The formula works if I just type in a time, it's only when I use the now function that I have issues.