Show task execution time within a specified time band
I want to get a output table as attached here. First horizontal row shows some time intervals of 15 minutes.
second row will be merged cells for each task according to their start time and end time.
(e.g if the start time is 12.15 AM and end time is 12.25 AM, then the cells showing 00.00-00.15,00.15-0030 will be merged for that particular task.and value will be shown as the time difference of start time and end time.
I have Data set ,that contains date of task execution, task name, start time, end time, execution time.
I have tried using intervalmatch(),interval() for defining the time frames.Bt not able to achieve this. Please advise