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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!