Spreadsheet: 130520d1322410923-sorting-data-of-date-time-format-and-filtering-for-count-duration-calculation-within-same-cell
Sheet: Sheet1

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