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