How to add whole number to time and then aggregate to find total?

[Gherty0011]

I run time for a machine show in the table via columns A to D. I need to find and add columns F to H. Data file link.

1) How do I add the time in column C (data type is time) with column D (data type whole number) to get F? I show an example in cell J3 what calculation where I simply just add to the time

2) How do I find column G (example: C3-F2) to find prep time?

3) How do I find column H where this is a running total for that particular project? I highlighted the rows in yellow to show the end of the project and in the last instance it must do a running total and include the value for task time to final total time used for the project.

I wasn't sure how to solve problems 1 and 2 and was thinking once I do find those values I could use a group by for each project but not sure how to also incorporate for the last two to add the task time to find the total.

Any help would be greatly appreciated and thank you.

[KT_Bsmart2gethe]

Hi @Gherty0011 ,

To add minutes to time, you can use [Execution Time] + #duration(0,0,[Task Time],0).

For cumulative time by project, you can refer to link below:

https://community.powerbi.com/t5/Power-Query/Calculate-not-accumulated-amounts-from-accumulated-data...

Regards

KT