Hello @warper2000, I am not entirely sure I understand the output you are expecting in this pivot table. Are you wanting it to show 5 mins for in the work hours column for each set of 5 minutes in the interval column?
I think it would make it easier to assist you if you are able to provide more information about the values you want displayed in the pivot table and create a demo analysis in Quick Sight Arena. If you share that analysis with me, it will allow me to test some possible solutions and see the issue you are facing.
Thank you!