Spreadsheet: 267231d1380019766-min-max-problem-report
Sheet: Times

 |  |  |  |  |  |  | Times
Week Ending | 2013-09-21 00:00:00 |  | Sunday |  | Monday |  |  |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  |  |  | Thursday |  |  |  |  |  |  |  |  | Friday |  |  |  |  |  |  |  |  | Saturday
 |  |  | 3 | Calculated |  |  | 3 | Calculated |  |  |  |  |  |  |  | 3 | Calculated |  |  |  |  |  |  |  | 3 | Calculated |  |  |  |  |  |  |  | 3 | Calculated |  |  |  |  |  |  |  | 3 | Calculated |  |  |  |  |  | 3 | Calculated
AM |  |  | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1
 |  | In | 09:25:00 |  | 08:55:00 | 09:03:00 | 08:57:00 |  | 08:50:00 | 08:45:00 | 09:08:00 | 09:06:00 | 08:32:00 | 08:45:00 | 09:01:00 | 10:20:00 |  | 09:12:00 | 09:22:00 | 09:09:00 | 09:22:00 | 09:08:00 | 08:57:00 | 09:11:00 | 09:12:00 |  | 08:50:00 | 08:45:00 | 08:50:00 | 08:36:00 | 09:10:00 | 08:55:00 | 08:51:00 | 09:37:00 |  | 08:53:00 | 09:00:00 | 09:00:00 | 08:51:00 |  | 08:51:00 | 09:05:00 | 09:22:00 |  |  | 08:34:00 | 09:00:00 | 09:00:00 | 09:11:00 | 09:18:00
 |  | Out | 10:31:00 |  | 12:15:00 | 10:55:00 | 11:09:00 |  | 11:01:00 | 10:04:00 | 09:39:00 | 10:46:00 | 09:00:00 | 09:28:00 | 13:18:00 | 11:10:00 |  | 12:00:00 | 13:30:00 | 11:20:00 | 10:23:00 | 10:06:00 | 11:02:00 | 10:52:00 | 12:58:00 |  | 11:08:00 | 09:09:00 | 11:07:00 | 09:00:00 | 10:35:00 | 10:56:00 | 16:41:00 | 14:34:00 |  | 11:29:00 | 11:22:00 | 09:58:00 | 09:29:00 |  | 10:31:00 | 10:40:00 | 11:41:00 |  |  | 09:51:00 | 10:44:00 | 11:18:00 | 09:32:00 | 11:45:00
 |  | In | 10:45:00 | 2 | 13:00:00 | 10:59:00 | 14:02:00 | 2 | 11:15:00 |  | 09:53:00 | 10:27:00 | 09:02:00 | 09:35:00 | 13:43:00 | 14:18:00 | 2 | 12:08:00 | 14:21:00 | 10:48:00 | 10:31:00 | 10:11:00 | 11:22:00 | 10:44:00 | 09:12:00 | 2 | 13:15:00 | 09:15:00 | 11:01:00 | 09:01:00 | 10:43:00 | 11:04:00 | 08:51:00 | 09:37:00 | 2 | 08:53:00 | 09:00:00 | 10:02:00 | 08:51:00 |  | 08:51:00 | 10:51:00 | 14:52:00 | 2 |  | 09:45:00 | 10:45:00 | 11:21:00 | 09:42:00 | 11:54:00 | 2
 |  | Out | 12:34:00 |  | 14:51:00 | 16:04:00 | 15:19:00 |  | 13:52:00 |  | 11:28:00 | 11:17:00 | 09:45:00 | 11:30:00 | 16:56:00 | 15:23:00 |  | 15:24:00 | 17:06:00 | 11:51:00 | 11:14:00 | 10:46:00 | 13:02:00 | 14:15:00 | 12:58:00 |  | 15:08:00 | 10:09:00 | 12:30:00 | 09:24:00 | 11:26:00 | 12:08:00 | 16:41:00 | 14:34:00 |  | 11:29:00 | 11:22:00 | 10:35:00 | 09:29:00 |  | 10:31:00 | 11:35:00 | 16:19:00 |  |  | 10:42:00 | 11:44:00 | 12:48:00 | 10:00:00 | 14:31:00
 |  | In | 12:45:00 |  | 14:44:00 | 15:50:00 | 15:30:00 |  | 14:17:00 |  | 11:30:00 | 11:30:00 | 09:55:00 | 11:31:00 |  | 15:40:00 |  |  |  | 11:53:00 |  | 10:48:00 |  |  | 13:33:00 |  | 08:50:00 | 10:10:00 |  | 09:20:00 |  | 12:08:00 |  | 15:34:00 |  | 11:37:00 | 11:14:00 | 10:39:00 | 09:35:00 |  | 11:07:00 |  | 16:51:00 |  |  | 11:02:00 | 11:51:00 | 09:00:00 | 10:07:00 | 16:02:00
 |  | Out | 15:45:00 | 3 | 16:14:00 | 18:00:00 | 16:10:00 | 3 | 15:09:00 |  | 12:15:00 | 12:05:00 | 10:08:00 | 13:02:00 |  | 16:16:00 | 3 |  |  | 12:33:00 |  | 11:20:00 |  |  | 14:15:00 | 3 | 11:08:00 | 11:17:00 |  | 09:42:00 |  | 13:03:00 |  | 16:17:00 | 3 | 12:17:00 | 13:27:00 | 11:36:00 | 10:25:00 |  | 13:19:00 |  | 19:21:00 | 3 |  | 12:00:00 | 12:30:00 | 11:18:00 | 10:20:00 | 16:58:00 | 3
 |  | In | 15:50:00 |  |  |  | 23:57:00 |  | 15:39:00 |  |  |  | 10:57:00 |  |  |  |  |  |  |  |  | 11:22:00 |  |  | 14:52:00 |  | 11:09:00 | 11:03:00 |  | 09:43:00 |  |  |  | 19:27:00 |  |  |  |  |  |  |  |  |  |  |  | 11:58:00 |  | 11:21:00 | 10:56:00 | 19:51:00
 |  | Out | 18:24:00 |  |  |  | 1900-01-01 02:15:00 |  | 16:18:00 |  |  |  | 11:35:00 |  |  |  |  |  |  |  |  | 11:48:00 |  |  | 15:30:00 |  | 13:00:00 | 11:50:00 |  | 10:00:00 |  |  |  | 20:24:00 |  |  |  |  |  |  |  |  |  |  |  | 12:24:00 |  | 12:48:00 | 11:25:00 | 20:28:00
 |  | In |  | 4 |  |  |  | 4 |  |  |  |  | 11:36:00 |  |  |  | 4 |  |  |  |  |  |  |  | 20:45:00 | 4 | 13:15:00 |  |  | 10:00:00 |  |  |  | 20:31:00 | 4 |  |  |  |  |  |  |  |  | 4 |  | 12:25:00 |  |  | 11:34:00 |  | 4
 |  | Out |  |  |  |  |  |  |  |  |  |  | 11:58:00 |  |  |  |  |  |  |  |  |  |  |  | 21:38:00 |  | 15:08:00 |  |  | 10:20:00 |  |  |  | 21:07:00 |  |  |  |  |  |  |  |  |  |  |  | 13:11:00 |  |  | 11:49:00
 |  | In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:13:00 |  |  | 10:24:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:52:00
 |  | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:43:00 |  |  | 10:40:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:15:00
 |  | In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:05:00
 |  | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:21:00
 |  | In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:12:00
 |  | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:51:00
 |  | In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:44:00
 |  | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:04:00
 |  | In
 |  | Out
 |  | In
 |  | Out
PM |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 |  |  |  | 2 |  | 2 | 2 | 2 |  | 2 |  |  |  | 2 | 2 | 2 | 2 | 2 |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2
 |  | In |  |  |  |  |  |  |  | 12:47:00 | 14:07:00 | 13:18:00 |  | 14:22:00 |  |  |  | 16:35:00 |  | 13:58:00 | 14:04:00 | 14:07:00 |  | 14:56:00 |  |  |  | 14:08:00 | 13:53:00 | 13:05:00 | 15:40:00 | 14:19:00 |  |  |  | 12:47:00 | 13:51:00 | 13:46:00 | 13:18:00 | 14:19:00 |  | 13:37:00 |  |  |  |  | 14:01:00 | 16:30:00
 |  | Out |  |  |  |  |  |  |  | 13:31:00 | 14:49:00 | 14:01:00 |  | 15:22:00 |  |  |  | 17:19:00 |  | 14:56:00 | 14:47:00 | 15:11:00 |  | 17:00:00 |  |  |  | 15:45:00 | 15:08:00 | 13:38:00 | 16:22:00 | 15:55:00 |  |  |  | 15:53:00 | 14:15:00 | 14:45:00 | 13:50:00 | 15:26:00 |  | 15:08:00 |  |  |  |  | 14:56:00 | 17:02:00
 |  | In |  |  |  |  |  |  |  | 13:47:00 | 14:54:00 | 14:03:00 |  | 15:40:00 |  |  |  |  |  | 14:59:00 | 14:48:00 | 15:18:00 |  |  |  |  |  | 14:08:00 | 15:12:00 | 13:16:00 | 12:50:00 | 15:47:00 |  |  |  | 13:16:00 | 14:40:00 | 14:46:00 | 13:55:00 | 15:27:00 |  | 15:10:00 |  |  |  |  | 15:00:00 | 14:28:00
 |  | Out |  |  |  |  |  |  |  | 16:28:00 | 15:38:00 | 14:50:00 |  | 16:53:00 |  |  |  |  |  | 15:39:00 | 16:16:00 | 15:48:00 |  |  |  |  |  | 15:45:00 | 16:45:00 | 14:07:00 | 13:46:00 | 17:26:00 |  |  |  | 13:38:00 | 15:34:00 | 15:50:00 | 14:16:00 | 16:22:00 |  | 15:40:00 |  |  |  |  | 15:57:00 | 14:51:00
 |  | In |  |  |  |  |  |  |  |  | 15:38:00 | 14:49:00 |  | 17:00:00 |  |  |  |  |  | 15:38:00 | 16:20:00 | 15:52:00 |  |  |  |  |  | 15:31:00 | 16:36:00 | 14:06:00 | 13:51:00 |  |  |  |  |  | 15:34:00 | 15:38:00 | 14:22:00 | 16:23:00 |  |  |  |  |  |  | 16:01:00 | 14:58:00
 |  | Out |  |  |  |  |  |  |  |  | 16:06:00 | 15:34:00 |  | 18:00:00 |  |  |  |  |  | 16:13:00 | 17:02:00 | 16:24:00 |  |  |  |  |  | 16:59:00 | 17:20:00 | 14:27:00 | 14:26:00 |  |  |  |  |  | 16:36:00 | 16:30:00 | 14:41:00 | 16:32:00 |  |  |  |  |  |  | 16:42:00 | 16:45:00
 |  | In |  |  |  |  |  |  |  |  | 16:11:00 | 15:37:00 |  |  |  |  |  |  |  | 16:10:00 |  | 16:37:00 |  |  |  |  |  |  |  | 14:24:00 | 14:28:00 |  |  |  |  |  |  | 13:46:00 | 14:45:00 | 16:37:00 |  |  |  |  |  |  |  | 16:30:00
 |  | Out |  |  |  |  |  |  |  |  | 16:56:00 | 15:59:00 |  |  |  |  |  |  |  | 16:36:00 |  | 17:04:00 |  |  |  |  |  |  |  | 14:43:00 | 15:18:00 |  |  |  |  |  |  | 14:45:00 | 15:08:00 | 16:54:00 |  |  |  |  |  |  |  | 17:02:00
 |  | In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:17:00 | 15:14:00 |  |  |  |  |  |  | 14:46:00 | 15:13:00
 |  | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:50:00 | 15:51:00 |  |  |  |  |  |  | 15:50:00 | 15:39:00
 |  | In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:41:00 | 15:40:00 |  |  |  |  |  |  | 15:38:00 | 15:40:00
 |  | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:09:00 | 16:22:00 |  |  |  |  |  |  | 16:30:00 | 16:05:00
 |  | In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:08:00
 |  | Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:32:00
 |  | In
 |  | Out
 |  | In
 |  | Out
 |  | In
 |  | Out
 |  | In
 |  | Out
1 | 00:00:00 | to | 08:29:00
2 | 08:30:00 | to | 16:59:00
3 | 17:00:00 | to | 21:00:00
4 | 21:00:00 | to | 1900-01-01 08:30:00