Spreadsheet: 154744d1336544611-calculating-hours-between-dates-but-excluding-certain-dates-example
Sheet: Time Report

Call Received Date | Actual Service Date | Hours
2011-06-01 13:00:00 | 2011-06-01 14:00:00
2011-06-01 13:00:00 | 2011-06-03 15:25:00
2011-06-01 13:00:00 | 2011-06-02 10:30:00
2011-06-01 13:00:00 | 2011-06-02 10:00:00
2011-06-01 12:00:00 | 2011-06-06 12:00:00
2011-06-01 08:41:19 | 2011-06-06 12:00:00
2011-06-01 08:42:03 | 2011-06-06 12:00:00
2011-06-01 08:43:14 | 2011-06-06 12:00:00
2011-06-01 08:44:45 | 2011-06-06 12:00:00
2011-06-01 08:53:13 | 2011-05-31 09:00:00
2011-06-01 08:54:03 | 2011-05-31 10:00:00
2011-06-01 08:54:36 | 2011-05-31 10:00:00
2011-06-01 08:55:34 | 2011-05-31 10:00:00
2011-06-01 09:02:15 | 2011-06-02 12:45:00
2011-06-01 09:17:56 | 2011-08-18 14:30:00
2011-06-01 13:00:00 | 2011-06-02 13:50:00
2011-06-01 13:00:00 | 2011-07-18 12:00:00
2011-06-01 13:00:00 | 2011-06-02 13:50:00
2011-06-01 13:00:00 | 2011-06-02 13:50:00
2011-06-01 13:00:00 | 2011-06-02 13:50:00
2011-06-01 09:50:34 | 2011-05-31 10:00:00
2011-06-01 09:51:19 | 2011-05-31 10:00:00
2011-06-01 13:00:00 | 2011-06-02 10:00:00
2011-06-01 09:54:06 | 2011-05-31 10:00:00
2011-06-01 13:00:00 | 2011-06-03 09:30:00
2011-06-01 09:55:08 | 2011-05-31 10:00:00
2011-06-01 09:55:51 | 2011-05-31 10:00:00
2011-06-01 10:05:18 | 2011-06-03 11:00:00
2011-06-01 10:08:10 | 2011-06-07 15:20:00
2011-06-01 10:27:37 | 2011-06-02 15:30:00
2011-06-01 10:35:26 | 2011-06-02 13:00:00
2011-06-01 10:36:02 | 2011-05-31 10:10:00
2011-06-01 10:36:27 | 2011-06-02 13:30:00
2011-06-01 10:51:37 | 2011-06-02 10:15:00
2011-06-01 11:08:58 | 2011-06-06 08:45:00
2011-06-01 11:52:20 | 2011-06-03 09:00:00
2011-06-01 11:58:13 | 2011-06-03 10:00:00
2011-06-01 12:41:31 | 2011-06-02 11:10:00
2011-06-01 12:41:59 | 2011-06-02 11:10:00
2011-06-01 12:51:26 | 2011-06-03 12:00:00
2011-06-01 13:04:03 | 2011-06-01 13:15:00
2011-06-01 13:27:27 | 2011-06-03 00:00:00
2011-06-01 13:55:50 | 2011-06-01 00:00:00
2011-06-01 13:56:00 | 2011-06-08 13:30:00
2011-06-01 13:58:32 | 2011-06-01 15:00:00
2011-06-01 13:59:18 | 2011-06-06 10:30:00
2011-06-01 14:00:48 | 2011-06-01 16:00:00
2011-06-01 14:01:23 | 2011-06-01 16:00:00
2011-06-01 14:01:56 | 2011-06-01 10:00:00
2011-06-01 14:02:32 | 2011-06-01 16:00:00
2011-06-01 14:03:08 | 2011-06-06 08:30:00
2011-06-01 14:03:39 | 2011-06-01 16:00:00
2011-06-01 14:04:15 | 2011-06-01 16:00:00
2011-06-01 14:24:52 | 2011-06-10 15:00:00
2011-06-01 14:46:06 | 2011-06-01 02:00:00
2011-06-01 14:52:34 | 2011-06-02 12:00:00
2011-06-01 15:05:49 | 2011-06-02 10:15:00
2011-06-01 15:25:59 | 2011-06-10 09:30:00
2011-06-01 15:37:57 | 2011-06-02 10:50:00
2011-06-01 15:57:37 | 2011-06-06 08:30:00
2011-06-01 16:26:15 | 2011-06-01 07:00:00
2011-06-01 16:27:02 | 2011-06-03 13:00:00
2011-06-01 16:27:31 | 2011-06-03 13:45:00
2011-06-01 16:39:13 | 2011-06-06 15:30:00
2011-06-01 16:43:45 | 2011-06-10 17:00:00
2011-06-01 16:56:24 | 2011-07-19 10:30:00
2011-06-01 17:06:59 | 2011-07-01 09:15:00
2011-06-02 13:00:00 | 2011-06-16 12:15:00
2011-06-01 17:16:40 | 2011-06-20 11:30:00
2011-06-01 18:43:51 | 2011-06-06 15:00:00
2011-06-01 18:49:37 | 2011-06-07 10:00:00
2011-06-01 19:07:01 | 2011-06-03 14:00:00
2011-06-02 13:00:00 | 2011-06-06 20:00:00
2011-06-01 19:44:13 | 2011-06-07 10:45:00
2011-06-01 19:55:55 | 2011-06-07 10:45:00
2011-06-02 13:00:00 | 2011-06-03 09:20:00
2011-06-02 13:00:00 | 2011-06-03 08:30:00
2011-06-02 13:00:00 | 2011-06-03 06:30:00
2011-06-01 22:33:24 | 2011-09-12 10:00:00
2011-06-02 08:24:35 | 2011-06-07 10:00:00
2011-06-02 13:00:00 | 2011-06-02 14:00:00
2011-06-02 08:51:41 | 2011-06-24 11:40:00
2011-06-02 08:52:37 | 2011-06-03 12:30:00
2011-06-02 08:53:51 | 2011-06-03 12:30:00
2011-06-02 08:56:02 | 2011-06-07 09:00:00
2011-06-02 08:59:13 | 2011-06-07 09:00:00
2011-06-02 09:03:04 | 2011-06-07 09:00:00
2011-06-02 13:00:00 | 2011-06-03 09:30:00
2011-06-02 09:22:30 | 2011-06-07 12:30:00
2011-06-02 13:00:00 | 2011-06-08 11:00:00
2011-06-02 13:00:00 | 2011-06-08 11:00:00
2011-06-02 13:00:00 | 2011-06-08 11:00:00
2011-06-02 13:00:00 | 2011-06-08 11:00:00
2011-06-02 13:00:00 | 2011-06-03 09:30:00
2011-06-02 13:00:00 | 2011-06-03 09:30:00
2011-06-02 13:00:00 | 2011-06-03 15:25:00
2011-06-02 13:00:00 | 2011-06-13 14:00:00
2011-06-02 13:00:00 | 2011-06-03 15:25:00
2011-06-02 10:00:25 | 2011-06-07 11:30:00
2011-06-02 10:02:39 | 2011-06-02 13:50:00
2011-06-02 10:03:14 | 2011-06-02 13:50:00
2011-06-02 10:14:16 | 2011-06-02 10:00:00
2011-06-02 10:14:57 | 2011-06-02 13:50:00
2011-06-02 10:15:45 | 2011-06-02 13:50:00
2011-06-02 10:22:06 | 2011-06-03 12:20:00
2011-06-02 10:23:20 | 2011-06-10 12:00:00
2011-06-02 10:23:23 | 2011-06-03 12:20:00
2011-06-02 10:24:33 | 2011-06-02 12:40:00
2011-06-02 10:28:59 | 2011-06-06 10:30:00
2011-06-02 10:29:09 | 2011-06-20 13:45:00
2011-06-02 10:31:34 | 2011-06-02 11:00:00
2011-06-02 10:35:30 | 2011-06-09 14:45:00
2011-06-02 10:40:44 | 2011-06-03 08:10:00
2011-06-02 10:42:19 | 2011-06-03 09:00:00
2011-06-02 10:43:56 | 2011-06-03 06:30:00
2011-06-02 10:45:32 | 2011-06-03 07:30:00
2011-06-02 10:46:43 | 2011-06-08 18:00:00
2011-06-02 11:03:10 | 2011-06-06 10:30:00
2011-06-02 11:05:52 | 2011-06-03 15:25:00
2011-06-02 11:07:26 | 2011-06-07 12:30:00
2011-06-02 11:24:06 | 2011-06-03 13:15:00
2011-06-02 11:30:31 | 2011-06-02 13:15:00
2011-06-02 11:54:41 | 2011-06-13 09:00:00
2011-06-02 12:23:41 | 2011-06-02 14:30:00
2011-06-02 12:33:06 | 2011-06-14 09:45:00
2011-06-02 12:38:40 | 2011-06-06 12:30:00
2011-06-02 12:39:48 | 2011-06-06 15:00:00
2011-06-02 12:40:43 | 2011-06-08 13:00:00
2011-06-02 12:41:44 | 2011-06-08 14:00:00
2011-06-02 12:48:50 | 2011-06-03 09:00:00
2011-06-02 12:51:56 | 2011-06-03 12:30:00
2011-06-02 12:53:26 | 2011-06-03 13:00:00
2011-06-02 13:13:48 | 2011-06-08 16:30:00
2011-06-02 13:20:11 | 2011-06-06 06:00:00
2011-06-02 13:23:46 | 2011-05-31 12:00:00
2011-06-02 13:24:40 | 2011-05-31 11:30:00
2011-06-02 13:25:25 | 2011-05-31 10:30:00
2011-06-02 13:50:51 | 2011-06-06 15:00:00
2011-06-02 14:13:40 | 2011-06-14 09:00:00
2011-06-02 14:23:08 | 2011-06-07 13:00:00
2011-06-02 14:30:41 | 2011-06-03 15:25:00
2011-06-02 14:31:02 | 2011-06-07 10:00:00
2011-06-02 14:36:22 | 2011-06-22 09:00:00
2011-06-02 14:48:31 | 2011-06-06 09:15:00
2011-06-02 15:01:34 | 2011-06-10 09:00:00
2011-06-02 15:13:29 | 2011-06-06 08:00:00
2011-06-02 15:15:44 | 2011-06-03 10:40:00
2011-06-02 15:29:53 | 2011-06-06 11:00:00
2011-06-02 15:31:25 | 2011-06-06 11:00:00
2011-06-02 15:36:10 | 2011-06-07 09:30:00
2011-06-02 15:40:55 | 2011-06-06 11:00:00
2011-06-02 15:53:10 | 2011-06-10 12:00:00
2011-06-02 15:59:15 | 2011-06-07 15:00:00
2011-06-02 16:09:29 | 2011-06-03 15:25:00
2011-06-02 16:12:14 | 2011-06-03 15:25:00
2011-06-02 16:12:42 | 2011-06-03 15:25:00
2011-06-02 16:13:42 | 2011-06-03 15:25:00
2011-06-02 16:16:55 | 2011-06-08 00:00:00
2011-06-02 16:26:55 | 2011-06-20 06:30:00
2011-06-02 16:44:14 | 2011-06-03 07:30:00
2011-06-02 16:50:42 | 2011-06-10 08:30:00
2011-06-02 16:55:54 | 2011-06-06 15:00:00
2011-06-02 16:55:58 | 2011-07-12 08:00:00
2011-06-02 16:59:15 | 2011-06-07 11:00:00
2011-06-02 17:04:46 | 2011-06-08 08:00:00
2011-06-02 17:06:28 | 2011-06-08 08:00:00
2011-06-02 17:30:35 | 2011-06-04 09:30:00
2011-06-03 13:00:00 | 2011-06-07 08:00:00
2011-06-03 13:00:00 | 2011-06-06 14:45:00
2011-06-03 13:00:00 | 2011-06-07 12:00:00
2011-06-03 13:00:00 | 2011-06-15 09:00:00
2011-06-02 19:42:11 | 2011-07-05 13:00:00
2011-06-02 22:18:55 | 2011-06-08 08:30:00
2011-06-02 23:49:52 | 2011-06-29 08:00:00
2011-06-03 13:00:00 | 2011-06-03 13:00:00
2011-06-03 13:00:00 | 2011-06-03 13:00:00
2011-06-03 13:00:00 | 2011-06-03 13:00:00
2011-06-03 13:00:00 | 2011-06-03 13:00:00
2011-06-03 13:00:00 | 2011-06-03 13:00:00
2011-06-03 13:00:00 | 2011-06-03 13:00:00
2011-06-03 13:00:00 | 2011-06-03 13:00:00
2011-06-03 13:00:00 | 2011-06-03 13:00:00
2011-06-03 13:00:00 | 2011-06-03 13:00:00
2011-06-03 13:00:00 | 2011-06-03 13:00:00
2011-06-03 09:15:29 | 2011-06-06 10:30:00
2011-06-03 09:22:27 | 2011-06-07 16:15:00
2011-06-03 09:26:27 | 2011-06-07 12:00:00
2011-06-03 09:36:03 | 2011-06-08 12:30:00
2011-06-03 09:38:38 | 2011-06-07 16:30:00
2011-06-03 09:39:01 | 2011-06-02 08:00:00
2011-06-03 09:40:56 | 2011-06-07 17:00:00
2011-06-03 09:48:50 | 2011-06-02 12:00:00
2011-06-03 10:01:17 | 2011-06-07 17:30:00
2011-06-03 10:06:37 | 2011-06-07 12:00:00
2011-06-03 10:12:13 | 2011-06-06 14:30:00
2011-06-03 10:25:38 | 2011-06-06 13:00:00
2011-06-03 10:29:09 | 2011-06-06 12:00:00
2011-06-03 10:31:01 | 2011-07-22 10:30:00
2011-06-03 10:33:34 | 2011-06-07 09:00:00
2011-06-03 10:36:59 | 2011-07-28 09:00:00
2011-06-03 10:54:36 | 2011-06-09 16:55:00
2011-06-03 10:56:14 | 2011-06-07 11:00:00
2011-06-03 10:57:23 | 2011-06-07 12:00:00
2011-06-03 10:58:35 | 2011-06-07 12:30:00
2011-06-03 10:59:35 | 2011-06-07 10:00:00
2011-06-03 11:10:48 | 2011-06-06 10:00:00
2011-06-03 11:16:30 | 2011-06-07 12:00:00
2011-06-03 11:19:57 | 2011-06-07 12:00:00
2011-06-03 11:27:49 | 2011-05-30 11:00:00
2011-06-03 11:28:19 | 2011-06-07 12:00:00
2011-06-03 11:30:38 | 2011-07-01 13:00:00
2011-06-03 11:42:57 | 2011-06-08 11:30:00
2011-06-03 11:49:13 | 2011-06-10 12:30:00
2011-06-03 11:59:15 | 2011-06-06 16:00:00
2011-06-03 12:02:06 | 2011-06-08 11:00:00
2011-06-03 12:04:39 | 2011-06-08 11:00:00
2011-06-03 12:06:06 | 2011-06-16 10:10:00
2011-06-03 12:08:11 | 2011-06-08 11:00:00
2011-06-03 12:09:50 | 2011-06-14 14:15:00
2011-06-03 12:11:39 | 2011-06-08 11:00:00
2011-06-03 12:13:22 | 2011-06-08 11:00:00
2011-06-03 12:14:37 | 2011-06-08 11:00:00
2011-06-03 12:16:30 | 2011-06-14 12:00:00
2011-06-03 12:20:08 | 2011-06-14 15:30:00
2011-06-03 12:26:43 | 2011-06-17 12:30:00
2011-06-03 12:50:13 | 2011-06-09 12:00:00
2011-06-03 12:50:55 | 2011-07-18 09:00:00
2011-06-03 12:51:12 | 2011-07-18 09:20:00
2011-06-03 12:53:41 | 2011-06-13 00:30:00
2011-06-03 12:59:26 | 2011-06-06 15:30:00
2011-06-03 13:01:32 | 2011-06-06 15:45:00
2011-06-03 13:02:31 | 2011-06-06 16:00:00
2011-06-03 13:03:17 | 2011-06-06 16:15:00
2011-06-03 13:07:05 | 2011-06-07 15:00:00
2011-06-03 13:22:33 | 2011-06-03 13:00:00
2011-06-03 14:30:56 | 2011-06-06 10:30:00
2011-06-03 14:33:25 | 2011-06-06 10:30:00
2011-06-03 14:50:04 | 2011-06-23 12:30:00
2011-06-03 14:50:21 | 2011-06-06 07:30:00
2011-06-03 15:01:46 | 2011-06-10 11:10:00
2011-06-03 15:04:34 | 2011-06-10 10:30:00
2011-06-03 15:50:22 | 2011-06-07 14:00:00
2011-06-03 15:58:58 | 2011-06-07 12:00:00
2011-06-03 16:06:02 | 2011-06-08 12:00:00
2011-06-03 16:11:43 | 2011-06-09 13:30:00
2011-06-03 16:21:02 | 2011-06-09 09:30:00
2011-06-03 16:35:23 | 2011-06-10 10:00:00
2011-06-06 13:00:00 | 2011-06-08 16:00:00
2011-06-06 13:00:00 | 2011-06-06 15:00:00
2011-06-03 20:05:03 | 2011-06-10 13:00:00
2011-06-03 20:08:44 | 2011-06-10 15:00:00