Sounds like you won't be running in a marathon any time soon!

Good luck on your recovery.

Here's yet another option:

=SUMPRODUCT(--(HOUR(I47:I3846)=22))

That covers from 10:00:00 PM to 10:59:59 PM

Just be aware that from 12:00:00 AM to 12:59:59 AM is hour 0. That will also
evaluate empty cells as 0 and could be counted as hour 0. To account for
that:

=SUMPRODUCT(--(I47:I3846<""),--(HOUR(I47:I3846)=22))

--
Biff
Microsoft Excel MVP


"az willie" wrote in message
...
"T. Valko" wrote in news:uGK4ywwWJHA.5272
@TK2MSFTNGP04.phx.gbl:

I'm assuming you deal with precision to the minute and not to the second.

Ok, to count *from* 10pm to 10:59pm:

=COUNTIF(I47:I3846,"="&TIME(22,0,0))-COUNTIF(I47:I3846,""&TIME(22,59,0))

Better if you put the time boundaries in cells:

A1 = 10:00 PM (or 22:00)
B1 = 10:59 PM (or 22:59)

=COUNTIF(I47:I3846,"="&A1)-COUNTIF(I47:I3846,""&B1)


===========
Sorry for the delay in responding. Had a minor surgery yesterday on my
foot
and the anesthesia had me knocked out all day and still not functioning
real good.

I will check out using cells as you showed when I get back up to par.

Your help is much appreciated. I just started this project at a bad time.
Didn't realize the minor surgery would knock me out so bad. Not to mention
the owie and the pain pills that don't seem to do too much.

Oh well ... this too shall pass and I will conquer the evil spreadsheet.
:)

--
If you don't believe in Freedom of Speech for people you despise ... you
don't believe in it at all.