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

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