Hello and greetings.
I have a challenge with a calculation, which I hope can be simply overcome. I am creating a timesheet for three people. The columns headings are Date, Phase, Name, Description, Comment, Hours spent. I want to have some of this information automatically calculated in a small table, to show the progress for number of hours by each of us. I have uploaded a screenshot so you can see.
In a cell on the same sheet the calculation should work out if 'Name' is Joseph then calculate total 'Hours spent' for Joseph. I will then do the same with the other two names.
I am sure this is possible but I am having so much difficulty figuring it out.
Thank-you very much in advance for any help.
Joseph
Bookmarks