I can quickly spot where the problem is:
it's not taking into account week 73 hours 8
Which shall be used in normalized week 25 (a representation of standard weeks 71.08 - 74).
so the condition in I2:
Formula: copy to clipboard
=SUMIFS(D:D,C:C,">"&H2,C:C,"<"&H3-1)

is too strong.
Seems that
Formula: copy to clipboard
=SUMIFS(D:D,C:C,">"&H2,C:C,"<="&H3-1)


Test it and observe if it behaves better