Extracting numbers from text in cell range and summing them up using SUMPRODUCT

Hello,

I'm trying to extract hours of education (i.e., 4.58, 2 and 3.5) from cells A2:A6 and add them up in one formula using SUMPRODUCT. I'd like to do all this in one cell only. If I use a helper column B then simple SUM or SUMPRODUCT are straightforward, giving a correct total of 10.08 hours in cell E1. However, if I omit the helper column B, I end up with just 4.58 hours (cell E2). For the life of me, I've not been able to determine how to incorporate the range A2:A6 into the SUMPRODUCT formula in E2 (see below).

=SUMPRODUCT(--(IFERROR(MID(A2:A6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2:A6&"0123456789")),LEN(A2:A6)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2:A6&"0123456789"))),0)))

Please see attached spreadsheet.

Any advice on how to resolve this is more than welcome.