Need to bucket utilisation minutes into various hour slots

[Anonymous]

HI,

Thanks for help in advance

I have a table which has utilization of People, It has start time, end time and difference of both in Minutes (See table_1)

Now, I need to bucket the number of minutes utilized hourly basis (See table_2)

We take Record 1, start time is 9:00 Hours, so we put 60 Minutes in this bucket and next bucket remaining 15 minutes. 

I'm not sure how it can be achieved in Powerbi or infact in Excel as well. Any help is appreciated.

Thanks, Karan.

[amitchandak]

@Anonymous , Very similar example here

https://community.powerbi.com/t5/Desktop/Split-duration-by-hour-of-day/td-p/577543

In place of numeric hours series you can use time table(Create Hourly):

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

[Anonymous]

Hi @amitchandak - Thanks for your help!

I tried this solution but unfortunately, it is not working or may be it is not the exact solution, I'm looking at

The reason is every record of mine, can have multiple time slot hours where as in the solution, it seems to take start hour and tag Minutes for it.

Example, Start time is 01 Oct 2020 14:00 Hours, End Time is 01 Oct 2020 16:30 Hours. For one record of the above, I need 3 entries

1. 1400 Hours bucket 60 Minutes

2. 1500 Hours bucket 60 Minutes

3. 1600 Hours bucket 30 Minutes

Thanks in advance.