From your posted data it appears that time is in column A and the number of
patients for each hour is in column B:

1. make sure that the sheet represents only a single 24 hour period. (use a
new sheet for each day)

2. in an un-used cell, enter:

=SUM(B:B)/24
--
Gary''s Student - gsnu200719


"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