I need a formula or programming in the structure that reads the times

[Mohamed Haj Hamido]

Hello every one,

I need a formula or programming in the structure that reads the times, converts them and displays them in whole days. i have already the following code but i do not know to optimize him. thanks for any help

[David Niro]

Hello @Mohamed Haj Hamido ,

Welcome to the Community!

I will need to know more about what you are trying to do.  How is the hierarchy of your structure built?  At what level are you trying to make this calculation? What is "Estimated_Duration", a field or another calculation?

From what I can see, you have a field called "lead domain" and if the issue has this set in a certain way and the status is "done" or "fertig", you want to SUM the Estimated_Duration and color code the value.  

The way it is written now, it will SUM{} the value it finds on its own level in the hierarchy.  You could use the #children or #leaves modifier for SUM{} to get values from issues below the current one.  Which, will depend on the answers to the questions I asked above.

I look forward to your response.

Best,
David

[Mohamed Haj Hamido]

Hello David,

thanks for your reply.estimated duration is a field that shows us how much time it takes to complete a task. the form I wrote above calculates the estimated duration for a certain domain, in this case Lead-domain versuch. The problem is that the estimated duration for several tasks is not entered in days, but for example 0.05 or 0.04. These numbers need to be converted. For example: 0.04 means 4 days and must be shown as such. My question to you is how can I change the form to make this happen?