number of concurrent calls

[tagteam3283]

hi guys,

New to the forum. However been referring to this forum from general google searches for years now.

Seems today im at an impasse for a new problems which is quite specific. I've no doubt heads will be scratching.

I need to be a manner in which I can determine the number of concurrent calls ongoing when a new call is initiated: concurrent - how many active calls are ongoing:

hopefully you can make sense of this example data. I would like to auto-calc the last column instead of visually checking how many calls are active

[TABLE="width: 576"]
<tbody>[TR]
[TD]Start Date
[/TD]
[TD]Start Time
[/TD]
[TD]Duration
[/TD]
[TD]End Time [Start Time+Duration]
[/TD]
[TD]Manual Calc - Active calls
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]16:18:39
[/TD]
[TD]00:00:04
[/TD]
[TD]16:18:43
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]16:52:10
[/TD]
[TD]00:00:05
[/TD]
[TD]16:52:15
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]16:55:25
[/TD]
[TD]00:00:02
[/TD]
[TD]16:55:27
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:07:07
[/TD]
[TD]00:00:04
[/TD]
[TD]17:07:11
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:18:11
[/TD]
[TD]00:04:17
[/TD]
[TD]17:22:28
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:18:46
[/TD]
[TD]00:09:48
[/TD]
[TD]17:28:34
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:19:07
[/TD]
[TD]00:09:47
[/TD]
[TD]17:28:54
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:26:16
[/TD]
[TD]00:01:40
[/TD]
[TD]17:27:56
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:30:49
[/TD]
[TD]00:00:15
[/TD]
[TD]17:31:04
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:31:59
[/TD]
[TD]00:00:12
[/TD]
[TD]17:32:11
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:33:06
[/TD]
[TD]00:03:45
[/TD]
[TD]17:36:51
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:44:19
[/TD]
[TD]00:03:53
[/TD]
[TD]17:48:12
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:48:22
[/TD]
[TD]00:03:52
[/TD]
[TD]17:52:14
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:48:22
[/TD]
[TD]00:05:03
[/TD]
[TD]17:53:25
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:48:22
[/TD]
[TD]00:03:54
[/TD]
[TD]17:52:16
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:48:22
[/TD]
[TD]00:04:21
[/TD]
[TD]17:52:43
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:48:29
[/TD]
[TD]00:09:48
[/TD]
[TD]17:58:17
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:49:14
[/TD]
[TD]00:09:48
[/TD]
[TD]17:59:02
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:49:15
[/TD]
[TD]00:09:49
[/TD]
[TD]17:59:04
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:54:30
[/TD]
[TD]00:08:14
[/TD]
[TD]18:02:44
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:54:30
[/TD]
[TD]00:08:12
[/TD]
[TD]18:02:42
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:54:30
[/TD]
[TD]00:08:13
[/TD]
[TD]18:02:43
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]17:54:31
[/TD]
[TD]00:08:14
[/TD]
[TD]18:02:45
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:00:45
[/TD]
[TD]00:08:02
[/TD]
[TD]18:08:47
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:00:46
[/TD]
[TD]00:08:03
[/TD]
[TD]18:08:49
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:00:46
[/TD]
[TD]00:08:02
[/TD]
[TD]18:08:48
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:03:08
[/TD]
[TD]00:05:43
[/TD]
[TD]18:08:51
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:03:08
[/TD]
[TD]00:05:45
[/TD]
[TD]18:08:53
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:03:08
[/TD]
[TD]00:05:44
[/TD]
[TD]18:08:52
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:03:09
[/TD]
[TD]00:05:45
[/TD]
[TD]18:08:54
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:09:16
[/TD]
[TD]00:05:40
[/TD]
[TD]18:14:56
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:09:16
[/TD]
[TD]00:05:35
[/TD]
[TD]18:14:51
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:09:16
[/TD]
[TD]00:02:25
[/TD]
[TD]18:11:41
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:09:16
[/TD]
[TD]00:05:36
[/TD]
[TD]18:14:52
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:09:17
[/TD]
[TD]00:05:37
[/TD]
[TD]18:14:54
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:09:17
[/TD]
[TD]00:05:41
[/TD]
[TD]18:14:58
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]04/03/2017
[/TD]
[TD]18:09:21
[/TD]
[TD]00:05:38
[/TD]
[TD]18:14:59
[/TD]
[TD]7
[/TD]
[/TR]
</tbody>[/TABLE]

thanks in advance
tagteam

 

[Marcelo Branco]

What you mean by it's not working? An error, wrong results, ....?
Would be helpful if you provide a data sample along with expected results where the formula doesn't work.

M.

 

[tagteam3283]

Correction - it does

this one isnt working

 

[Marcelo Branco]

Correction - it does

Ok

M.

 

[electron]

Hi everyone,

Two questions regarding this particular topic:
1. Imagining that there was an additional column called "ID" or "Item" (identifying the call, like a sequential number, i.e. 1, 2, 3, 4, 5). Would it be possible to identify which call is concurrent with? For example Call #1 with Call #3 and Call #5.
2. Would it be also possible to quantify that concurrency? Taken my example above: Call #1 (Call #3, 1 min; Call #5, 3 min)?

Thanks