Sumproduct, extract numbers within text

Hi,

I receive an automatic dump of data on a weekly basis that looks like the below Table A. Basically, the first column is by category and the remaining columns are by week. How would I sum the hours (found within the text) into Table B, which would summarize it by category (A,B,C) and Type (Submitted, Approval, Invoice, etc)? Any help would be highly appreciated. I've taken a stab at this but just can't figure it out. I've attached an excel file with the yellow highlights in table B showing the final results I'm looking for.


Screenshot 2018-08-28 at 20.27.42.png