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 QuickSight 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!