Return the multiplying hours and values with duration associated to each tradesmen

Hi,

Required a formula help to Return the multiplying hours and values with duration associated to each tradesmen (Column J to L) in the assigned work as based the situated data in (Column B to F) having a headers like (Duration days) and trades of various tradesmen’s.

Steps of calculation like firstly calculate the total hours of each and every worker as per their trades with work planned duration days (first header of table) return the same values in Column K as per tradesmen, and for getting total amount in Column L as per result of total hours to be multiply each tradesmen with the Production Rate Per Hour (Row:5).


Sample sheet with expected results are attached


Thanks,