Formula Help with overlapping times

[yessir]

I am trying to find a formula that would help me find how many cars overlap and are in the lot at the same time but only when column D is False. I would then want to count how many cars are in the lot at the same time. The start times are located in B2:B7 and end times are in C2:C7. I've tried using a SUMPRODUCT function but was wondering if there was an easier way to go about this and include the function to count the number of cars that overlap.
A B C D

Arvl Lot Location	Arvl Time	Dept Time	Is Overnight
xxx	15:25	16:10	FALSE
xxx	21:10	22:15	FALSE
xxx	8:21	9:19	FALSE
xxx	11:08	11:45	FALSE
xxx	14:29	15:15	FALSE
xxx	19:55	21:20	FALSE

<tbody>
</tbody>

 

[Marcelo Branco]

My last attempt...

A possible solution using helper columns

	A​	B​	C​	D​	E​	F​	G​
1​	Arvl Place​	Arvl Time​	Dept Time​	Helper1​	Helper2​	Is Overnight​	Num of Overlaps​
2​	jjj​	20:09​	06:33​	20,15​	30,55​	TRUE​	0​
3​	jjj	11:05​	12:03​	11,08​	12,05​	FALSE​	4​
4​	jjj​	09:26​	10:16​	9,43​	10,27​	FALSE​	2​
5​	jjj​	23:52​	01:15​	23,87​	25,25​	FALSE​	0​
6​	jjj​	15:13​	16:03​	15,22​	16,05​	FALSE​	2​
7​	jjj​	22:02​	05:00​	22,03​	29,00​	TRUE​	0​
8​	jjj​	18:26​	06:45​	18,43​	30,75​	TRUE​	0​
9​	jjj​	20:06​	06:00​	20,10​	30,00​	TRUE​	0​
10​	jjj​	15:51​	16:41​	15,85​	16,68​	FALSE​	3​
11​	jjj​	11:52​	12:48​	11,87​	12,80​	FALSE​	3​
12​	jjj​	08:03​	08:53​	8,05​	8,88​	FALSE​	0​
13​	jjj​	13:30​	14:20​	13,50​	14,33​	FALSE​	3​
14​	jjj​	17:52​	18:42​	17,87​	18,70​	FALSE​	2​
15​	jjj​	10:02​	10:47​	10,03​	10,78​	FALSE​	3​
16​	jjj​	18:28​	19:40​	18,47​	19,67​	FALSE​	2​
17​	jjj	22:55​	06:00​	22,92​	30,00​	TRUE​	0​
18​	jjj​	13:39​	14:21​	13,65​	14,35​	FALSE​	3​
19​	jjj​	19:03​	19:45​	19,05​	19,75​	FALSE​	1​
20​	jjj​	09:31​	10:21​	9,52​	10,35​	FALSE​	2​
21​	jjj​	22:28​	23:24​	22,47​	23,40​	FALSE​	0​
22​	jjj​	22:27​	12:28​	22,45​	36,47​	TRUE​	0​
23​	jjj​	13:33​	14:18​	13,55​	14,30​	FALSE​	3​
24​	jjj​	15:59​	17:20​	15,98​	17,33​	FALSE​	3​
25​	jjj​	11:48​	12:28​	11,80​	12,47​	FALSE​	3​
26​	jjj​	10:47​	11:37​	10,78​	11,62​	FALSE​	3​
27​	jjj​	13:59​	15:00​	13,98​	15,00​	FALSE​	3​
28​	jjj​	16:38​	18:00​	16,63​	18,00​	FALSE​	3​
29​	jjj​	22:04​	07:55​	22,07​	31,92​	TRUE​	0​
30​	jjj	11:13​	11:58​	11,22​	11,97​	FALSE​	4​

<tbody>
</tbody>

Helper1
Formula in D2 copied down
=B2*24
Format as Number with 2 decimal places

Helper2
Formula in E2 copied down
=(C2+(B2>C2))*24
Format as Number with 2 decimal places

Formula in G2 copied down
=IF(F2=FALSE,SUMPRODUCT(--(ROW(A$2:A$400)<>ROW(A2)),--(A$2:A$400=A2),--(A$2:A$400<>""),--(F$2:F$400=FALSE),1-((D2>E$2:E$400)+(D$2:D$400>E2))),0)

M.

 

[yessir]

It worked great, if i might ask. What was your reasoning when creating the helper columns.

 

[Marcelo Branco]

It worked great, if i might ask. What was your reasoning when creating the helper columns.

To adjust the value of column C by adding 1 (24 hours) because it is on the next day when it is less than the value of column B.

M.