# Total Effort in a Project by summing Tasks

**URL:** <https://community.fibery.io/t/total-effort-in-a-project-by-summing-tasks/3455>\
**Category:** Get Help\
**Created:** [October 29, 2022, 9:27am UTC](https://community.fibery.io/t/total-effort-in-a-project-by-summing-tasks/3455 "2022-10-29T09:27:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Darb](https://avatars.discourse-cdn.com/v4/letter/d/c6cbf5/32.png) [@Darb](https://community.fibery.io/u/Darb)\
**Post date:** [October 29, 2022, 9:27am UTC](https://community.fibery.io/t/total-effort-in-a-project-by-summing-tasks/3455/1 "2022-10-29T09:27:01Z")

</div>

Hello

I am new to Fibery. Been playing around in a new Space and working on setting up my space. I have downloaded and been using/altering (to some degree) the Project Management Template.

I have created a field for tasks with a Start Date/Time and Stop Date/Time (usually the time will end on the same day). I have called this field “Task Duration”.

I would like to gather the “Task Duration” of all Tasks under a Project and show a total “Effort” but I am not totally sure how to do this. I think (by the look of formulas) it can be done, but I am not totally sure how to proceed? There are some formulas in the formula section but this sort of thing isn’t my strong point. I am also not sure if I am going about this the correct way.

Can anyone help?

Thanks.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [October 29, 2022, 5:57pm UTC](https://community.fibery.io/t/total-effort-in-a-project-by-summing-tasks/3455/2 "2022-10-29T17:57:23Z")

</div>

Hi @Darb  
I think there’s two parts to figuring this out.

Durations are calculated by subtracting dates (or datetimes).  
If you have a date range field (with start and end values), then you would use something like this:  
`ToDays(Date.End(false)-Date.Start())`  
If they’re separate fields, it will be something like this:  
`ToDays([End Date]-[Start Date])`

and then to calculate the total for the entire Project, you would use something like this:  
`Tasks.Sum(...)`

Combining, it would look like this:  
`Tasks.Sum(ToDays([End Date]-[Start Date]))`

If you don’t want the value in days, you can use `ToHours` or `ToMinutes` or…

There’s a bit of help with these sorts of things in the User Guide

> **[Formulas](https://the.fibery.io/@public/User_Guide/Guide/Formulas-39)**
>
> Tailored workspace for your company. Connected databases, customizable views, powerful reports, automations, integrations, docs & whiteboards.

> **[Formulas reference](https://the.fibery.io/@public/User_Guide/Guide/Formulas-reference-44)**
>
> Tailored workspace for your company. Connected databases, customizable views, powerful reports, automations, integrations, docs & whiteboards.

> **[Date Ranges in formulas](https://the.fibery.io/@public/User_Guide/Guide/Date-Ranges-in-formulas-42)**
>
> Tailored workspace for your company. Connected databases, customizable views, powerful reports, automations, integrations, docs & whiteboards.

---

<div class="post-metadata">

**Author:** ![Darb](https://avatars.discourse-cdn.com/v4/letter/d/c6cbf5/32.png) [@Darb](https://community.fibery.io/u/Darb)\
**Post date:** [October 29, 2022, 10:18pm UTC](https://community.fibery.io/t/total-effort-in-a-project-by-summing-tasks/3455/3 "2022-10-29T22:18:13Z")

</div>

Ok thanks for that Chr1sG. I will give that a go and see what happens. I would be mainly interested in minutes/hours as I rarely have a task span more than a 24hr period (most are only short to moderate in length).

Thanks again.