declare @t table
(
state_name nvarchar(100),
team_id int,
dt datetime
);

insert into @t (state_name,team_id, dt)
values
('запуск' , 1, convert(datetime, '11.02.2018 6:10' , 104)),
('простой', 1, convert(datetime, '11.02.2018 9:40' , 104)),
('запуск' , 1, convert(datetime, '11.02.2018 9:55' , 104)),
('простой', 1, convert(datetime, '11.02.2018 13:30', 104)),
('запуск' , 1, convert(datetime, '11.02.2018 14:10', 104)),
('простой', 1, convert(datetime, '11.02.2018 23:12', 104)),
('запуск' , 1, convert(datetime, '12.02.2018 6:05' , 104)),
('простой', 1, convert(datetime, '12.02.2018 8:30' , 104)),
('запуск' , 1, convert(datetime, '12.02.2018 8:55' , 104)),
('простой', 1, convert(datetime, '12.02.2018 12:20', 104)),
('запуск' , 1, convert(datetime, '12.02.2018 15:50', 104)),
('простой', 1, convert(datetime, '12.02.2018 23:58', 104));

with periods as (
select *, lead(dt) over (partition by team_id order by dt) as dt_to
from @t),
calendar as 
(
select cast('20180211 06:00' as datetime) as dt, cast('20180211 06:30' as datetime) as dt_to
union all
select  dateadd(mi, 30, dt) as dt, dateadd(mi, 30, dt_to) as dt_to 
from    calendar
where   dateadd(mi, 30, dt) < '20180212'
)
select c.dt, sum(datediff(mi, iif(c.dt > p.dt, c.dt, p.dt), iif(c.dt_to > p.dt_to, p.dt_to, c.dt_to)))
from calendar c
        left  join periods p
                on state_name = 'запуск' 
                and p.dt < c.dt_to 
                and p.dt_to > c.dt
group by c.dt

declare @t table
(
ID int identity(1,1),
state_name nvarchar(100),
team_id int,
dt datetime
);

insert into @t (state_name,team_id, dt)
values
('запуск' , 1, convert(datetime, '05.08.2019 6:10' , 104)),
('останов', 1, convert(datetime, '05.08.2019 9:40' , 104)),
('запуск' , 1, convert(datetime, '05.08.2019 9:55' , 104)),
('останов', 1, convert(datetime, '05.08.2019 13:30', 104)),
('запуск' , 1, convert(datetime, '05.08.2019 14:10', 104)),
('останов', 1, convert(datetime, '05.08.2019 23:12', 104)),
('запуск' , 1, convert(datetime, '06.08.2019 6:05' , 104)),
('останов', 1, convert(datetime, '06.08.2019 8:30' , 104)),
('запуск' , 1, convert(datetime, '06.08.2019 8:55' , 104)),
('останов', 1, convert(datetime, '06.08.2019 12:20', 104)),
('запуск' , 1, convert(datetime, '06.08.2019 15:50', 104)),
('останов', 1, convert(datetime, '06.08.2019 23:58', 104));

select t1.ID
      ,datediff(minute, t1.dt, isnull(t2.dt, cast(cast(getdate()+1 as date) as datetime))) as 'время работы'
	  ,t1.dt as 'запуск'
	  ,isnull(t2.dt, cast(cast(getdate()+1 as date) as datetime)) as 'останов'
from @t t1
left join @t t2
  on t1.ID = t2.ID - 1