How to split time by a setted date?

[Romney]

Hi,
I have a lot of remote camera data, and I would like to calculate the working hours of each camera in each season.

I divide a year into two seasons: the breeding season (Apr - Aug), and the non-breeding season (Sep - Mar).

Column J (Working hours) shows the total working hours, which are calculated by (F2-D2)*24+(G2-E2).

Here is the problem. Some cameras work across two seasons, such as from June to December, while some don't. In order to separate the total working hours for breeding and non-breeding season, I have to manually pick out the cameras with problems and then cut the working hour by the date "2016/9/1 00:00:00".

It will be very time-consuming because I have 700+ data. Is there any smarter method than what I did below?

Thanks a lot,
A helpless graduate student

 

[BSALV]

in row1 the start of every season, so 1 april and 1 septembre at 00:00:00.
There is a small difference in hours, your or my mistake ?

Map1
	A	B	C	D	E	F	G	H	I	J	K
1				start --->	2016/04/01	2016/09/01	2017/04/01	2017/09/01	2018/04/01	total	total
2	start		end		breed	no breed	breed	no breed
3	2016/06/03	4:37:48	2016/12/31	11:59:00	2155:22	2915:59	00:00	00:00		5071:21	5071,35
4	2016/07/24	6:21:40	2016/11/15	5:01:02	929:38	1805:01	00:00	00:00		2734:39	2734,66
5	2016/07/25	9:35:54	2016/09/15	5:01:03	902:24	341:01	00:00	00:00		1243:25	1243,42
6	2016/04/01		2018/04/01		3672:00	5088:00	3672:00	5088:00		17520:00	17520,00
Blad1

Cell Formulas
Range	Formula
E3:H6	E3	=MAX(0,MIN(F$1,$D3+$C3)-MAX($A3+$B3,E$1))
J3:J6	J3	=SUM(E3:H3)
K3:K6	K3	=+J3*24