I’m currently trying to make a solution that allows my team to submit how many hours they’ve worked on a project into a table called ‘Hours’.
I have another table called ‘Team’ that lists the members of my organisation and links to the ‘Hours’ table through the name of the team member.
By calculating the difference between start and end time I can calculate the number of hours completed for each ‘Hours’ record.
Now I would like to have a column on the ‘Team’ table that calculates the total number of hours for each respective member. I have started by creating a linked record called hours which lists all the ‘Hours’ records associated with the team member but I am not sure how to derive the total of these records.
I’ve tried the roundup function but it continually gives me errors so I’m not sure what I’m doing wrong since this seems like very basic functionality.
Any help would be greatly appreciated