Thank you Jacob and Kowser for the formulae you shared many years ago! The information you shared is almost exactly what I need to simplify a large task I have of keeping running totals of time spent on various projects by many students.
I have a follow-up question regarding this slightly-modified Google Sheet.
I have added a new column which is labeled "Project"
My goal is to see the sum of hours each person spent on each project. Thus, because John and Susan worked on three different projects, I would like to see the hours John spent working on Apple, Fruit, and Helium; and the hours Susan spent on Cantaloupe. I still need the hours the other people dedicated to their respective projects. Because they only worked on one project each, it seems easier. It would be great to have the name of each project visible with the totals. That should be easy to accomplish.
The data in the sheet will be ever-changing and populated from Google Forms entries. The number of rows will be over 6000 each year, thus your help is a significant time saver for me!
Thank you very much!