gary, thanks'
ive done that, let me clarify further, what i am trying to do is pull out
the number of patients the are registered per hour. i am trying to automate
this process.

i think i need arguments like , IF pt registred between 0700 and 0759,
place total number of patients for that hour in comlum b.

i need to do this over a 24 hour time frame.
does that make sence? i dont quite know how to do that...thanks for helping
me.
--
dr350x


"Gary''s Student" wrote:

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