How to sum duration with time

[Anonymous]

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 !

[amitchandak]

@Anonymous , try

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

[Anonymous]

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 · Accepted solution]

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!