thanks,dom
i put the formula in, it seems to be counting only on cell at a time, i have
mult patients per hour, how do i get it count all between the range of say
0800 to 0900. rows would be, say from 15 to 22 ( 7 pts in that hour).
i think in understand whats happening with the formula.
-- thank you
dr350x


"Dom_Ciccone" wrote:

Meant to point out that you will need to adjust the range for your list of
times. It might be easier to use a named range in the formula and then just
use Insert--Name--Define to adjust the area that the name refers to.

"Dom_Ciccone" wrote:

Assuming that your range of data starts at A1, the formula you need to count
those between 7am and 8am is:

=COUNTIF($A$1:$A$5,"="&TIME(7,0,0))-COUNTIF($A$1:$A$5,"="&TIME(8,0,0))

To find those between 8am and 9am, simply change the formula to read:

=COUNTIF($A$1:$A$5,"="&TIME(8,0,0))-COUNTIF($A$1:$A$5,"="&TIME(9,0,0))

Apply the equivalent formulae to the other 22 cells so that you have one
formula for each of the 24 hours in the period. Remember to use 13,14,15 etc
for the 24-hour clock.

This should be what you need.

"dr350x" wrote:

hello,
newer to excel 03, i have data from my ER, i cant figure how to pull out the
number of patients per hour. i can do it manualy but this is tedious. would
like to automat process, pivot or formula?
eg: pts presents at
07:00
07:10 3 patients from 07:00 to 07:59
07:12
08:15
08:17 2 patients from 08:00 to 08:59

this goes on over 24 hours. military time.

i have tried different formulas, IF,AND,OR functions, i tried conditional
formating. i failed miserably at these. i m to new at excel to know the
nuances. i have done many searches on this forum and found and solved 95% of
the issues in needed to solve. any help would be greatly appreciated. thank
you in advance! dr350x

--
dr350x