Calculate with duration fields

I want to sum al unbilled hours for a project. For that, I can use a lookup. But Then I want to summarize the booked time, which is a duration property.

How can I calculate with Duration fields?

1 Like

Hi Ronald,
Let me check this and get back to you.

1 Like

Hi Ronald,
To calculate duration fields you will need to convert it into a number by multiplying it with 1 day for instance. If you do this with all the items you want to do calculations on you can easily sum them up.

The reason why currently a Sum for duration isn’t in our application yet, is because you’ll run into issues like: do you want it in days or month or weeks. What if you have it in days and you want to convert it to month, how many days do you take as a month.

Untill we’ve figured out how to support you in that, we’ll not be able to provide a default Sum of durations.