cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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 !

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: How to sum duration with time

Hi  @Sylvinhio ,

 

Go to query editor> add column>custom column;

Then put the below expression inside:

 

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

 

Annotation 2020-05-28 140941.png

Finally you will see:

Annotation 2020-05-28 141250.png

 

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

View solution in original post

3 REPLIES 3
Highlighted
Super User IX
Super User IX

Re: How to sum duration with time

@Sylvinhio , try

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Frequent Visitor

Re: How to sum duration with time

Hi, thank you for quick answer.

 

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

Highlighted
Community Support
Community Support

Re: How to sum duration with time

Hi  @Sylvinhio ,

 

Go to query editor> add column>custom column;

Then put the below expression inside:

 

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

 

Annotation 2020-05-28 140941.png

Finally you will see:

Annotation 2020-05-28 141250.png

 

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors