All hours represented within a time range.
Posted on 2006-07-17
I'm looking to determine hourly patient volume for our hopsital Emergency Department. I have each patient's arrival and departure times. For each hour within the period defined by these two markers, I would like to count the number of patients present.
I can easily determine the # of patients arriving and the # of patients leaving within a given hour. I need help counting the hours represented for those patients neither arriving nor leaving during a given hour.
Any help is appreciated.