Thank you for helping me out. For some reason, excel will not recognize the 0
as 0. No matter what I set that cell value to be, it will not recognize it
when I try to conditional format it.

"pinmaster" wrote:

Try this:

In column B, ajust your formula to return a 0 instead of a blank "", you can
then use conditional formatting to hide the "0:00"'.



Regards
Jean-Guy

"Joker" wrote:

That works but only if every cell in from B48:B350 either has a time in it or
is completely empty. In each of these cells I have a formula to automatically
insert the current time when the adjacent cell in column C has a number typed
into it. The formula returns #VALUE if one of these cells in column B doesn't
have the time inserted and is left with just the formula. Is there any way
around this without removing the formulas in column B? Thank you.

"pinmaster" wrote:

You're right, it doesn't seem to recognize the time value when NOW() is used,
so try this instead:

=SUMPRODUCT((TIME(HOUR(B48:B350),MINUTE(B48:B350), 0)=TIMEVALUE("3:00
AM"))*(TIME(HOUR(B48:B350),MINUTE(B48:B350),0)<=TI MEVALUE("4:00 AM")))


HTH
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