# Work load per day **URL:** \ **Category:** Ask the Community\ **Created:** [January 26, 2021, 9:12pm UTC](https://connect.superhuman.com/t/work-load-per-day/20989 "2021-01-26T21:12:44Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Andrei\_Stefanescu1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/andrei_stefanescu1/32/15848_2.png) [@Andrei\_Stefanescu1](https://connect.superhuman.com/u/Andrei_Stefanescu1)\ **Post date:** [January 26, 2021, 9:12pm UTC](https://connect.superhuman.com/t/work-load-per-day/20989/1 "2021-01-26T21:12:44Z")
Hi! I’m new here and still figuring out some things… I’m trying to implement a new feature to a project management doc we use in our office. Im trying to determine the work load of each user, in hours, each day, excluding weekends. For example if a task is allocated 10 hours, the hours / day should be 8 hours in the first day and 2 hours in the second day. I hope that the embedded doc illustrates better what I want to achive. https://coda.io/embed/2BfzF3bBjC/_sug2T?viewMode=embedplay ---
**Author:** ![Federico\_Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico_stefanato/32/10092_2.png) [@Federico\_Stefanato](https://connect.superhuman.com/u/Federico_Stefanato)\ **Post date:** [January 28, 2021, 10:18am UTC](https://connect.superhuman.com/t/work-load-per-day/20989/2 "2021-01-28T10:18:16Z")
Hi @Andrei_Stefanescu1 and welcome to Coda community! 🤝 Your formula was indeed correct. However, you set the column data type as lookup for `workload` table rather than `WBS` table. You could have even set a simple Text data type and let the parser inference the correct type. Let me know if this helps. Cheers. ---
**Author:** ![Andrei\_Stefanescu1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/andrei_stefanescu1/32/15848_2.png) [@Andrei\_Stefanescu1](https://connect.superhuman.com/u/Andrei_Stefanescu1)\ **Post date:** [January 28, 2021, 11:02am UTC](https://connect.superhuman.com/t/work-load-per-day/20989/3 "2021-01-28T11:02:06Z")
Hi, Thank you for taking the time to help me. However, what you just said seems more advanced than my knowledge. Could you elaborate please? I don’t understand what I have to do. ---
**Author:** ![Federico\_Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico_stefanato/32/10092_2.png) [@Federico\_Stefanato](https://connect.superhuman.com/u/Federico_Stefanato)\ **Post date:** [January 28, 2021, 11:18am UTC](https://connect.superhuman.com/t/work-load-per-day/20989/4 "2021-01-28T11:18:31Z")
Sure @Andrei_Stefanescu1 ! I actually already changed the column type of `task list` in your doc and - as you can see - the `test` column formula now works. So, if I correctly understood, you don’t have to do anything else: unless you need other calculations. `test` formula wasn’t working because you set the `task list` lookup column as `workload`. Meaning that every entry in that column was considered as a row of the `workload` table: this is why you could have no access to _properties_ (columns) of `WBS` table I simply changed it to `WBS` lookup and that fixed the inconsistency. Lookup columns basically say: “We are row(s) of what table?”. Let me know if you still need do something else. ---
**Author:** ![Andrei\_Stefanescu1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/andrei_stefanescu1/32/15848_2.png) [@Andrei\_Stefanescu1](https://connect.superhuman.com/u/Andrei_Stefanescu1)\ **Post date:** [January 28, 2021, 11:27am UTC](https://connect.superhuman.com/t/work-load-per-day/20989/5 "2021-01-28T11:27:02Z")
Thank you, I now understand why it wasn’t working. Now what I have to do is find a way to somehow get to “what I want”, that is to divide the allocated hours of each task to the number of days each task takes and add them up in each day.