Quote:
Originally Posted by EldrickOnIce
Wow I am no good at excel. I want to do something pretty simple i think, but maybe not and regardless, I have no idea how to do it.
I have several tasks that will regularly take place: task1, task2, task3,...
These tasks will alternate in the same 'activity' column (column B)
Each of these tasks will take a varying amount of 'time', and that be recorded next to the activity in column C.
Can I have excel automatically calculate the total hours spent on each specific activity?
thanks
|
If I understand your problem correctly, sounds like the SUMIFS function.
https://support.office.com/en-us/art...6-611cebce642b
=SUMIFS(C1:C100, B1:B100, "=task1")
for example would add up all the values in column C where column B is "task1"
You can also alternatively use pivot tables as a quick solution too.