Thank you, all of these solutions worked!
Cheers,
Suzie

"T. Valko" wrote:

Use cells to hold the time boundaries:

A1 = start time = 7:00 AM
A2 = end time = 11:00 AM

=COUNTIF(B:B,"="&A1)-COUNTIF(B:B,""&A2)

--
Biff
Microsoft Excel MVP


"Suzie" wrote in message
...
I have a spreadsheet with occurences of incidents where the time of the
incident is recorded. I'm trying to count the number of times the incident
occurs between certain times (eg 7am and 11am) by using the countif
function
with variations on the following formula =countif(B:B, "=07:00:00 &
<11:00:00") but it is not calculating it correctly. Can somebody help?



.