SQL & PL/SQL

Hi,

From a start_time and duration (in minutes), I've tried to split the total time into hourly intervals but don't really know how to do it.

Here's a sample table script and a to-do-query output:

CREATE TABLE timetest (id number, start_time date, duration number);

INSERT INTO timetest (id,start_time,duration) VALUES (1,to_date('06/01/2016 12:00:00','dd/mm/yyyy hh24:mi:ss'),30);

INSERT INTO timetest (id,start_time,duration) VALUES (1,to_date('06/01/2016 12:40:00','dd/mm/yyyy hh24:mi:ss'),70);

INSERT INTO timetest (id,start_time,duration) VALUES (1,to_date('07/01/2016 16:00:00','dd/mm/yyyy hh24:mi:ss'),150);

INSERT INTO timetest (id,start_time,duration) VALUES (2,to_date('06/01/2016 10:30:00','dd/mm/yyyy hh24:mi:ss'),240);

INSERT INTO timetest (id,start_time,duration) VALUES (2,to_date('06/01/2016 12:50:00','dd/mm/yyyy hh24:mi:ss'),5);

INSERT INTO timetest (id,start_time,duration) VALUES (2,to_date('06/01/2016 14:10:55','dd/mm/yyyy hh24:mi:ss'),60);

TABLE:

EXPECTED OUTPUT SAMPLE: