Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to sum duration with time

Hi all,   I would like to sum task duration with begining Date/Hours of the same task.   Exemple: Begining date                           Task duration (h)         Task estimated end 22/04/2020...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi  Anonymous ,

     

    Go to query editor> add column>custom column;

    Then put the below expression inside:

     

    Custom=[datetime]+#duration(0,[Duration],0,0)

     

    Finally you will see:

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, thank you for quick answer.

 

I tried but it seems that works only when "Task Duration" it's smaller than 24 hours.

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi  Anonymous ,

 

Go to query editor> add column>custom column;

Then put the below expression inside:

 

Custom=[datetime]+#duration(0,[Duration],0,0)

 

Finally you will see:

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!