0

I am trying to find a formula to sum up some specific working hours. enter image description here enter image description here

From the first two sheets people can track when they work on a specific ID(Project) So you see that Lukas worked on ID 2 and Chinaedu on ID 5 on two different days.

enter image description here

In this sheet the working time on an ID should be calculated automatically just by putting the ID in the first column. That means that when you put an ID into the cell on the sheet UserStories, Excel should look for exactly this ID in column P of the other sheets and return the estimated time in sum and the date. Has anybody an idea which could help me along? Thanks in advance!

Chinaedu Onwukwe
  • 437
  • 1
  • 7
  • 20
  • What should happen if the ID belongs to a user story on which more than 1 person has worked? One row with total time without the person who did the work? Or row added for each additiontal person? – Peter Pesch Dec 06 '17 at 16:45
  • I would say: Write a vba sub which adds the row(s) to the UserStories sheet (preferably in a module you add to the workbook). And add an onChange-event on the UserStories sheet which calls that sub. – Peter Pesch Dec 06 '17 at 16:47
  • @PeterPesch a row should be added for each additional person – Chinaedu Onwukwe Dec 06 '17 at 18:20
  • An example for the onChange event can be found here: https://stackoverflow.com/questions/8494658/excel-onchange-event - In your case, you'll have to check whether the change took place in the first column. – Peter Pesch Dec 06 '17 at 18:53

0 Answers0