Hey All,

What I'm looking to do is Count cells where time is equal to or exceeds 4:30 PM, as 1. (Left Column) Also, do the same in the right column, but only count the cells where time is equal to or exceeds 4:30 PM, but is no greater than 5:00PM, as 1.
The columns in the screenshot have dates and times. Can anyone provide me with a formula solution?

Thank you!

How about using the IF statement? Have you tried that?

Hi - I played around with this briefly. Set up a second range of cells where the top left cell corresponds to the top left cell of the original range(i.e.-B2).
Formula =ROUNDDOWN(B2,0)-B2
copy this formula to all of the cells in the new range. This essentially removes the date from the values. Then in a cell outside of the ranges, use a =(COUNTIF(range:range,">4:29")-COUNTIF(range:range,">5:01))

to count all of the cells with a time value that you indicated wanting to know.

Good luck

=B2-ROUNDDOWN(B2,0)
round off date to leave only time

=(COUNTIF(G2:J25,">4:29")-COUNTIF(G2:J25,">5:00"))
all greater than 4:29 minus all greater than 5:00

Excelorator,

YOU flippin ROCK!
Thanks a ton....that will do the trick. Dam - that's awesome!

MillB