Spreadsheet: 46397d1245266406-mean-by-day-of-the-week-if-after-a-certain-time-and-before-midnight-meanday
Sheet: Sheet1

PROCDATE | WEEKDAY | TIME_IN | TIME_OUT | ROOMTIME | WEEKDAY# |  |  |  | MEAN HOURS USED AFTER 15:30:00
2009-01-02 00:00:00 | 2009-01-02 00:00:00 | 08:01:51 | 09:05:00 | 01:03:09 |  |  | 1 | Sunday
2009-01-02 00:00:00 | 2009-01-02 00:00:00 | 09:32:08 | 10:15:00 | 00:42:52 |  |  | 2 | Monday
2009-01-02 00:00:00 | 2009-01-02 00:00:00 | 13:11:26 | 13:45:00 | 00:33:34 |  |  | 3 | Tuesday
2009-01-02 00:00:00 | 2009-01-02 00:00:00 | 08:01:15 | 08:47:00 | 00:45:45 |  |  | 4 | Wednesday
2009-01-02 00:00:00 | 2009-01-02 00:00:00 | 08:49:00 | 09:35:00 | 00:46:00 |  |  | 5 | Thursday
2009-01-02 00:00:00 | 2009-01-02 00:00:00 | 09:41:59 | 10:27:20 | 00:45:21 |  |  | 6 | Friday
2009-01-02 00:00:00 | 2009-01-02 00:00:00 | 13:51:39 | 14:35:00 | 00:43:21 |  |  | 7 | Saturday
2009-01-03 00:00:00 | 2009-01-03 00:00:00 | 02:32:05 | 03:15:05 | 00:43:00
2009-01-05 00:00:00 | 2009-01-05 00:00:00 | 07:42:36 | 08:26:00 | 00:43:24
2009-01-05 00:00:00 | 2009-01-05 00:00:00 | 10:13:19 | 11:08:05 | 00:54:46
2009-01-05 00:00:00 | 2009-01-05 00:00:00 | 10:45:05 | 11:58:58 | 01:13:53
2009-01-06 00:00:00 | 2009-01-06 00:00:00 | 21:05:54 | 22:05:00 | 00:59:06
2009-01-07 00:00:00 | 2009-01-07 00:00:00 | 07:51:08 | 08:56:00 | 01:04:52
2009-01-07 00:00:00 | 2009-01-07 00:00:00 | 09:20:17 | 10:06:00 | 00:45:43
2009-01-07 00:00:00 | 2009-01-07 00:00:00 | 10:14:09 | 11:13:00 | 00:58:51
2009-01-07 00:00:00 | 2009-01-07 00:00:00 | 15:18:30 | 15:51:30 | 00:33:00
2009-01-07 00:00:00 | 2009-01-07 00:00:00 | 09:02:12 | 09:58:00 | 00:55:48
2009-01-07 00:00:00 | 2009-01-07 00:00:00 | 10:09:29 | 10:55:20 | 00:45:51
2009-01-07 00:00:00 | 2009-01-07 00:00:00 | 09:24:58 | 10:18:00 | 00:53:02
2009-01-08 00:00:00 | 2009-01-08 00:00:00 | 17:31:54 | 18:25:00 | 00:53:06
2009-01-08 00:00:00 | 2009-01-08 00:00:00 | 12:53:43 | 14:06:20 | 01:12:37
2009-01-09 00:00:00 | 2009-01-09 00:00:00 | 07:44:05 | 08:42:48 | 00:58:43
2009-01-09 00:00:00 | 2009-01-09 00:00:00 | 14:20:06 | 15:50:00 | 01:29:54
2009-01-12 00:00:00 | 2009-01-12 00:00:00 | 07:59:26 | 08:42:35 | 00:43:09
2009-01-12 00:00:00 | 2009-01-12 00:00:00 | 10:39:37 | 11:23:00 | 00:43:23
2009-01-12 00:00:00 | 2009-01-12 00:00:00 | 11:26:45 | 11:55:00 | 00:28:15
2009-01-12 00:00:00 | 2009-01-12 00:00:00 | 16:51:37 | 18:10:00 | 01:18:23
2009-01-12 00:00:00 | 2009-01-12 00:00:00 | 08:40:18 | 09:07:00 | 00:26:42
2009-01-12 00:00:00 | 2009-01-12 00:00:00 | 09:19:33 | 09:54:12 | 00:34:39
2009-01-13 00:00:00 | 2009-01-13 00:00:00 | 09:44:28 | 10:43:00 | 00:58:32
2009-01-13 00:00:00 | 2009-01-13 00:00:00 | 10:50:18 | 11:43:09 | 00:52:51
2009-01-13 00:00:00 | 2009-01-13 00:00:00 | 14:13:01 | 15:16:32 | 01:03:31
2009-01-28 00:00:00 | 2009-01-28 00:00:00 | 09:40:43 | 10:46:00 | 01:05:17
2009-01-28 00:00:00 | 2009-01-28 00:00:00 | 13:29:31 | 14:24:00 | 00:54:29
2009-01-28 00:00:00 | 2009-01-28 00:00:00 | 08:03:28 | 08:52:00 | 00:48:32
2009-01-28 00:00:00 | 2009-01-28 00:00:00 | 09:01:51 | 10:05:00 | 01:03:09
2009-01-28 00:00:00 | 2009-01-28 00:00:00 | 15:07:10 | 15:58:00 | 00:50:50
2009-01-29 00:00:00 | 2009-01-29 00:00:00 | 13:05:42 | 14:05:42 | 01:00:00
2009-01-30 00:00:00 | 2009-01-30 00:00:00 | 07:33:11 | 08:41:12 | 01:08:01
2009-01-30 00:00:00 | 2009-01-30 00:00:00 | 08:51:39 | 09:40:00 | 00:48:21
2009-01-30 00:00:00 | 2009-01-30 00:00:00 | 10:25:59 | 10:59:00 | 00:33:01
2009-01-30 00:00:00 | 2009-01-30 00:00:00 | 11:02:05 | 11:27:00 | 00:24:55
2009-01-30 00:00:00 | 2009-01-30 00:00:00 | 11:31:42 | 12:20:13 | 00:48:31
2009-01-30 00:00:00 | 2009-01-30 00:00:00 | 13:44:49 | 14:35:00 | 00:50:11
2009-01-30 00:00:00 | 2009-01-30 00:00:00 | 15:14:37 | 16:33:31 | 01:18:54
2009-01-30 00:00:00 | 2009-01-30 00:00:00 | 07:47:37 | 09:01:00 | 01:13:23
2009-01-30 00:00:00 | 2009-01-30 00:00:00 | 09:05:02 | 09:50:05 | 00:45:03
2009-01-31 00:00:00 | 2009-01-31 00:00:00 | 04:45:01 | 05:33:24 | 00:48:23
2009-02-02 00:00:00 | 2009-02-02 00:00:00 | 07:48:31 | 08:35:00 | 00:46:29
2009-02-02 00:00:00 | 2009-02-02 00:00:00 | 10:12:41 | 11:16:00 | 01:03:19
2009-02-02 00:00:00 | 2009-02-02 00:00:00 | 08:20:22 | 09:14:42 | 00:54:20
2009-02-02 00:00:00 | 2009-02-02 00:00:00 | 09:25:18 | 10:00:00 | 00:34:42
2009-02-04 00:00:00 | 2009-02-04 00:00:00 | 08:42:52 | 09:26:00 | 00:43:08
2009-02-04 00:00:00 | 2009-02-04 00:00:00 | 09:04:34 | 10:02:23 | 00:57:49
2009-02-04 00:00:00 | 2009-02-04 00:00:00 | 10:15:23 | 11:07:15 | 00:51:52
2009-02-04 00:00:00 | 2009-02-04 00:00:00 | 09:36:40 | 11:40:00 | 02:03:20
2009-02-04 00:00:00 | 2009-02-04 00:00:00 | 11:56:32 | 12:50:19 | 00:53:47
2009-02-05 00:00:00 | 2009-02-05 00:00:00 | 11:09:58 | 12:05:00 | 00:55:02
2009-02-06 00:00:00 | 2009-02-06 00:00:00 | 08:13:04 | 09:15:00 | 01:01:56
2009-02-06 00:00:00 | 2009-02-06 00:00:00 | 09:47:29 | 10:27:41 | 00:40:12
2009-02-06 00:00:00 | 2009-02-06 00:00:00 | 10:36:48 | 11:30:00 | 00:53:12
2009-02-06 00:00:00 | 2009-02-06 00:00:00 | 14:24:31 | 15:06:50 | 00:42:19
2009-02-06 00:00:00 | 2009-02-06 00:00:00 | 15:51:48 | 16:32:00 | 00:40:12
2009-02-06 00:00:00 | 2009-02-06 00:00:00 | 16:44:54 | 17:30:00 | 00:45:06
2009-02-06 00:00:00 | 2009-02-06 00:00:00 | 07:47:17 | 08:33:06 | 00:45:49
2009-02-06 00:00:00 | 2009-02-06 00:00:00 | 08:55:08 | 09:48:08 | 00:53:00
2009-02-06 00:00:00 | 2009-02-06 00:00:00 | 09:51:50 | 10:40:00 | 00:48:10
2009-02-06 00:00:00 | 2009-02-06 00:00:00 | 12:35:52 | 13:30:47 | 00:54:55
2009-02-06 00:00:00 | 2009-02-06 00:00:00 | 15:40:36 | 16:48:39 | 01:08:03
2009-02-07 00:00:00 | 2009-02-07 00:00:00 | 12:32:14 | 14:40:00 | 02:07:46
2009-02-07 00:00:00 | 2009-02-07 00:00:00 | 18:35:47 | 19:50:00 | 01:14:13
2009-02-08 00:00:00 | 2009-02-08 00:00:00 | 15:45:41 | 16:40:12 | 00:54:31
2009-02-08 00:00:00 | 2009-02-08 00:00:00 | 16:56:33 | 17:30:00 | 00:33:27