Skip to Content
0
Former Member
Apr 09, 2014 at 07:42 PM

How to calculate the number of events that happened per clock hour.

34 Views


My example case has a list of patients that were discharged from a hospital yesterday. The patients are in a field caled "Account number".

The field "Discharge Date" lets me select the date. The field "Discharge TIme" shows me the time each patient was discharged.

Example: 0715, 0830,1005, 1010, 1025, 1435, etc. I need to run the report to know how many patients were discharged per each clock hour. How many were discharged from 0000 to 0100, 0100 - 0200, 0200 - 0300, etc.

Acct # Disch Time

P12121 0715

P23233 0731

P34343 0812

P32333 1015

From research I am assuming I need to capture just the first two numbers that represent the hour and discard the minutes.

I would like to see the results in a similar format to this.

Hour #of Patients

07-08 2

08-09 1

09-10 1

.

.

22-23 x

23-00 x