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