Thanks for the assist.
ShopLoadRG.baq (87.1 KB)
Took what you had and did a CTE to extract the hours and date from those strings. Attaching the BAQ to show the additions.
I didn’t refactor the query but you get the idea. Now I am going to create a summary layer, but that should be easy to do.