Averaging across multiple ranges, not counting zeros, and the [h]:mm format

I am trying to get an average time in [h]:mm across multiple ranges (see attached sheet for example).
The B column is a result from another formula using an IFERROR function that results in a "-" if the result is #DIV/0!.

The formula I am currently using is
=SUM(B14,B22,B30,B38,B46)/COUNTIFS(B14,"<>0",B14,"<>#DIV/0!")+COUNTIFS(B22,"<>0",B22,"<>#DIV/0!")+COUNTIFS(B30,"<>0",B30,"<>#DIV/0!")+COUNTIFS(B38,"<>0",B38,"<>#DIV/0!")+COUNTIFS(B46,"<>0",B46,"<>#DIV/0!")
^^This is using just the average from each week, I have also used the range across all days (excluding the weekly average cell)

I don't know what I am doing wrong, the result should be 87:32 as the overall monthly average, but I keep getting 325:39

I appreciate any insight

I haven't opened your spreadsheet, but I believe your problem is that your denominator is just COUNTIFS(B14,"<>0",B14,"<>#DIV/0!"), when you want it to be all of the COUNTIFS. You need to wrap the entire denominator with parentheses.
=SUM(B14,B22,B30,B38,B46)/(COUNTIFS(B14,"<>0",B14,"<>#DIV/0!")+COUNTIFS(B22,"<>0",B22,"<>#DIV/0!")+COUNTIFS(B30,"<>0",B30,"<>#DIV/0!")+COUNTIFS(B38,"<>0",B38,"<>#DIV/0!")+COUNTIFS(B46,"<>0",B46,"<>#DIV/0!"))