Does this look about right to you?
Link to base
If so, the idea is to use a formula field to "group" the records, and in the example above I grouped it by the week number of the year. (You'd probably want to use the week number of the year + the actual year, so "10 2024" or something, or maybe something more human readable like a start date to end date?)
Then use an automation to paste the value from that field into a linked field to another table, then you can use a rollup to grab the hours from that week and display it like I did in the Interface, does that make sense?