Hello everyone
I have a problem that I can’t solve. It’s about calculating working hours per week. On one table I have the column “Hours per week” in which the total hours worked during the week are entered, for example, hours should be 40. On another table I have the columns “Week, start time, end time, total hours, plus minus hours”. The hours worked should be added up per week and subtracted from the target hours “40” in order to display the minus or plus hours in the column “Plus minus hours”. I’ve tried many different ways but it just doesn’t work. Can someone help me and give me an explanation?
Many thanks