I want to add the hours of a person on the same day in the auxiliary column

1

I want to add the hours of a person on the same day in the auxiliary column
Because if a person exceeds more than 8 hours a day I have to put the red background of those rows
Does anyone know a way? I have tried many formulas but it gives me 0

image
image1312×289 25.1 KB

2

To add the hours of a person on the same day you can follow these steps:

  1. Create a table that includes a column for the person’s name, the date of the workday, and a column for the hours worked.

  2. In the same table, create an auxiliary column by clicking on the “Add Column” button and selecting “Formula”.

  3. In the formula column, type the following formula: =Sum([Hours Worked]). This formula will add up all the hours worked by the person on the same day.

  4. Make sure that the formula references the correct columns for the person’s name and the date of the workday. For example, if the person’s name is in column A and the date is in column B, the formula should look like this: =Sum([Hours Worked].Filter(A=thisRow.AND(B=thisRow.B))).

  5. Once you have entered the formula, Coda will automatically calculate the total hours worked by the person on the same day and display it in the auxiliary column.

By using this method, you can easily keep track of the hours worked by each person on the same day and make sure that they are being accurately recorded.

Hope this helps!

3

I’ve done that but it didn’t work

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.