when I have more time, but the immediate thing I notice is that the cell you refer to is NOT formatted [h]:mm
I guess that's an error?
I'm not certain what you mean by;
"I need to calculate an exact 48 week average over 17 weeks"
Can you spell out, very clearly what you mean by that, please.