Sum the Total Duration for Tasks in MS Project

Create a custom field to display the total duration of tasks in Microsoft Project. Calculate the total task duration using a formula and display the duration total column in a table.
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1

[@evgenboychuk8962]

Give this Man a thumb up for cracking cursed Microsoft, Jesus!!! Thank you! I've been fighting with 2 summary tasks starting at the same time and not being counted by the summary tasks as total duration, this custom field helped, why why on earth would the standard field Duration not count together linked summary tasks by start to start dependencies?

[@dynnisel9994]

Nice instructions, easy to follow! Thanks!

[@Computergaga]

Thanks Dynnise L, much appreciated.

[@piusoreva8451]

This was a lifesaving video I spent over two days trying to figure how this works... Kudos to you and thanks a lot!

[@Computergaga]

You're welcome! Thank you, Pius.

[@llamaduck1191]

Thank you, this really helped.

[@johncurran6229]

Great clear assistance

[@jyothirmaipatwari5051]

Thank you for the tutorial! Helped me big time.

[@Computergaga]

You're welcome!

[@TheLolitasmith]

Thank you!

[@vickyrancourt8063]

THANK YOU THANK YOU THANK YOU :) Super helpful!

[@Computergaga]

My pleasure. Great to hear, Vicky.

[@keithmaupin8940]

Excellent. Thank you for sharing this.

[@Computergaga]

You're welcome, Keith.

[@paultheman4133]

Good post!

[@minanovo4603]

Hello, thanks for the wonderful and easy to understand video. Slight issue I encountered tho, I followed the steps but had #ERROR messages on the summary level of tasks on my plan. What do I do?

[@Computergaga]

Sorry it is hard to know what could be wrong. Double check the video.

[@lazypuddycat]

My numbers for some reason doesn't add up. Just gives me the total duration and all the days that follow. But no sum.

[@asst.prof.chatreengamsangi2489]

Thank you, this relly helped.

[@Computergaga]

Excellent!

[@karenv8079]

God bless you! I've been searching for a way to do this for years! XD

[@kooroshhaziny8992]

Thank you.

[@Computergaga]

You're welcome Koorosh.

[@rimshajabeen8541]

I have made a schedule in ms project but facing an error in sum of duration ...the main activity having 7-8 indent i have written down duration of every indent but the sum of all is coming greater number than the actual sum of durations of indents...i have checked calender it is not wrong..plz guide

[@Himanshusingh-vu7hr]

Sir, Can you solve this project by "Crunching" (peak) Method

[@mohdanwerashfaq]

Thanks a lot! this helped me

[@Computergaga]

Great! Happy to help.

[@dee1251]

Hello Im new to project so perhaps the question might be silly. But i want to know the total duration in working days from start to finish considering that some tasks overlap each other.

[@Computergaga]

Dave B The Duration column by default does this Dave. Make sure you edit your Calendar from Change Working Time on the Project tab so that Project understands your working days correctly. This video is to show how to add up all the durations instead of the difference between start and finish. You will be happy with just the Duration column.

[@muhammadabdullahinjustice2585]

Hello. This was just to add up all the duration which is what the video is about but i want to know how to round off the value of duration (considering all the logic in the program). Like in above example, duration was 56.5 days, how to round it off to 57 days?

[@Computergaga]

+Muhammad Abdullah Chaudhary In the Project Options and the Display section there is a setting to remove decimal places from currency. This should round the values.

[@Ahmedahmed-xh8tc]

very helpful

[@Computergaga]

Thanks Ahmed.

[@pgdhonde]

Thanks

[@Computergaga]

You're welcome Prashant.

[@luisguillermomolerosuarez7060]

I´d like to have that template, because i´ve been developing games with SUM, Would you like to give me some? best regrets

[@Eylyssna507]

you are my brother thanks so much

[@Computergaga]

My pleasure 👍

[@robtayler9740]

hi, when i create a custom field, after naming, the rollup option is not available?

[@robtayler9740]

dont worry it was because i had the type still set to text instead of duration. thank you.

[@Himanshusingh-vu7hr]

How to determine the total cost of the project?

[@juliusmwaura8416]

how do I enter fixed duration and start and finish dates? for instance duration of 266 days start date 4th march 2020 finish date 25th november 2020

[@Computergaga]

You can change the task from Auto scheduled to Manually scheduled and then enter the dates into the Start and Finish fields.

[@Eylyssna507]

min bror

[@jerccopnsnrcabanatuan5974]

how to know the sum of the calendar day delays of the project?

[@Computergaga]

If you switch to the Variance table by clicking the View tab, Tables and Variance from the Gantt Chart. This view will show the start and finish variance of your project on the Project Summary Bar. For this to work it would require you having a Baseline setup and the Project Summary bar displayed.

[@jerccopnsnrcabanatuan5974]

thank you sir, i just subscribed to your channel, do you have any tutorial for this? , i just want to know how to determine the Projected or plan(in percent) every Week of the project so that i can substract it to the Actual Weekly Accomplishment. so that i can determine the difference of them.

[@jerccopnsnrcabanatuan5974]

I just want to summarize the # of calendar delays of the project through their difference. but i dont know the Total Plan Percentage AS PER WEEKLY. Can you help me sir? My boss need my presentation on MONDAY. please help me.

[@Computergaga]

Project has a % complete field but the detail you need seems beyond projects standard fields. You can create a custom field or maybe export the data into Excel for analysis.

[@hoangdacan]

Peaky blinder man

[@Computergaga]

😂

[@mxgaurav]

I'll recommend to talk less and do more, make it precise and shorter

[@Computergaga]

Thanks, Max.

[@LB-yg2br]

omg less chat and more "how to"

[@Computergaga]

Sorry 🙁