dom, thank you,
your asumption on colum layout is correct.
i inputed the formula, i did it for one 24hr period. i did it for on hour
1100 to 1200. i had 7 patients that hour, the formula returned 148. B cell
formated to gen number. i think i understand what it trying to do, but i cant
figure why it came up with that total. any thoughts?
--
dr350x


"Dom_Ciccone" wrote:

Okay. I'm assuming you have a list of times that patients attended your ER
and that this list appears in column A, such as:

A
1 07:20
2 07:24
3 08:13
4 08:43

Highlight the entire list of data and name the range "PTTimes"
(Insert--Name--Define).

In cell B1, type this formula:

=COUNTIF(PTTimes,"="&TIME(7,0,0))-COUNTIF(PTTimes,"="&TIME(8,0,0))

This should return the correct count of patients attending between 7am and
8am.

Is it not doing that?