with t as (
select 'Stax' fio,to_date('01.01.2016 08:00','dd.mm.yyyy hh24:mi') dt_input,to_date('01.01.2016 20:00','dd.mm.yyyy hh24:mi') dt_output from dual union all
select 'Stax',to_date('02.01.2016 09:00','dd.mm.yyyy hh24:mi'),to_date('02.01.2016 16:00','dd.mm.yyyy hh24:mi') from dual union all
select 'Stax',to_date('01.02.2016 13:30','dd.mm.yyyy hh24:mi'),to_date('01.02.2016 21:00','dd.mm.yyyy hh24:mi') from dual union all
select 'Stax',to_date('02.02.2016 15:00','dd.mm.yyyy hh24:mi'),to_date('02.02.2016 16:00','dd.mm.yyyy hh24:mi') from dual union all
select 'Stax',to_date('03.02.2016 09:00','dd.mm.yyyy hh24:mi'),to_date('03.02.2016 13:40','dd.mm.yyyy hh24:mi') from dual union all
select 'Stax',to_date('04.02.2016 08:00','dd.mm.yyyy hh24:mi'),to_date('04.02.2016 08:20','dd.mm.yyyy hh24:mi') from dual union all
select 'Stax',to_date('05.02.2016 13:10','dd.mm.yyyy hh24:mi'),to_date('05.02.2016 13:40','dd.mm.yyyy hh24:mi') from dual union all
select 'Stax',to_date('06.02.2016 10:10','dd.mm.yyyy hh24:mi'),to_date('06.02.2016 11:00','dd.mm.yyyy hh24:mi') from dual union all
select 'Stax',to_date('06.02.2016 18:10','dd.mm.yyyy hh24:mi'),to_date('06.02.2016 21:00','dd.mm.yyyy hh24:mi') from dual union all
select 'Bugr',to_date('01.02.2016 08:30','dd.mm.yyyy hh24:mi'),to_date('01.02.2016 18:00','dd.mm.yyyy hh24:mi') from dual 
)
, tt as(
select 
  fio,dt_input,dt_output
 ,case
   when to_char(dt_input,'hh24miss')<'090000' then trunc(dt_input)+9/24                      --прийшов зарано
   when to_char(dt_input,'hh24miss') between'130000' and '140000' then trunc(dt_input)+13/24 --прийшов в обід
   when to_char(dt_input,'hh24miss') between'140000' and '180000' then dt_input-1/24         --прийшов після обіду
   when to_char(dt_input,'hh24miss') > '180000' then trunc(dt_input)+17/24                   --прийшов після роботи
   else dt_input
   end dt_i
 ,case
   when to_char(dt_output,'hh24miss')<'090000' then trunc(dt_output)+10/24                     --пішов зарано
   when to_char(dt_output,'hh24miss') between'130000' and '140000' then trunc(dt_output)+14/24 --пішов в обід
   when to_char(dt_output,'hh24miss') between'090000' and '130000' then dt_output+1/24         --пішов до обіду
   when to_char(dt_output,'hh24miss') > '180000' then trunc(dt_output)+18/24                   --пішов після роботи
   else dt_output
   end dt_o
 , 1 / (case when dt_input<dt_output and trunc(dt_input)=trunc(dt_output) then 1 else 0 end) err
 from t
)
select 
  fio,to_char(dt_input,'yyyy') yy,to_char(dt_input,'WW') ww 
--,tt.*
 ,sum(dt_o-dt_i-1/24) work
 ,max(err) eff
from tt
group by 
 fio,to_char(dt_input,'yyyy'),to_char(dt_input,'WW')
order by 1,2,3
SQL> /

FIO  YY   WW       WORK        EFF
---- ---- -- ---------- ----------
Bugr 2016 05     0.3333          1
Stax 2016 01     0.5833          1
Stax 2016 05     0.3750          1
Stax 2016 06     0.0347          1