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

**URL:** <https://connect.superhuman.com/t/i-want-to-add-the-hours-of-a-person-on-the-same-day-in-the-auxiliary-column/39379>\
**Category:** Ask the Community\
**Created:** [April 24, 2023, 12:05pm UTC](https://connect.superhuman.com/t/i-want-to-add-the-hours-of-a-person-on-the-same-day-in-the-auxiliary-column/39379 "2023-04-24T12:05:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gabriel\_Luezas](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gabriel_luezas/32/32808_2.png) [@Gabriel\_Luezas](https://connect.superhuman.com/u/Gabriel_Luezas)\
**Post date:** [April 24, 2023, 12:05pm UTC](https://connect.superhuman.com/t/i-want-to-add-the-hours-of-a-person-on-the-same-day-in-the-auxiliary-column/39379/1 "2023-04-24T12:05:46Z")

</div>

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](https://global.discourse-cdn.com/coda1/original/3X/1/a/1a1412081cb054dd56d10aec91753d72b2ed3ece.png)

---

<div class="post-metadata">

**Author:** ![Nigee\_Engel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/nigee_engel/32/34900_2.png) [@Nigee\_Engel](https://connect.superhuman.com/u/Nigee_Engel)\
**Post date:** [April 24, 2023, 12:07pm UTC](https://connect.superhuman.com/t/i-want-to-add-the-hours-of-a-person-on-the-same-day-in-the-auxiliary-column/39379/2 "2023-04-24T12:07:56Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Gabriel\_Luezas](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gabriel_luezas/32/32808_2.png) [@Gabriel\_Luezas](https://connect.superhuman.com/u/Gabriel_Luezas)\
**Post date:** [April 24, 2023, 2:57pm UTC](https://connect.superhuman.com/t/i-want-to-add-the-hours-of-a-person-on-the-same-day-in-the-auxiliary-column/39379/3 "2023-04-24T14:57:30Z")

</div>

I’ve done that but it didn’t work

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [July 23, 2023, 2:57pm UTC](https://connect.superhuman.com/t/i-want-to-add-the-hours-of-a-person-on-the-same-day-in-the-auxiliary-column/39379/4 "2023-07-23T14:57:47Z")

</div>

Closed on July 23, 2023, 2:57pm UTC

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