Consolidate data separately from multiple entries

I have an excel file that I use to record the numbers of hours spent by tradesman on each job. At the end of every week I have to generate a report that gives me the number of hours spent by a tradesman on each job. In the attached file it can be seen how I am recording the hours. In Columns I to V shows what I am trying to achieve. Is there a VBA code or a formula that can help me to consolidate the hours from each day as shown? I have tried using the Consolidate option in excel but by because I have to do it for all the tradesman it becomes a very long procedure.

Untitled.jpg


Thanks a lot

Thanks for instant reply Alan. Your formula works for sure. However according to this formula I have to select the Job# manually. Because the Job#s will be different all the time I was looking for a solution where excel automatically consolidates it.

Does the magic. Thanks a lot mate.