Computing an hour breakdown

In the case of an event that starts and stops on the same day, it is sometimes useful to understand how many minutes within each hour of the day that event consumed. This recipe demonstrates how to break down an event into the minutes consumed during each hour that an event spans.

Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Create a table called R02_Table using an Enter Data query with the following data:

ID	Date	Start	End
1	1/1/2019	8:00:00 AM	9:24:00 AM
1	1/2/2019	5:24:00 AM	9:14:00 PM
2	1/1/2019	9:59:00 AM	4:13:00 PM
2	1/2/2019	3:31:00 AM	12:01:00 PM
3	1/1/2019	8:24:00 AM	8:55:00 AM

3. Create...