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!
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , try

Task estimated end =[Begining date] + time([Task duration (h)],0,0)

 

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
    Community 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!