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 13:30                            30                          23/04/2020 14:30

 

Anyone have idea in order to calculate column "Task estimated end" from my exemple ?

 

Thank you !

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!

3 Replies

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