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