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,

Many thanks Shareez Saleem for your help

Thanks a lot Bo_ry for your formula solution

J6 cell , array formula , drag down

HTML Code: 

K6 cell , array formula , drag down

HTML Code: 

Thank you wk9128 for the formula solution

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'.