DAX shits minutes calculate - please read all -- 2

I have a statement sheet where there are for each machine start time and end time of the event.

I created two columns (for only hour) called Start and End

In PBI I created a Shift column to specify if the shift is Morning / Afternoon / Night.

However, there are rows where the statement starts in the morning and ends in the afternoon (e.g. row 159 - start 1:56 pm - end 2:15:59 pm).

I need to calculate the afternoon accrual minutes and the morning accrual minutes.

The shifts are:

morning 06.00 - 13.59

afternoon 14.00 - 21.59

night 22.00 - 05.59

The purpose is to figure out, for each type (code on type column) the minutes per shift morning, afternoon, night for each day. The ideal result is a table report with a day column, shift column, type column, minute column that should represent the sum of minutes for the type (e.g., type 1 - morning shift - sum of minutes of type 1 for that day for morning shift).

I provide xls file. I need the final powerbi file

Microsoft PowerBI Power BI

Proje NO: #37773420

Proje hakkında