Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
spandita
Partner - Contributor
Partner - Contributor

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

Any lead can be helpful.

0 Replies