I have two lists. A Task list (custom list, also works as a time sheet) and a Project list.
Example Task list:
Proj.no. (lookup from Project list), PlannedHourTask (numbers) and HoursWorkedTask (calculation from sublist). I also have a hidden column that is a copie of WorkedHoursTask (to be able to archive the tasks with hours worked).
Example Project list:
I want all hours worked (hours from task list) to be summarized in the project list under the right project no. Does anybody have any suggestion on solution?