Count time selected by year of date

  • Dear expert, To better monitor a work process I'm looking get a right formula. I try already a few weeks to create a formula that count a range of times in column B but selected by year witch is noted in column A by a date. so that I can see per year how much time is spent on certain activities. Unfortunately I am unable to formulate the correct formula.


    I have a date in column A.

    In column B the time

    In columns E3 and E4 I would like to see the result of the hours spent per year.


    Can someone give me some advice on how I can best achieve this?


    please see the attachment for a example