hours breakdown per interval

[Sopall4424]

hello,

I would like to create a report that shows the breakdown of working hours.

Let's say I have the following **bleep**f, from 7a to 4p, with one 15 minutes break between 9/9:15 , a lunch between 11:30 to 12:30 and a second break from 2P to 2:15, then work up to 4p.

for each 15 minutes interval , I would like to have 1 (if working) and 0 while on break/lunch.

is there a way to go this with power query ? BI

[edhans]

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.