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