Quite difficult to define the logic with given information.
How many "Active" and "Not Active" are expected between Start and End?
If those are only one "Not active" and "two Active", the logic si relatively easy, but if those are really depends up to ie) 5 or so, we need have other "State" definition,
such as Active 1 & Not Active 1 etc,
Require some more details
1. From START to 1st ACTIVE what will be the status? ACTIVE or NOT ACTIVE?
2. FROM 2nd ACTIVE to END what will be the status? ACTIVE?
AS per my understanding
ACTIVE sec = (11:14:45 - 11:14:03) = 42 Sec
NOT ACTIVE sec= (11:14:48 - 11:14:45) = 3 Sec
ACTIVE sec = (11:14:45 - 11:14:03) = 42 Sec + (11:14:50 - 11:14:48) = 2 Sec
So the total ACTIVE sec = 44 sec
NOT ACTIVE sec= (11:14:48 - 11:14:45) = 3 Sec + (11:14:03 - 11:14:00) = 3 sec
So the total NOT ACTIVE sec = 06 sec
Please confirm if I am on right track.
There can be any number of ACTIVE and NOT ACTIVE states between Start Date and End Date.
In the above example. NOT ACTIVE will be (11:14:48 - 11:14:45) = 3 Sec
Rest everything will be under ACTIVE, that is the business logic being followed.