Substitute time tracked in subitems from estimated hours in the main task area

Hello community,

I have a problem. I summarized all time tracked in subtasks. Then I would like to substitute this summary of time tracked from an estimated amount of hours. Unfortunately this is not working, because the summarized time is measured in seconds (as you can see in the screenshot) and I cannot change it to hours. Any help?

This is the formula Iā€™m using.

Thanks a lot :slight_smile:

Hi @simonwind,

In the formula column, you should be able to divide function to convert the time from seconds to hours.

I.e {est. time}-({time tracked}/3600)