Is there a way to find certain values between certain times? I would like to put this log all on one sheet, but i cannot figure out how to tell it to look for two certain values between, say 7am to 3pm. My time columns are formatted by Time, h:mm AM/PM. I have the other section of the formula figured out (find the two values) but I just cannot figure out between times. I have used < > but it doesnot seem to work on time values. Right now, the three time shifts I am using are broken up onto three separate pages, but I would like it to be all on one.