Hi guys,
I'm struggling with formula, which will count the number of operations "name" did simultaneously, even partially.
I'd like to have a 1 or 0 information in new column (1 = the time interval exist, even partially, anywhere else).
Data looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]name[/TD]
[TD]start[/TD]
[TD]end[/TD]
[/TR]
[TR]
[TD]Mark
[/TD]
[TD]01.06.2019 0:22:33[/TD]
[TD]01.06.2019 4:36:26[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]01.06.2019 23:54:17[/TD]
[TD]02.06.2019 2:40:11[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]01.06.2019 0:15:36[/TD]
[TD]01.06.2019 0:44:27[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]01.06.2019 0:44:36[/TD]
[TD]01.06.2019 1:04:08[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]01.06.2019 1:07:41[/TD]
[TD]01.06.2019 1:08:44[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]02.06.2019 0:55:30[/TD]
[TD]02.06.2019 1:28:06[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]02.06.2019 1:12:40[/TD]
[TD]02.06.2019 1:32:34[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]02.06.2019 4:38:56[/TD]
[TD]02.06.2019 5:05:53[/TD]
[/TR]
</tbody>[/TABLE]
e.g. first and third row should have "1", because Mark was working on two different things for a while. Last row should be 0, Mark did no other operation at that time.
Thanks in advance for any help.
Josef
I'm struggling with formula, which will count the number of operations "name" did simultaneously, even partially.
I'd like to have a 1 or 0 information in new column (1 = the time interval exist, even partially, anywhere else).
Data looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]name[/TD]
[TD]start[/TD]
[TD]end[/TD]
[/TR]
[TR]
[TD]Mark
[/TD]
[TD]01.06.2019 0:22:33[/TD]
[TD]01.06.2019 4:36:26[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]01.06.2019 23:54:17[/TD]
[TD]02.06.2019 2:40:11[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]01.06.2019 0:15:36[/TD]
[TD]01.06.2019 0:44:27[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]01.06.2019 0:44:36[/TD]
[TD]01.06.2019 1:04:08[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]01.06.2019 1:07:41[/TD]
[TD]01.06.2019 1:08:44[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]02.06.2019 0:55:30[/TD]
[TD]02.06.2019 1:28:06[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]02.06.2019 1:12:40[/TD]
[TD]02.06.2019 1:32:34[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]02.06.2019 4:38:56[/TD]
[TD]02.06.2019 5:05:53[/TD]
[/TR]
</tbody>[/TABLE]
e.g. first and third row should have "1", because Mark was working on two different things for a while. Last row should be 0, Mark did no other operation at that time.
Thanks in advance for any help.
Josef