teethless,
thanks i 'll try it this week....
--
dr350x


"Teethless mama" wrote:

Assuming your data in column A (A2:A100)
create a helper column in (Column B)
B2: holds 7:00
B3: holds 8:00
B4: holds 9:00
and so on...to 24:00

In C2: =SUMPRODUCT(--($A$2:$A$100=$B2),--($A$2:$A$100<$B3))

Drag the Fill Handle in C2 to copy as far as needed



"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