Calculate Percent time completed and highlight tasks

[@Barbeiritos]

Thank you very much! That's just what I need to make my Gantt Chart

[@BarbHendersonconsulting]

Wonderful!

[@widewings9920]

When using this formula more than 100% which wroung please can u tell me why
Start date 19- Jan 20
End date 05 May 20
Duration 90 days
Error (149%)

[@naomijansenvanvuuren2119]

I want to understand how the % is calculated

[@BarbHendersonconsulting]

the actual days divided by the projected days

[@dayangshazleen9184]

May i know how did u calculate the actual %?

[@BarbHendersonconsulting]

=datedif(startdate,today(),"D")/duration

[@shirleyjackson1861]

Hi, Barb Henderson. If the start and end are using minutes and second instead of Date, can you help me what formula should I use? Thank you

[@BarbHendersonconsulting]

I will look at that and get back to you

[@BarbHendersonconsulting]

Shirley, I forgot about this video that I have done ua-cam.com/video/tOw8z09vrnk/v-deo.html

[@shirleyjackson1861]

@@BarbHendersonconsulting Thank you so much~ :)

[@Behappyalways309]

Conditional Formating of task1 - > =ABS(%of time complete - actual%)>=0.1 - set a format - red - ok - ok

[@BarbHendersonconsulting]

yes that would work

[@hussainjamakhandi2779]

Hi Barb, Just curious to know about percent formula.For example - I have task from Aug18 to Aug19 that is for one day, But when I open this excel on 21st it will keep calculating and keep adding percent to the cell, So how we can avoid that... Hope you understand my question.Start date end date Duration Formula % Answer should be18 Aug 19 Aug 1 =IFERROR((DATEDIF(C11,TODAY(),"D"))/E11,"") 100%If it completes on time within one day else give warning

[@BarbHendersonconsulting]

=if( )>=1, "complete on time' value) I hope that makes sense

[@hussainjamakhandi2779]

Appreciated your quick turnaround - I have used this formula and getting True or False as answer but not quite happy with the outcome. So I have sent one mail to [e-mail], Please review and do let me know if you could find any solution..... Thanks a lot in advance for your kind help:)

[@ProjectManager1]

this formula is not working for a task which had few days or a few months backdate

[@shariyarkhan7829]

Hi, can you help me for the uptime percentage to reflect with minus downtime in excel? Pls

[@BarbHendersonconsulting]

Can you give me a little more explanation?

[@evioktaviana7863]

Thanks for the video, it is really helpful :) I have implemented this into my excel calculation. but the things is if the date of completion has been completed let say 07.10.2019 then this will be 100%. And if I opened again the excel on 08.10.2019 then the completion is become 103%. My question what is the formula to make the completion is still remain 100% not more than that. Thank you in advance :)

[@harshavardhanreddy2430]

yes , you can cap it by using =min(A1 ,1). * HERE A1 is the cell having more than 100%. and this formulae will help cap it at 100%.

[@mahathiranuar1954]

@@harshavardhanreddy2430 Can you explain more? seems I'm having error. Thanks

[@mahathiranuar1954]

=IFERROR((DATEDIF(F9,TODAY(),"D"))/J9,""=MIN(I9,1)) ** This is my formula**

[@ikhsanputra5545]

@@mahathiranuar1954 i do it another way. so you can make it the result in new cell(column) next to it with another conditioning formula.
=if(A2

[@ikhsanputra5545]

@@mahathiranuar1954 so it keep the value with 100%, then you hide original column cell. solved. 👍

[@vigneshg2213]

Thankyou so much

[@BarbHendersonconsulting]

You are so welcome!

[@krishnajagadeesh6307]

How to the actual % calculate madam I have start date and end date

[@BarbHendersonconsulting]

Follow the steps on the video and then select the % symbol from the home tab

[@surajkadam6397]

NO Fake Formula these is guess

[@Behappyalways309]

=DATEDIF(Start_Date,TODAY(),"D")/Duration
=IFERROR(DATEDIF(Start_Date,TODAY(),"D"))/Duration, " ")

[@BarbHendersonconsulting]

yes that would work