Try removing the AM in your formula.



Regards
Jean-Guy

"Joker" wrote:

I am having trouble figuring out how to count the number of cells that fall
within a certain timeframe. In column B48:B350, I have time values. Let's say
that B48:B68 fall between 3:00 AM and 4:00 AM. What formula could I use to
find the answer of 20? The formula I tried,
=SUMPRODUCT(--(B48:B350=TIMEVALUE("3:00 AM")),--(B48:B350<TIMEVALUE("4:00
AM"))) returns 0. Thank you