# Calculate hours in a week

**URL:** <https://connect.superhuman.com/t/calculate-hours-in-a-week/39442>\
**Category:** Ask the Community\
**Created:** [April 26, 2023, 7:53am UTC](https://connect.superhuman.com/t/calculate-hours-in-a-week/39442 "2023-04-26T07:53:45Z")\
**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 26, 2023, 7:53am UTC](https://connect.superhuman.com/t/calculate-hours-in-a-week/39442/1 "2023-04-26T07:53:45Z")

</div>

Hey guys i want to calculate de hours on a week who do Gabriel in this table, i want to put this information in another table but i dont know as i can do it. Any ideas?

 ![image](https://global.discourse-cdn.com/coda1/original/3X/6/6/66a6962cb2c0866e63020843123f92dff03aaa6e.png)

---

<div class="post-metadata">

**Author:** ![M\_Schneider](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/m_schneider/32/21442_2.png) [@M\_Schneider](https://connect.superhuman.com/u/M_Schneider)\
**Post date:** [April 26, 2023, 10:06am UTC](https://connect.superhuman.com/t/calculate-hours-in-a-week/39442/2 "2023-04-26T10:06:48Z")

</div>

Hi @Gabriel_Luezas ,

try using

```auto
Imputación.Filter(CurrentValue.Persona que imputa = ThisRow.Usuario AND WeekNumber(CurrentValue.Fecha) = WeekNumber(ThisRow.Fecha)).Numero de horas imputadas al proyecto.Sum()

```

as a column formula for Horas diarias. This will summarize all hours of the person selected in Usuario during the week of Fecha.

---

<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 26, 2023, 10:31am UTC](https://connect.superhuman.com/t/calculate-hours-in-a-week/39442/3 "2023-04-26T10:31:12Z")

</div>

Yoooo, Thanks so much it works perfectrly

---

<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:** [April 29, 2023, 10:32am UTC](https://connect.superhuman.com/t/calculate-hours-in-a-week/39442/4 "2023-04-29T10:32:07Z")

</div>

Closed on April 29, 2023, 10:32am UTC

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