Reply to thread

Message: [QUOTE="Ber, post: 3772185"] Is it possible to work out from this data how many extension Nos are on a call at the same time on the same date. This is just a sample the entire sheet covers a full year of calls with almost 8000 rows of data. Thank You. A B C D E Ext NO Date (dd/MM/yyyy) Start Time Duration End Time 3224 01/11/2007 08:47:00 0:00:28 08:47:28 3336 01/11/2007 09:25:00 0:00:34 09:25:34 3219 01/11/2007 09:51:00 0:00:33 09:51:33 3278 01/11/2007 10:07:00 0:00:25 10:07:25 3016 01/11/2007 10:19:00 0:00:50 10:19:50 3161 01/11/2007 10:32:00 0:00:00 10:32:00 3161 01/11/2007 10:37:00 0:00:00 10:37:00 3311 01/11/2007 11:48:00 0:00:03 11:48:03 3318 01/11/2007 11:54:00 0:00:04 11:54:04 3133 01/11/2007 12:11:00 0:00:37 12:11:37 3318 01/11/2007 12:22:00 0:00:21 12:22:21 3133 01/11/2007 12:23:00 0:00:00 12:23:00 3133 01/11/2007 12:27:00 0:00:04 12:27:04 3133 01/11/2007 12:29:00 0:01:59 12:30:59 3133 01/11/2007 14:25:00 0:00:53 14:25:53 3380 01/11/2007 14:58:00 0:00:16 14:58:16 3333 01/11/2007 15:10:00 0:03:05 15:13:05 3380 01/11/2007 15:12:00 0:00:26 15:12:26 3133 01/11/2007 16:28:00 0:03:42 16:31:42 3133 01/11/2007 17:02:00 0:03:59 17:05:59 3311 02/11/2007 09:24:00 0:00:05 09:24:05 3311 02/11/2007 09:33:00 0:00:05 09:33:05 3380 02/11/2007 10:26:00 0:00:48 10:26:48 3299 02/11/2007 11:17:00 0:01:22 11:18:22 3314 02/11/2007 11:22:00 0:00:30 11:22:30 3016 02/11/2007 11:55:00 0:00:14 11:55:14 3133 02/11/2007 12:01:00 0:03:46 12:04:46 3278 02/11/2007 12:16:00 0:01:06 12:17:06 3258 02/11/2007 12:19:00 0:00:22 12:19:22 3133 02/11/2007 12:37:00 0:00:21 12:37:21 3294 02/11/2007 14:25:00 0:00:04 14:25:04 [/QUOTE]

Verification