Calculate Percent time completed and highlight tasks more than 10% from actual.
Allow me teach you the skills in Excel that you need for business
Let me teach you the VBA that I have learn in my five years of consulting
Let’s take the frustration out of user forms
Become an Affiliate and earn 25% on Course Sales
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting
I am able to provide online help on your computer at a reasonable rate.
I use a Blue condenser Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Hello Ma'am, here I have a query on Percentage Calculation between two dates along with time together. EXAMPLE : START DATE – 17/09/20 7:00 AM ; DURATION – 15.50 (in hours) ( I have converted hours into days and the value is = 0.64583) so the END DATE is – 17/09/20 7:45 PM ( I got end date by putting formulae = Start date + Duration). I have tried to get the result by the formula you used in the above Video, I have even tried using now function but the answer is coming wrong. the answer I got was. 187% coming like that. Can You please help me out with this. thanks in advance.
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%)
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 🙂
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
Hi, can you help me for the uptime percentage to reflect with minus downtime in excel? Pls
NO Fake Formula these is guess
Hello Henderson,What does it mean by "D" in this formula?
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