Total hours by name from exported data

So it looks like your taking the data and need to get total hours for each person.

The source data isnt arranged well. You can either arrange it into a more tabular form or get just that information from it as is.

If you take the effort to get the data into a tabular format, it will give you the flexibility of doing stuff like creating a pivot table from it, sorting/filtering and further breaking down the data. Otherwise with a couple manual steps you can get the unique names from column E and then using formulas get the totals you desire.

So manually I would copy the list of names in column E to another area/sheet and then with that range highlighted use Data | Remove Duplicates to eliminate duplicate names. Id then remove any blanks in the list of names I just created. You should then be able to use a SUMIF formula using the new unique names list as your criteria and having it look at E through I and summing the values in I for that name.

Getting it to a tabular format you would want the names to repeat each row so that each row represents a single record and remove the existing subtotal rows and "-----" rows. You could then use that range as the source of a pivot table (to show total hours by name) and/or sort/filter the list itself.

I didnt suggest you change it at the source. I suggested after you get it you take the steps I outlined to get it into a usable format.

Did you try the manual steps I provided?

It's possible to do it automatically but as I said above - with PowerQuery
maybe someone else will give you formula or VBA solution

btw. in the name column "empty" rows has spaces so they are not empty
and MARCO SARMIENTO doesn't exist in your source range so your result is incorrect

Are you importing to new workbooks each time or is it the same one (on the same or different sheets)? Does the data start in column A?