Spreadsheet: 819715d1677665335-trying-to-find-the-number-of-patients-in-a-department-each-hour-trying-to-find-the-number-of-patients-in-a-department-each-hour
Sheet: Sheet1

Arrival_DateTime | [NAME] | [NAME] | Departure_DateTime | Departure Date | Departure Time | Time in Dept | Arrival Hour | [NAME] |  | Start Hour | No. of patients remaining during the hour |  | Start Hour | No. of patients remaining after more than an hour from start hour |  | Period | # patients discharged during the hour
2019-04-01 08:17:00 |  |  | 2019-04-01 08:58:00 |  |  | 00:41:00 |  |  |  |  | 3 |  |  | 2
2019-04-01 08:23:00 |  |  | 2019-04-01 09:15:00 |  |  | 00:52:00 |  |  |  | 09:00:00 | 7 |  | 09:00:00 | 4 |  | 09:00- 10:00
2019-04-01 08:39:00 |  |  | 2019-04-01 09:38:00 |  |  | 00:59:00 |  |  |  | 10:00:00 | 14 |  | 10:00:00 | 7 |  | 10:00- 11:00
2019-04-01 09:13:00 |  |  | 2019-04-01 10:24:00 |  |  | 01:11:00 |  |  |  | 11:00:00 | 14 |  | 11:00:00 | 5 |  | 11:00- 12:00
2019-04-01 09:29:00 |  |  | 2019-04-01 10:52:00 |  |  | 01:23:00 |  |  |  | 12:00:00 | 15 |  | 12:00:00 | 9 |  | 12:00- 13:00
2019-04-01 09:40:00 |  |  | 2019-04-01 09:59:00 |  |  | 00:19:00 |  |  |  | 13:00:00 | 15 |  | 13:00:00 | 9 |  | 13:00- 14:00
2019-04-01 09:47:00 |  |  | 2019-04-01 10:52:00 |  |  | 01:05:00 |  |  |  | 14:00:00 | 15 |  | 14:00:00 | 9 |  | 14:00- 15:00
2019-04-01 09:54:00 |  |  | 2019-04-01 10:45:00 |  |  | 00:51:00 |  |  |  | 15:00:00 | 11 |  | 15:00:00 | 5 |  | 15:00- 16:00
2019-04-01 10:04:00 |  |  | 2019-04-01 10:23:00 |  |  | 00:19:00 |  |  |  | 16:00:00 | 12 |  | 16:00:00 | 7 |  | 16:00- 17:00
2019-04-01 10:08:00 |  |  | 2019-04-01 11:15:00 |  |  | 01:07:00 |  |  |  | 17:00:00 | 11 |  | 17:00:00 | 5 |  | 17:00- 18:00
2019-04-01 10:11:00 |  |  | 2019-04-01 10:37:00 |  |  | 00:26:00 |  |  |  | 18:00:00 | 13 |  | 18:00:00 | 8 |  | 18:00- 19:00
2019-04-01 10:12:00 |  |  | 2019-04-01 10:51:49 |  |  | 00:39:00 |  |  |  | 19:00:00 | 16 |  | 19:00:00 | 7 |  | 19:00- 20:00
2019-04-01 10:16:00 |  |  | 2019-04-01 11:08:00 |  |  | 00:52:00 |  |  |  | 20:00:00 | 13 |  | 20:00:00 | 5 |  | 20:00- 21:00
2019-04-01 10:22:00 |  |  | 2019-04-01 11:32:00 |  |  | 01:10:00 |  |  |  | 21:00:00 | 5 |  | 21:00:00 | 0 |  | 21:00- 22:00
2019-04-01 10:22:00 |  |  | 2019-04-01 11:26:34 |  |  | 01:04:00
2019-04-01 10:38:00 |  |  | 2019-04-01 11:47:00 |  |  | 01:09:00 |  |  |  | Trying to find the number of patients in a department each hour
2019-04-01 10:44:00 |  |  | 2019-04-01 11:58:05 |  |  | 01:14:00 |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1400762-trying-to-find-the-number-of-patients-in-a-department-each-hour.html#post5797415
2019-04-01 10:58:00 |  |  | 2019-04-01 11:38:23 |  |  | 00:40:00
2019-04-01 11:05:00 |  |  | 2019-04-01 11:39:00 |  |  | 00:34:00
2019-04-01 11:09:00 |  |  | 2019-04-01 12:08:00 |  |  | 00:59:00
2019-04-01 11:30:00 |  |  | 2019-04-01 11:35:00 |  |  | 00:05:00
2019-04-01 11:37:00 |  |  | 2019-04-01 12:46:00 |  |  | 01:09:00
2019-04-01 11:47:00 |  |  | 2019-04-01 12:55:00 |  |  | 01:08:00
2019-04-01 11:48:00 |  |  | 2019-04-01 12:59:00 |  |  | 01:11:00
2019-04-01 11:57:00 |  |  | 2019-04-01 12:59:00 |  |  | 01:02:00
2019-04-01 12:01:00 |  |  | 2019-04-01 12:59:15 |  |  | 00:58:00
2019-04-01 12:05:00 |  |  | 2019-04-01 13:39:00 |  |  | 01:34:00
2019-04-01 12:19:00 |  |  | 2019-04-01 13:31:00 |  |  | 01:12:00
2019-04-01 12:31:00 |  |  | 2019-04-01 13:47:00 |  |  | 01:16:00
2019-04-01 12:41:00 |  |  | 2019-04-01 14:38:00 |  |  | 01:57:00
2019-04-01 12:41:00 |  |  | 2019-04-01 13:26:00 |  |  | 00:45:00
2019-04-01 12:45:00 |  |  | 2019-04-01 13:48:56 |  |  | 01:03:00
2019-04-01 12:48:00 |  |  | 2019-04-01 13:54:54 |  |  | 01:06:00
2019-04-01 12:48:00 |  |  | 2019-04-01 14:01:00 |  |  | 01:13:00
2019-04-01 12:50:00 |  |  | 2019-04-01 14:02:00 |  |  | 01:12:00
2019-04-01 13:09:00 |  |  | 2019-04-01 15:20:00 |  |  | 02:11:00
2019-04-01 13:31:00 |  |  | 2019-04-01 14:20:00 |  |  | 00:49:00
2019-04-01 13:34:00 |  |  | 2019-04-01 14:35:46 |  |  | 01:01:00
2019-04-01 13:45:00 |  |  | 2019-04-01 14:35:00 |  |  | 00:50:00
2019-04-01 13:49:00 |  |  | 2019-04-01 16:14:00 |  |  | 02:25:00
2019-04-01 13:54:00 |  |  | 2019-04-01 15:12:00 |  |  | 01:18:00
2019-04-01 14:23:00 |  |  | 2019-04-01 15:20:23 |  |  | 00:57:00
2019-04-01 14:34:00 |  |  | 2019-04-01 15:42:00 |  |  | 01:08:00
2019-04-01 14:36:00 |  |  | 2019-04-01 15:38:00 |  |  | 01:02:00
2019-04-01 14:43:00 |  |  | 2019-04-01 15:26:24 |  |  | 00:43:00
2019-04-01 14:50:00 |  |  | 2019-04-01 16:50:00 |  |  | 02:00:00
2019-04-01 14:58:00 |  |  | 2019-04-01 16:36:00 |  |  | 01:38:00
2019-04-01 15:03:00 |  |  | 2019-04-01 16:55:00 |  |  | 01:52:00
2019-04-01 15:54:00 |  |  | 2019-04-01 17:31:00 |  |  | 01:37:00
2019-04-01 16:12:00 |  |  | 2019-04-01 17:30:00 |  |  | 01:18:00
2019-04-01 16:16:00 |  |  | 2019-04-01 16:50:55 |  |  | 00:34:00
2019-04-01 16:18:00 |  |  | 2019-04-01 17:04:31 |  |  | 00:46:00
2019-04-01 16:21:00 |  |  | 2019-04-01 17:14:00 |  |  | 00:53:00
2019-04-01 16:26:00 |  |  | 2019-04-01 17:31:00 |  |  | 01:05:00
2019-04-01 16:37:00 |  |  | 2019-04-01 17:23:21 |  |  | 00:46:00
2019-04-01 16:55:00 |  |  | 2019-04-01 18:00:26 |  |  | 01:05:00
2019-04-01 17:00:00 |  |  | 2019-04-01 19:25:00 |  |  | 02:25:00
2019-04-01 17:34:00 |  |  | 2019-04-01 20:25:00 |  |  | 02:51:00
2019-04-01 17:58:00 |  |  | 2019-04-01 19:06:00 |  |  | 01:08:00
2019-04-01 17:59:00 |  |  | 2019-04-01 18:31:00 |  |  | 00:32:00
2019-04-01 18:02:00 |  |  | 2019-04-01 18:30:37 |  |  | 00:28:00
2019-04-01 18:07:00 |  |  | 2019-04-01 18:36:59 |  |  | 00:29:00
2019-04-01 18:17:00 |  |  | 2019-04-01 18:47:43 |  |  | 00:30:00
2019-04-01 18:23:00 |  |  | 2019-04-01 19:22:32 |  |  | 00:59:00
2019-04-01 18:27:00 |  |  | 2019-04-01 19:05:00 |  |  | 00:38:00
2019-04-01 18:40:00 |  |  | 2019-04-01 19:46:23 |  |  | 01:06:00
2019-04-01 18:44:00 |  |  | 2019-04-01 19:22:00 |  |  | 00:38:00
2019-04-01 18:56:00 |  |  | 2019-04-01 19:21:31 |  |  | 00:25:00
2019-04-01 19:02:00 |  |  | 2019-04-01 19:37:05 |  |  | 00:35:00
2019-04-01 19:06:00 |  |  | 2019-04-01 19:41:00 |  |  | 00:35:00
2019-04-01 19:12:00 |  |  | 2019-04-01 20:13:00 |  |  | 01:01:00
2019-04-01 19:25:00 |  |  | 2019-04-01 20:00:00 |  |  | 00:35:00
2019-04-01 19:34:00 |  |  | 2019-04-01 20:20:24 |  |  | 00:46:00
2019-04-01 19:40:00 |  |  | 2019-04-01 20:24:12 |  |  | 00:44:00
2019-04-01 19:45:00 |  |  | 2019-04-01 20:16:25 |  |  | 00:31:00
2019-04-01 19:48:00 |  |  | 2019-04-01 21:28:01 |  |  | 01:40:00
2019-04-01 20:00:00 |  |  | 2019-04-01 20:54:00 |  |  | 00:54:00
2019-04-01 20:08:00 |  |  | 2019-04-01 21:42:47 |  |  | 01:34:00
2019-04-01 20:16:00 |  |  | 2019-04-01 20:52:31 |  |  | 00:36:00
2019-04-01 20:32:00 |  |  | 2019-04-01 21:45:31 |  |  | 01:13:00
2019-04-01 20:35:00 |  |  | 2019-04-01 21:18:59 |  |  | 00:43:00
2019-04-01 20:43:00 |  |  | 2019-04-01 21:23:42 |  |  | 00:40:00