task percentage calculator

• Skip to main content
• Skip to primary sidebar

Savvy Calculator

Savvy Calculator is a free online tool of calculations.

Completion Percentage Calculator

About completion percentage calculator (formula).

A Completion Percentage Calculator is a tool used to determine the percentage of a task or project that has been completed based on the amount of work that has already been finished in relation to the total work that needs to be done. This can be useful for tracking progress and setting goals for various activities.

The formula to calculate the completion percentage is quite straightforward:

Completion Percentage = (Completed Work / Total Work) * 100

• Completed Work: The amount of work that has been successfully finished or accomplished.
• Total Work: The entire amount of work that needs to be done for the task or project.

You multiply the ratio of completed work to total work by 100 to get the completion percentage as a whole number. This number represents the portion of the task that has been completed as a percentage of the total task.

For example, if you’ve completed 200 out of 500 tasks in a project, the completion percentage would be:

Completion Percentage = (200 / 500) * 100 = 40%

So, in this case, you would have completed 40% of the project.

This formula can be applied to various scenarios, such as tracking the completion of tasks in a project management tool, evaluating student progress in a course, or measuring the completion of goals in personal development plans.

Free time management calculators

People generally track time either by using a simple, basic method (like paper, rule-of-thumb estimates, and spreadsheets) or by using a dedicated time tracking software.

Time is the most valuable resource of all — and yet, somehow, we tend to forget that fact.

But, the thing with time is this — there are almost no limitations to what we can achieve if we dedicate time to it. The choices of how we allocate time shape our personalities and habits, making us the people we are.

Both the guide and the calculators we offer here will provide guidance to mastering the skills of time management and help you adequately prioritize your tasks and activities .

We created 4 unique time management calculators — a daily one, a weekly one, one for full-time employees, and one for students.

So, before you read the full guide and discover the wide range of time management calculators usage benefits, here's quick access to all 4:

• Daily time management calculator — you can use it to adapt your routine to the unique requirements of each day.
• Weekly time management calculator — you can use it to get the overall picture of how you allocate your time during the week.
• Weekly calculator for full-time employees — you can use it to help get the most out of your weekends.
• Weekly calculator for students — you can use it to help you meet all the deadlines and have a stellar academic experience.

What is a time management calculator?

A time management calculator is a tool that enables you to understand, plan, and organize your time. It helps you understand how you spend your time.

It can be applied to any given period of time — meaning that you can use it on a daily, weekly, monthly, or even yearly basis.

The 2 main purposes of using time management calculators

Time management calculators can be used for 2 main purposes.

Both have the same main goal — to help you master time management skills.

• The first purpose is retroactive — you aim to understand your routine in order to reflect on the way you allocate your time.
• Once you have a clear understanding of the way you allocate your time, you can use the calculators for their second purpose, i.e. their proactive purpose — goal setting and monitoring.

Benefits of time management calculators usage

Let's start this chapter by naming a few essential benefits that can apply to everyone who is using a time management calculator:

• Achieving the perfect work-life balance
• Pinpointing time wasters
• Developing healthy habits

The list goes on and on — but most of the other items on it are unique and refer to specific individuals. So we won't be dealing with them here.

However, there are benefits of time management calculators that we can speak about in general terms. We'll focus on those and point you to the right mindset — to strive for the improvement of your time management skills .

Benefit #1 — you'll understand how you allocate your time

It's important to develop the habit of tracking, estimating, and scheduling the time it takes to finish tasks, as scheduling often involves other people.

So, if you don't want to be irresponsible in regard to other people's time and schedules — especially when you're working on interdependent tasks — accurate estimates created with the help of a time management app and a time management calculator will help you never be late again.

Benefit #2 — you'll be able to effectively plan in advance

If you don't have estimates of how long it takes to finish a certain activity, you can't effectively plan in advance.

Once you get a better insight into your allocation of time, you'll be able to evaluate your personal productivity at different times of the day.

Benefit #3 — you'll boost your motivation

Time management calculators help you understand how to better structure your day and improve your organizational skills.

This set of skills serves to help you prioritize in a better way, meet all of your deadlines, use all of your resources efficiently, and never be late for a meeting again.

Benefit #4 — you'll be able to perform individual activities more efficiently

Once you know how much time it takes to finish an activity, you'll be less likely to procrastinate and more likely to focus during a given time period.

After all, comparison with yesterday's self is probably the healthiest way of growth and improved self-image.

Once a person is aware they can perform a specific activity in, let's say, an hour, it makes it highly unlikely that they will allow themselves to spend 2 hours on the same activity in the future.

Time management calculators usage — an example

After observing the benefits of using a time management calculator, here's something more tangible, to help you visualize what we're talking about — i.e. an example showing a weekly overview of time spent on chores, commuting, sports, sleeping, socializing, and, of course, work.

As you can see, once you enter the values for each day, the following column will translate the time into percentages of your week.

As we've mentioned earlier, it is crucial for a person to understand how they allocate this limited resource of time, and, how to track that resource allocation .

And, percentages are an amazing way to better visualize the distribution of time to different activities.

If any percentage seems too high, perhaps you can set a limit to those activities.

That goes especially for activities that do not necessarily contribute to your growth and overall well-being (such as social media).

Now let's take a closer look at our example.

As you can see, a person with a regular sleep routine and a full-time job dedicates 33.33% and 23.81% of their time to those two important activities. The total translates to 57.13% of their week, leaving less than half of the time to dedicate to all the other activities.

That's spending 40 hours per week at work, and 56 hours per week sleeping. Both numbers are adequate and necessary for a healthy life, and a healthy work-life balance .

So, once you enter the activities that are obligatory for you, you will be able to distribute the rest according to your preferences.

Convenient, right?

Now, let's go into more detail about each of the 4 time management calculators we've made for you.

The 4 time management calculators

As we've mentioned at the very beginning of this guide, we've made 4 different time management calculators. They all work on the same principle but are adapted to different situations.

So, apart from daily and weekly calculators, we've also made specific time management calculators for students and full-time employees.

Now let's discuss each of these calculators, their main purposes, and the best ways to use them.

1. Daily time management calculator

The first time management calculator is the daily one and it's dedicated to different requirements of each day. Once you enter the digits for activities you must complete on a specific day, you'll get the total number and percentage of hours spent on those activities.

That way, you can easily check if you have any extra time available — and when — to allocate to other activities, in accordance with your preferences.

Download daily time management calculator

Why is the daily time management calculator useful?

Why is our daily time management calculator useful?

Well, for starters, because each day is different, and you need to keep track of these differences.

For example, you don't go to the bank or get a haircut every day, right?

Moreover, no matter how meticulously you plan the order of your daily activities , many things can go wrong and interfere with the schedule you had in mind.

After all, there's a limited number of factors you can anticipate in life, as many things require cooperation with other people.

Remember that time when you got stuck in traffic, or when your coworkers were late for a meeting?

Some things will be out of your control and that's normal.

However, keeping track of these daily delays may point out some patterns and help you start making more realistic time estimates .

So, the reason why the daily time management calculator is useful is that it helps you create structure on a daily basis and thus helps you focus on one specific task , instead of letting your focus wander between several tasks.

And why is focusing on one task at a time important?

Well, according to the latest productivity statistics , multitasking can decrease productivity by a whopping 40% . That's because only 2.5% of people can actually multitask . So, for the rest of the population, the task switching cost is mostly harmful.

How do you use the daily time management calculator?

The usage of the daily time management calculator can be retroactive and proactive.

In the former use, your role is more passive and more of an observer.

What you need to do is track the time you've spent on something. Once you're finished with an activity or have completed a task, you enter how long you were doing it.

The retroactive approach helps you get a clear picture of how you spend your time. Understanding how much time you are dedicating to each activity is the first step in changing your habits and improving your routine.

Only once you have a clear picture of how you allocate your time can proactive usage start — which implies deciding how much time you want to allocate to a certain activity and trying to stick to the schedule.

It's the second purpose of these calculators we've mentioned earlier — monitoring your progress and setting clear goals.

The word “proactive” carries the semantics of “in advance”, and, you can create your daily schedule as much in advance as you want. For example, you can create a daily schedule the night before, or early in the morning, while drinking your first cup of coffee.

And, all that by observing your daily time management calculator results.

2. Weekly time management calculator

The second time management calculator we've made covers the range of activities during one week. The way you allocate your time on a weekly basis can easily become your routine, so you ought to pay attention to activities that you do regularly.

That's how habits are created — and our habits are what makes us unique individuals. That's also exactly what a weekly time management calculator (and its purpose) is — a tool for monitoring your weekly habits and, if need be, improving them.

Download weekly time management calculator

Why is the weekly time management calculator useful?

Once you better understand your weekly time usage, it will be easier to enjoy your free time and plan your weekends and vacations.

Planning your week mostly consists of finding ways to distribute your activities between the workweek and weekends — for this purpose, a weekly time management calculator is perfect.

How do you use the weekly time management calculator?

Just like the daily time management calculator, you can use the weekly calculator either proactively or retroactively.

The only difference is the range of time.

Namely, once you're finished with the daily activities, you need to enter them into a specific day of the week. Monitoring the allocation of time on different days will help you understand your habits and your routines.

This is a vital step, as you'll gradually learn to make the difference between operating at your peak efficiency and struggling to power through activities and tasks on “slower” days.

That's again the retroactive approach, which will help you understand your weekly schedule as it is now. If you have done this part already, you'd probably like to reduce the time-wasting activities, if you noticed any.

Also, you shouldn't beat yourself too much if you notice some unhealthy habits creeping into your routine. The important thing is that you've noticed them and are aware that they exist. Bear in mind that working on the best version of yourself takes time and commitment.

So, as long as you can say that you're working on removing or minimizing the time you spend on the time-wasters, it's all good. The end goal is to create a schedule that optimizes your performance as the week progresses.

3. Time management calculator for full-time employees

Now let's talk about a more specific type of weekly schedule, concerning everyone who is engaged in full-time employment.

This time management calculator is meant to help you better manage your time at work.

You can use this tool not only to get the most out of your weekends, but also to improve your workweek routine.

Download weekly time management calculator for full-time employees

Why is time management calculator useful to full-time employees?

Being a full-time employee already means that your weekly schedule includes 40 hours of work.

Considering one week has a total of 168 hours, the base of “your time” that you can actually allocate to other activities is 128 hours.

Now, let's add up the time you spend sleeping and subtract it from that.

So, to be healthy and productive, adults should get between 7 and 9 hours of sleep every day, as experts claim. What's left is 72 hours, under the assumption that a person sleeps for 8 hours each day, on average.

Now, take a moment to think about other essential activities that you do daily and try to estimate the weekly total for the following:

• Preparing and eating meals
• Personal hygiene
• “Getting ready” tasks (clothing, hairdo, makeup, etc.)
• Grocery shopping and other chores

You see, for an optimal work-life balance , it's essential to learn how to get the most out of what's left of your time after work and sleep.

Tracking your performance and the time needed to complete each of the tasks is a great start to establishing a routine.

Why is it important for full-time employees to have a steady routine?

Well, time is a limited resource and, if you want to be able to plan in advance and boost your career , you need to have a time frame for specific activities.

How to use a time management calculator if you're a full-time employee?

Now let's see how a time management calculator can help you perfectly balance your work and personal life.

First, there's planning your workdays, when you have to enter the duration of:

• Time spent at work,
• Time spent commuting,
• Time spent sleeping, and
• Time spend doing any other activity you must perform.

Another activity you can view as primary is regularly carrying out some basic exercises, to stay healthy.

These are your primary activities and no leisure time or time spent socializing should impact the duration of said primary activity.

After you have completed this step, you'll get how much time overall you have left to distribute to other activities.

Now you should enter the values for secondary activities.

This category should also include chores and self-care-related activities.

Also, this is where you should enter activities you find primary only on specific days — such as going to the post office, having a scheduled visit to the dentist, etc.

Naturally, if there's any amount of time left, you can choose whether to socialize or extend the duration of any activity that you prefer.

Now let's talk about the weekends, when you don't have to dedicate any time to work or commuting. This is the part where you can be creative and even experiment a bit, to enrich your personal life.

You can try out rotating short travels and socialization, along with spending more time on chores and prepping your meals for the following week.

4. Time management calculator for students

Academic experience carries a specific set of “ problems ” that students encounter while dealing with time management.

That's why we've created another specific weekly calculator, which can help students plan their social activities around their classes, studying, and assignments.

This tool will significantly boost the quality of each of those activities.

Let us show you what we're talking about.

Download weekly time management calculator for students

Why is time management calculator useful to students?

Why did we choose students as a target group for this tool? Well, for starters, did you know that the vast majority of students will postpone their duties until the last minute?

To support the claim, we found that various studies point to a range between 50% and 95% of students being regular procrastinators .

Several relevant factors impact the result being of such a high percentage, the prevalent one often being their very active social life.

We're not trying to say that students shouldn't socialize and take part in social activities.

With proper organization, time tracking, and a well-planned structure, there's enough time to meet all the deadlines AND engage in all the fun activities with friends.

We know, scheduling your social life may sound strange, even ridiculous. Yet, just try it out — enter the parties you're planning to go to in your calendar.

How to use a time management calculator if you're a student?

Let us show you this in an example.

Here's what prioritizing categories such as attending classes, doing homework, and sleeping looks like in a time management calculator.

So, first things first, as we've just mentioned — enter between 7 and 9 hours of sleep, and add the duration of your academic responsibilities, including the time spent studying and commuting .

Once you enter other activities you have scheduled in advance, such as volunteering or contributing to a student organization, you'll get an estimate of how much time you have left to distribute.

And it goes without saying, every week will have a different set of activities that count as a priority. So make sure you also account for various occasional tasks, such as going to the post office, bank, studying for the midterms, or having a scheduled visit to your dentist.

Categorize those activities as primary as well, and include them in the “ Other ” category of the calculator.

That's for the workweek, when you have classes to attend, and more responsibilities in general.

But the real change starts only once you start scheduling your weekends too. Again, you should focus on your academic performance, so you'll need to enter the values for studying, doing homework, and any other assignments you only have time to finish during the weekend.

Only then should you plan any social activities. This is the only way to have a stellar academic experience, with enough time for socialization — provided that you do stick to your schedule.

Let's wrap it up

As you can conclude, the time management calculators we've provided can significantly improve your time management skills. They will help you identify the time wasters and improve your planning and scheduling skills and precision.

Once you are able to create your week in advance, not only the way you allocate time will improve, but the quality of your performance as well. Having a structured schedule dissects large chunks of time to specific tasks and goals, thus making them easier to achieve.

Moreover, there will be more small victories in your day, which is extremely beneficial for your mental health.

However, if you consider yourself tech-savvy and want to leverage the power of online time management tools, we suggest you do all that with Clockify .

Since the core activity is tracking time, there's no reason not to use the same solution for tracking your progress as well.

It's like the proverb says — killing two birds with one stone.

Clockify can help you:

• Organize and prioritize in a better way
• Increase your motivation and productivity
• Pinpoint your time wasters
• Maximize your performance at work
• Achieve the work-life balance
• Bentley, D. (2018, September 13). How To Finally Master Your Time. Forbes. https://www.forbes.com/sites/forbescoachescouncil/2018/09/13/how-to-finally-master-your-time/?sh=55d6911348c4
• Quast, L. (2016, February 29). 5 Time Management Tips That Will Boost Your Career. Forbes. https://www.forbes.com/sites/lisaquast/2016/02/29/5-time-management-tips-that-will-boost-your-career/?sh=3f685cb6666d
• Rozental, A., & Carlbring, P. (2014). Understanding and Treating Procrastination: A Review of a Common Self-Regulatory Failure. Psychology, 05(13), 1488–1502. https://doi.org/10.4236/psych.2014.513160
• Steel, P. (2007). The nature of procrastination: A meta-analytic and theoretical review of quintessential self-regulatory failure. Psychological Bulletin, 133(1), 65–94. https://doi.org/10.1037/0033-2909.133.1.65
• Suni, E. (2021, March 10). How Much Sleep Do We Really Need? Sleep Foundation. https://www.sleepfoundation.org/how-sleep-works/how-much-sleep-do-we-really-need
• Watson, J. M. (2010, August 1). Supertaskers: Profiles in extraordinary multitasking ability SpringerLink. https://link.springer.com/article/10.3758/PBR.17.4.479?error=cookies_not_supported&code=6c021a62-1fc0-48a6-a6a0-e4e857776031
• You Can't Multitask, So Stop Trying. (2014, July 23). Harvard Business Review. https://hbr.org/2010/12/you-cant-multi-task-so-stop-tr

Start tracking time with Clockify

24/7 Support

Cancel Anytime

Free Forever

Project complete percentage

Related functions .

To calculate the percentage complete for a project with a list of tasks, you can use a simple formula based on the COUNTA function . In the example shown, the formula in F6 is:

Generic formula

Explanation .

In this example if a task is marked "Done", then it is considered complete. The goal is to calculate the percent complete for the project by showing the ratio of complete tasks to total tasks, expressed as a percentage. The formula in F6 is:

At the core, this formula simply divides tasks complete by the total task count:

which is then formatted as a percentage . To count completed tasks, we count non-blank cells in the range C5:C11 with the COUNTA function :

Unlike the COUNT function , which counts only numeric values , COUNTA will count cells that include numbers or text.

To count total tasks, we count non-blank cells in the range C5:C11, again with COUNTA:

After COUNTA runs, we can simply the formula to:

Four divided by 7 results in the decimal number 0.571428571428571 which is displayed as 57% once the Percentage number format is applied.

Related formulas

• Get percentage of total

• Percent of goal

• Get percent change

Related functions

• COUNTA Function

The Excel COUNTA function returns the count of cells that contain numbers, text, logical values, error values, and empty text (""). COUNTA does not count empty cells.

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Related Information

Get training, quick, clean, and to the point training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

Help us improve Exceljet

Your email address is private and not shared.

• Contact sales

Start free trial

How to Calculate Percent Complete in Project Management

When you’re managing a project, you have to track your team’s progress while they execute their work to stick to your schedule. This is done with task management, and one of the cornerstones of task management is knowing the percent complete of the task.

By calculating the percent complete of a task, you can see how much has been completed and how much work is left. It’s a quick and easy way to determine if you’re on target or falling behind, which is essential for delivering a successful project.

What Is Percent Complete?

Percent complete is a way to track the progress your team is making when executing their tasks. It tracks how far along you are in completing that work. Also called project complete percentage, it shows how much work has been done and how much work there is to do. This provides project managers with the data they need to see if their team is aligned with the project schedule.

Why Is Percent Complete Important in Project Management?

Knowing the percent complete is important for many reasons. It serves the task management plan, which is a process to monitor your team’s tasks from start to finish. Knowing how much the team has done at any given time in the project helps project managers see if the work is on schedule.

Percent complete is one way a project manager can track progress, which is one of the most important aspects of a project to monitor. It’s the bedrock of project management software, which provides digital tools to track the team’s progress in completing their tasks. Many of these tools deliver real-time data, which gives a more accurate rendering of percent complete.

Resource management is also tied to percent complete. Knowing if the team is behind or ahead of their deadline influences how you allocate your resources. For example, if the percent complete shows tasks are lagging, the project manager can reallocate resources to get back on schedule and keep the project on track.

We’ll delve into how you can calculate percent complete in a moment, but know that project management software can do this for you. ProjectManager is project management software that automatically calculates your percent complete and tracks your team’s task progress in real time. You can filter for the critical path on our interactive Gantt chart and link the dependent tasks to avoid bottlenecks. Get started with ProjectManager today for free!

How to Calculate Percent Complete

We’ve discussed what percent complete is and why it’s important in project management. The next step is figuring out how to calculate for percent complete. It’s a simple formula.

Percent Complete = Actual Duration/Duration (PC = AD/D)

For example, if you have a task that has a duration of 10 days and five days have been completed, or the actual duration, then the percent complete is 50 percent. However, what’s missing from this equation is tracking. Tracking is where the real value in percent complete lies.

How to Track Percent Complete

Percent complete is how to track progress. One of the project management tools to help you accomplish this is a Gantt chart . Gantt charts are visual timelines that map your tasks in one bar chart. The left side looks like a regular spreadsheet, but the data is then reflected visually on the right side.

When you’re looking at a Gantt chart with your project schedule , the task duration is the bar that extends from the start date to the finish date. The percent complete is how much the bar is filled in or shaded, depending on the tool you’re using.

Taking our example from above, a 10-day task duration will look like a bar going from the start date to 10 days into the project. The percent complete, again referring to our example above, is 50 percent. Therefore, the bar on the Gantt will be half-shaded.

There are three ways to track the percent complete, the first being using your professional judgment. This might seem arbitrary, however, it’s more than a guess. You can meet with the team and use your experience with past projects to predict the percent complete.

A more complicated method is weighted activities. It’s best for long tasks with several activities. If you can easily divide those activities, then you can set a percent complete based on each. This method involves a lot of work on the front end and isn’t ideal for all projects.

Finally, there’s the arbitrary amounts or fixed-figure method. This is when you create milestones for the task. Before it starts, it’s 0 percent complete. When you begin, it’s 20 percent complete and then it reaches 100 percent complete when finished. You have only those three fixed points. It’s not super accurate but broadly provides usable tracking data.

How to Track Percent Complete with ProjectManager

Rather than go through the three methods we outlined above, which are helpful but not fully accurate, ProjectManager has robust Gantt charts that automatically calculate the percent complete for each of your tasks. Because our tool is online, the percent complete is shown in real time. You’re looking at accurate data and not a snapshot of the project in the past.

You can track the percent complete once you have created a project plan on our Gantt and set the baseline. This captures the schedule, costs and more so you can get the variance of your actual effort against your planned effort. This data is delivered in real time throughout the software to help you keep your project on schedule.

Multiple Ways to Track Percent Complete

Of course, not everyone wants to work on Gantt charts. That’s why the Gantt chart is only one of our multiple project views in which you can track the percent complete of your team’s tasks. If you’re working on the sheet view, you’ll see the percent complete on the corresponding column, which is updated by the team member assigned to that task as they move through their assignment.

Track Percent Complete in Real Time with Dashboards

Percent complete is only one part of tracking progress. We have features that provide a high-level view and others to get deeper into the data. Our real-time dashboard monitors six project metrics, including progress, which shows the percent complete for each project task. Unlike lightweight tools, our dashboard requires no setup. It’s plug-and-play.

For when you want more context around the percent complete, take advantage of our reports that can be generated in one keystroke. There are status reports and even portfolio status reports if you’re managing a program or portfolio of projects. You can also get reports on tasks, timesheets, workload and more. All reports can be filtered and easily shared to keep your stakeholders updated.

ProjectManager is award-winning software that connects teams to work more productively. Whether you’re working side-by-side, across different departments or across the country, our real-time data keeps everyone on the same page. Plan, monitor and report on progress and work more efficiently. Join teams at NASA, Siemens and Nestle who are already delivering success with our software. Get started with ProjectManager today for free.

Deliver your projects on time and under budget

Start planning your projects.

How to Track Percent Complete

When you are trying to calculate percentage complete in a Gantt chart, you need to take into account various different figures, and get lots of information from other people. Or do you? There are simple ways to track percent complete on your project, so you know what to input into your software.

In this article we’ll look at 3 methods to track percent complete.

What is Percent Complete?

It’s a way to track project progress – quite an important part of how to manage a project.

Percent complete on a project refers to how far through you are for any given task (or the project overall). Consider it an indicator of project progress.

In the image below, you’ll see that % complete is represented by the color green. The blue section of the bar represents work not yet done. There’s also a column that gives you the % complete number.

Percent Complete in your project software

The percent complete method your software uses is down to whether it’s an enterprise tool that integrates with timesheets or not.

If your tool is integrated with a timesheet app, the percent complete of the task may increase automatically as your team members book time to the task. However, that might not be brilliantly accurate, depending on how good the team’s time tracking is.

In your software, there’s normally a column on the left-hand side of the Gantt chart that lets you manually enter percent complete, and this is how I do it in tools that don’t integrate with timesheets.

But how do you know what to put in the percent complete column? Is it just a guess?

Well, that’s one way of doing it! Here are 3 ways of calculating percent complete on a project.

Percent Complete Tracking #1: Professional judgment

The first way to calculate percent complete for your project is to use your professional judgment or that of your team.

There is no percent complete formula here – you guess, estimate, or rely on the thought processes of your subject matter experts. Ask them how they rate progress on the task. They mentally compare the actual duration of the work done to date with the forecasted amount of work, and assess how close the task is to being done given that effort. They give you a number. Then you type it into the percent complete column.

This is the easiest option, as long as your team gives you the right answers!

Percent Complete Tracking #2: Weighted activities

This is a more complicated percent complete calculation to track progress, but it could be worth doing for longer tasks that are made up of several activities, or that have arbitrary points in them. For example:

• A week-long task that has a decision-making meeting halfway through the week
• A task to build 500 lines of code, that could be split into 2 chunks, each of 250 lines
• A testing activity made up of 20 tests, that could be split into 4 sections, each of 5 test scripts.

In these cases, you wouldn’t want to make the task smaller by splitting it down, but you know there is a point at which you could track progress. In the last task example, you would allocate % complete based on how many test scripts the team had got through.

• When 5 test scripts are completed, you allocate 25% complete
• When 10 test scripts are completed, you allocate 50% complete
• … and so on.

When your task can be easily sub-divided (but not in a way that would make you want to split the task up for the schedule) then you can allocate % complete based on a specific measure of how far through you are.

If your task doesn’t break down neatly in a numerical way (e.g. 10 test scripts = 50%) then you can allocate a % complete based on hitting an arbitrary point in the activity, for example a sign off meeting, or completing a document to the point that it has gone out for review but hasn’t yet been ratified by the whole team.

This method takes a lot of thinking and sometimes you’ll have to set your % complete targets before the task has started so that everyone has a common understanding of what’s being tracked and how it will be measured.

It’s a big overhead for what’s actually not that important in the vast majority of cases. Think carefully about whether it’s worth adding this level of formal granularity to your project tasks, or whether professional judgment is enough.

I have used this technique but it’s not something that is relevant to most of my projects. If it feels like a good fit for the way your team (and customer) wants to manage the work, then go for it.

Percent Complete Tracking #3: Arbitrary amounts

The final way of working out what to put in the percent complete column is by using an arbitrary, fixed figure.

For example: when a task begins, you give it 20%. When the task finishes, you make it up to 100%. The task would never be 25% or 90%. It could only ever be 0%, 20% or 100%.

This method of tracking gives you a percent complete that broadly reflects the current task progress for the purposes of scheduling, even though it’s inaccurate in real life.

It gives you enough of a steer to adequately manage the plan. It’s low stress. It’s easy. It’s useful if your team constantly give you incorrect percent complete figures and you no longer trust their judgment.

Do you need to track percent complete on projects?

Tracking percent complete is helpful for project managers. But it’s not essential. If you create a really simple schedule using my free Excel Gantt chart template , then it would be too much effort to color the cells to represent percent complete — I wouldn’t bother.

Whether it’s worth tracking percentage complete on your project tasks depends on how robustly you need to track and report progress. If you feed progress data from tasks into your project dashboard , then you need it to be accurate.

Use your own professional judgment and choose a way to track progress that makes most sense to you. Learn more about categories of project management methods here .

Get a free Excel Gantt chart template in my project management template library. Access the library here to get access to the Gantt chart template and everything else!

Pin for later reading:

Project manager, author, mentor

Elizabeth Harrin is a Fellow of the Association for Project Management in the UK. She holds degrees from the University of York and Roehampton University, and several project management certifications including APM PMQ. She first took her PRINCE2 Practitioner exam in 2004 and has worked extensively in project delivery for over 20 years. Elizabeth is also the founder of the Project Management Rebels community, a mentoring group for professionals. She's written several books for project managers including Managing Multiple Projects .

Marks Percentage Calculator

Use this test mark to percentage calculator to easily calculate the percentage given one or more test grades (marks) and the maximum possible number of marks. If you enter marks from multiple test exams or test tasks, they will be summed before the percentage calculation. Suitable for all school and college level exams.

Related calculators

• How to calculate percentage of marks?
• Marks to percentage formula
• Test marks to percentage - practical examples
• How to calculate the average percentage score for an entire class

    How to calculate percentage of marks?

To find the percentage of marks only basic arithmetics with proportions is required. If it is a single mark, first divide the mark by the maximum possible mark and then multiply by 100 to get the percentage. If there are multiple marks involved, first find their sum total, then proceed as if it is a single mark and divide by the maximum total marks out of which these marks were obtained. Multiply by one hundred at the end to convert to percent. You can do this by hand, following the formulae below, or by using our mark percentage calculator above.

For example, if an exam has a single section and the maximum score is 25, for a student who scored 18 enter 18 in the first input field and 25 in the second, then click "Calculate". If an exam has three sections, or a student is scored on three separate subjects, enter the three obtained scores separated by spaces or commas like so "80 60 90" and then enter the maximum score they could have obtained, e.g. 300 if the score ceiling on each test is 100.

    Marks to percentage formula

In the simplest case we have just a single exam and therefore a single test grade to work with. In this case the calculation to convert marks into percentage is straightforward by following this formula:

Mark Percentage = Scored Mark / Test Maximum x 100

"Test maximum" corresponds to the "Out of ... marks" input field in our test grade percentage calculator.

If an exam is scored in separate test sections, or if you are calculating the percentage from several separate exams, then the following formula is applicable:

Mark Percentage = Sum of Scored Marks / Test(s) Maximum x 100

The sum is calculated in the usual way using simple algebra. Our calculator handles that for you automatically.

    Test marks to percentage - practical examples

First, a simple example with a single test. Let's say a student scored 85 on an exam with a maximum mark of 100. Plugging the numbers into the above formula, we get:

85 / 100 = 0.85 x 100 = 85% so the test percentage is 85%.

Now for a more complicated example where there are two tests or two test sections that are being scored. If a student scored 92 points on the first exam and 88 points on the second one, and the total marks they can get on both tests is 200, what is the percentage that the student scored? To calculate this, we first sum up the two marks and then apply the equation as usual:

(92 + 88) / 200 x 100 = 180 / 200 x 100 = 0.90 x 100 = 90% so the overall percentage mark is 90%.

The table below shows the test grades on a given examination and their corresponding percentages assuming a maximum mark of 200.

All test percentages in the table are computed using this exam percentage calculator.

    How to calculate the average percentage score for an entire class

The above method can be expanded to any number of marks, including calculations for the percentage scored by a whole class of students on a given test material, or even across class subjects which can be useful to educators as a measure of success. For example, with 20 students in a class, enter the 20 marks obtained in the "Scored" calculator field (separate by spaces or commas) and then the maximum possible score (e.g. 20x40 = 800 if each student can get a maximum of 40 points) in the "Out of" field.

Cite this calculator & page

If you'd like to cite this online calculator resource and information as provided on the page, you can use the following citation: Georgiev G.Z., "Marks Percentage Calculator" , [online] Available at: https://www.gigacalculator.com/calculators/marks-percentage-calculator.php URL [Accessed Date: 03 Sep, 2023].

     Other calculators

Percentage Calculator - Simply Calculate Percentages (%)

Percentage calculation tasks crop up all the time in everyday life. With the online percentage calculator, you are prepared for all kinds of percentage calculations. In the calculator, you can select examples of typical questions on percentage calculation. In this way, the percentage calculator guides you intuitively to your goal.

The most important topics for the Percentage Calculator

Functions of the percentage calculator.

Aside from the usual proportional percentage calculation , the percentage increase or decrease of the basic value is calculated with the percentage calculator using the percentage value and percentage number. In the info text of the calculator, the calculation path to the result of the percentage calculation is explained in detail, and the corresponding percentage formula is displayed.

Input Help for the Percentage Calculator

The following entries are required in the percentage calculator for the percentage calculation:

Input "Typical question"

Simply select a typical question suitable for your percentage calculation in the percentage calculator. According to the subdivision of the example questions, the percentage calculator offers different calculation types: In addition to the normal percentage calculation, there is also the possibility of calculating the percentage increase or decrease of the base value using percentage number and percentage value.

Input "Enter your values"

You can replace the example values given in the questions with your own values under "Enter your values" in order to carry out your own individual percentage calculation.

Depending on the typical question selected for the percentage calculation, the percentage calculator provides different input fields.

What is the Percentage Formula?

The percentage calculation can of course be expressed as a formula. The terms for percentage calculation are defined as follows:

The general percentage formula for calculating the percentage value W is:

Percentage Value = Basic Value × Percentage/100 or also W = G × p

This equation can now be rearranged as desired, depending on which quantity is known and which is not. If, for example, the calculation of the basic value is determined, the percentage number and percentage value can be entered into the calculator. The percentage calculator thus calculates either the percentage value, the basic value or the percentage. Two of these values must be entered in each case, in order to calculate the third value.

Definition of Technical Terms

The terms "Basic Value", "Percentage Value" and "Percentage" (also known as "Percentage Number") form the basis of all formulas in percentage calculation. The Percentage Value and the Basic Value always have the same unit (e.g., kg or euro), and the Percentage Number is a simple number. In the Percentage Calculator, as well as in general, two of the three values can be used for each question in order to calculate the third.

What is the Basic Value in Percentage Calculation?

In percentage calculation, the Base Value is the initial value that corresponds to 100 percent and to which the percentage refers. In formulas, this value is abbreviated with a G.

How is the Percentage Value Defined?

The Percentage Value has the same unit as the Basic Value (e.g., kg or euro). The Percentage Value can be smaller or larger than the Basic Value. The Percentage Value is the value derived from the Basic Value according to the Percentage. In formulas, this value or amount is abbreviated with a W.

What is the Percentage?

A percentage is the ratio of the percentage value to the basic value, expressed as a percentage. The percentage thus indicates the ratio of the two quantities in hundredths. In formulas, the percentage is abbreviated as p. Colloquially, this value is also called a percentage number and is always indicated with the percent sign. Percentages can also be well represented in decimal notation:

19 Percent = 19/100 = 0.19 119 Percent = 119/100 = 1.19

This simplifies, for example, the conversion of net amounts into gross amounts in bookkeeping, i.e., taking into account the VAT and, conversely, also the deduction of VAT.

The concepts of percentage calculation in practical examples

How does percentage calculation by rule of three work.

You can also calculate percentages using the “rule of three”. For example, if you want to calculate 5 percent of 300 euros, you can use the triple rule method to make the following calculation:

100 percent equals 300 euros

1 percent equals 300 euros / 100

5 percent equals 300 euros / 100 × 5 =  15 euros

Rule of three calculator

Examples of percentage calculation with formulas.

The total of nine selectable questions in the Percentage Calculator cover the typical tasks for calculating percentages:

For each of these tasks, one of the three values is calculated using the other two set values with the Percentage Calculator.

The formula for the percentage calculation can be rearranged as follows:

Example 1: Proportional Calculation - Calculation of the Percentage Value

Percentage task.

The following question can be selected with the percentage calculator and then filled in with your own numbers:

Mathematical formula for calculation

Concrete percentage calculation.

For a percentage of 10 percent and a base value of 120, the Percentage Calculator performs the following concrete calculation for the percentage value:

Application example

In practice, such a calculation often occurs in the case of a home loan: A loan amount is to be repaid at an initial interest rate of 2%. What is the annual repayment for a financing amount of 400,000 euros? The calculation: 2 percent × €400,000 = €8,000 .

Example 2: Proportional Calculation - Calculation of the Percentage

Here, the following question was selected with the percentage calculator, which can then be substantiated with your own figures:

Percentage formula

With a percentage value of 12 and a base value of 120, the Percentage Calculator performs the following concrete calculation for the percentage:

A question from everyday life could be: A bank statement shows an interest charge of 240 euros for the previous year. The loan amount for the instalment credit is still 6,000 euros. What is the interest rate? The calculation: €240 / €6,000 × 100 = 4% .

Example 3: Proportional Calculation - Calculation of the Basic Value

The following question can be selected with the percentage calculator and then assigned your own figures:

Mathematical formula for calculating

With a percentage value of 12 and an amount of 10 percent, the percentage calculator performs the following concrete calculation for the basic value:

Here is another example: The borrower finds the interest charge of 240 euros on the statement of account; he also knows that he is supposed to pay 4 percent per year on the outstanding balance. How much is left? The calculation: €240 / 4 percent = €6,000

Example 4: Percentage Increase - Calculation of the Percentage Value

The following question can be selected and then substantiated with your own figures:

The percentage calculator uses the following general formula to calculate the percentage value for the percentage problem or question at hand:

With a base value of 120 and a percentage equal to 10 percent:

This calculation is often used for

In the public sector, a 5 percent pay increase on the salary paid has been agreed upon.. What is the salary then, if it is currently 2,800 euros? Calculation: €2,800 + 5% = €2,800 × 1.05 = €2,940

Example 5: Percentage Increase - Calculation of the Percentage

The following question can be selected with the calculator and then assigned your own figures:

The percentage to be calculated is the percentage increase.

Mathematical formula

According to the percentage task or question posed here, the online calculator uses the following general formula to calculate the percentage:

With a percentage value of 132 and a basic value of 120, the calculator performs the following concrete calculation for the percentage:

An example from everyday life: A public-service employee wants to check how much the percentage salary increase on his pay slip is. Up to now, he has earned a gross salary of 3,000 euros, now 3,150 euros is shown. The calculation: (€3,150 / €3,000 − 1) × 100 = 5% .

Example 6: Percentage Increase - Calculation of the Basic Value

The following question can be selected with the tool and then substantiated with your own figures:

According to the percentage task or question posed, the tool uses the following calculation formula for the basic value:

With a percentage value of 132 and a percentage in the amount of 10 percent, our calculator performs the following concrete calculation for the basic value:

Here is another example from everyday life: In Germany, the average price of a liter of diesel this year was 1.10 euros, which is a 4 percent increase compared to the previous year. What was the price last year? The calculation: €1.10 / (1 + 4/100) = €1.10 / 1.04 = €1.058 .

Example 7: Percentage Decrease - Calculation of the Percentage Value

The percentage calculator uses the following general calculation formula for the percentage value to suit the percentage task or question at hand:

With a basic value of 120 and a percentage in the amount of 10 percent, the percentage calculator performs the following concrete calculation for the percentage:

The practical example of this is: Our above-mentioned average diesel price above 1.10 euros is expected to fall again this year by 2 percent. What value do the statisticians expect? The calculation: €1.10 × (1 − 2/100) = 1.10 × 0.98 = €1.078 .

Example 8: Percentage Decrease - Calculation of the Percentage

The following question can be selected with the online calculator and then backed up with your own figures:

The percentage calculator uses the following general calculation formula for the percentage to suit the percentage task or question at hand:

With a basic value of 120 and a percentage value of 132, the percentage calculator performs the following concrete calculation for the percentage:

Example 9: Percentage Decrease - Calculation of the Basic Value

The percentage calculator uses this formula for the calculation of the percentage task or question at hand:

With a percentage value of 120 and a percentage in the amount of 10 percent, the percentage calculator performs the following concrete calculation for the basic value:

More online calculators

Convert Roman Numerals , Triangle Calculator , Circle Calculation , Fraction Calculation , Speed Converter , Time Unit Converter , Convert Length Units , Calculator Online

Source information

As source for the information in the 'Percentage Calculation' category, we have used in particular:

Last update on February 20, 2023

The pages of the 'Percentage Calculation' category were last editorially reviewed by Michael Mühl on February 20, 2023. They all correspond to the current status.

Previous changes on December 16, 2020

Rate our calculator with just one click.

Stack Exchange Network

Stack Exchange network consists of 183 Q&A communities including Stack Overflow , the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

How to calculate a percentage of completed task in this spreadsheet?

I have the following spreadsheet. Basically Sam and Heather split out their assignment by task. When the task is complete, they mark it with Y in the Task Done column.

At the bottom, in yellow, I want to calculate the percentage of tasks done separately by Sam and Heather, based on the amount of tasks assigned to them and whether or not they marked it with a Y . I tried SUMIF function, but I think I am barking up the wrong tree.

Is it possible to do what I want using Excel? If so, how?

• microsoft-excel
• worksheet-function

Is there a column with the names? Assuming Sam/Heather in A2:A100 and Y if complete in B2:B100 then you can get the total tasks for Sam with

=COUNTIF(A2:A100,"Sam")

and the number of completed tasks for Sam with

=SUMPRODUCT((A2:A100="Sam")*(B2:B100="Y"))

so for a percentage completed just divide the latter by the former, i.e.

=SUMPRODUCT((A2:A100="Sam")*(B2:B100="Y"))/COUNTIF(A2:A100,"Sam")

....or an "array formula" can do that with a shorter formula, i.e.

=AVERAGE(IF(A2:A100="Sam",IF(B2:B100="Y",1,0)))

confirmed with CTRL+SHIFT+ENTER

For Google docs try

=arrayformula(AVERAGE(IF(A2:A13="Sam",IF(B2:B13="Y",1,0))))

format formula cell as percentage

• Hmmm, something is missing. I tried popping in the SUMPRODUCT formula, but all it says is: error: Range has no entry corresponding to this cell . The spreadsheet is editable, can you try it? –  AngryHacker Jan 2, 2013 at 0:47
• Oh, I see, It works perfectly fine in Excel, but not in Google Docs. I assumed that formula-wise at least they were equivalent. Will have to figure out how to do this in Google Docs. –  AngryHacker Jan 2, 2013 at 0:50
• In Google Docs try that last one with arratformula wrapped around it - I edited my answer to that effect –  barry houdini Jan 2, 2013 at 1:16
• Excellent, thank you. I did it the following way, which also worked: =COUNTA( IFERROR( FILTER( A2:A12 ; A2:A12 = "Heather" ; B2:B12 = "Y" ) ) ) . It's a hack, since it's relying on an error to be generated, but works for now. –  AngryHacker Jan 2, 2013 at 1:28

You must log in to answer this question.

Not the answer you're looking for browse other questions tagged microsoft-excel worksheet-function ..

• The Overflow Blog
• Journey to the cloud part I: Migrating Stack Overflow Teams to Azure
• Featured on Meta
• Our Design Vision for Stack Overflow and the Stack Exchange network

Hot Network Questions

• Tubular bells and timpani
• Terminal: How to move files to the last used directory conveniently?
• Can a conditional be both vacuously true and false?
• Can I assume normal distribution?
• Why can't I move my knight from d5 to c7?
• Defining a terminating `ripple`, with arguments swapping places
• The use of the expresssion 首の皮一枚繋がっている + で particle
• Typical pitch interval of the exclamation "uh-oh!"
• Implicit Models and Probability - are degrees of belief/truth/existence a complete free-for-all?
• How can Poisson distribution predict probability with so little information?
• Idiom for frustrating someone else's plans by taking what the other person wanted in the first place
• Main character is charged an exorbitant computing bill after abusing his uploaded consciousness powers
• Pure Math in Industry
• Glyph origin of 蝠
• Can randomness create patterns?
• Would it harm game balance to allow potions to be self-administered with a bonus action?
• What if no Republican candidate gets a majority of delegates for president?
• What did Canadians use to pay for goods or services between 1871 and 1935?
• Bijection between the set of all Partitions and the set of all Algebras
• Was the recent ruling against Jordan Peterson an infringement of his free speech?
• Why is there an article A before proper nouns? - He lacked the analytic processing power of a Hamilton and the philosophical depth of a Madison
• HDRI appears blocky (past blurry)
• Zener Transistor regulator cascaded into 3-pin IC regulator
• How can I make a Genus 3 Surface?

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy .

• Salary & Income Tax Calculators
• Mortgage Calculators
• Retirement Calculators
• Depreciation Calculators
• Statistics and Analysis Calculators
• Date and Time Calculators
• Contractor Calculators
• Budget & Savings Calculators
• Loan Calculators
• Forex Calculators
• Real Function Calculators
• Engineering Calculators
• Tax Calculators
• Volume Calculators
• 2D Shape Calculators
• 3D Shape Calculators
• Logistics Calculators
• HRM Calculators
• Sales & Investments Calculators
• Grade & GPA Calculators
• Conversion Calculators
• Ratio Calculators
• Sports & Health Calculators
• Other Calculators

PERT Calculator

This PERT calculator can be employed for swift computation of the likelihood of your project being completed within the desired timeframe, on the basis of the Program Evaluation and Review Technique (PERT).

The Program (sometimes Project) Evaluation and Review Technique, frequently shortened to PERT, is a way of analyzing the tasks required to complete a specific project, particularly the time each task requires, and to identify the minimum time required for completion of the whole project. PERT is most frequently employed for research projects when the length of any specific activity cannot be predicted, and so work is planned around a series of milestones.

Optimistic:

Most Likely:

Pessimistic:

Desired Completion Time:

How to Use the Calculator

Step 1: critical path task identification..

This is the longest potential time that will be needed to progress from start to finish. This will calculate the full length of time needed to complete a project and so any delays which arise on this pathway will postpone reaching the finishing event by the length of that delay at a minimum.

Step 2: Input your time estimates:

Optimistic: The shortest possible time needed to complete a task, on the assumption that everything progresses more swiftly than standard expectations.

Most Likely: The most probable length of time needed to complete a task, on the assumption that everything proceeds in line with standard expectations.

Pessimistic: The longest length of time needed to complete a task, on the assumption that everything that can go wrong, does go wrong.

For adding a new critical path task to the data table, click the "+ Add" button.

Step 3: Click the calculate button to view your results.

The PERT calculator will provide you with a table with the data below.

1. PERT Expected Time: a probability calculated on the basis of likely duration. This is a best estimate of how long a particular task will take, on the assumption that matters proceed in a standard fashion (this expected time being the average time that would be produced if this task were to be replicated numerous times over a long period). Formula: Expected Time = (Optimistic Time + 4 × Most Likely Time + Pessimistic Time) / 6

2. Standard Deviation: the average amount of deviation from the time estimates, depending on whether things go well or badly. Formula: Standard Deviation = (Pessimistic Time – Optimistic Time) / 6

3. Variance: the value spread across a standard distribution. Formula: Variance = (Standard Deviation) 2

Step 4: Input the amount of time you wish the project to take to check how likely it is that you will meet this target.

The probability of finishing the project within a specified time is calculated using the following basic formula:

Formula: Z = (Td − ∑te) / (∑V) 0.5

Z = Number of standard deviations of the normal distribution,

Td = Desired completion time for the project,

∑te = Expected completion time for the project,

∑V = Sum of the variances along the critical path.

• Currently 4.57/5

Rating: 4.6 /5 (344 votes)

Percent complete display and calculations

In the Graphical Scheduling application, you can display percent complete for work orders and tasks, and then calculate the percent complete for the parent work records and the schedule, helping your planner to keep projects on track.

The percent complete for work can be determined in three ways.

Physical percent complete

The physical percent complete is manually entered, and is an estimation by the user.

Actual percent complete

• The value can exceed 100%.
• The value is time-based by labor transactions (duration of work completed / total duration)
• The value is updated when labor hours are reported in work record applications.

Task percent complete

• For the average, it is calculated by dividing the number of the completed work segments by the total number of segments in the work (tasks completed / total # of tasks).
• For time-based calculations, it divides the number of work hours completed / number of total work hours required for the segment.

Percent calculation system property

The skd.percentcomplete.rollup system property determines how the calculation methods are rolled into the Graphical Scheduling application. By default, the property is set to 0, making the calculations time-based (based on reported hours). You can change the value to 1 to make the calculations based on averages.

For example, a schedule with task percent complete calculation has three tasks complete out of six total tasks. However, the span of the schedule is 19 hours, and the three task complete span 1 hour each. A value of 0 (time-based) in the skd.percentcomplete.rollup system property makes the Task Percent Complete 15% (3 hours / 19 hours). A value of 1 (average-based) in the skd.percentcomplete.rollup system property makes the Task Percent Complete 50% (3 tasks / 6 tasks).

• Displaying percent complete in the graphical view You can view the percentage of a schedule that is complete in the Graphical Scheduling application.

• Forgotten Your Password?

• Mark Forums Read
• Quick Links :
• What's New?
• Members List

Forum Rules

• Commercial Services
• Advanced Search

• Microsoft Office Application Help - Excel Help forum
• Excel Programming / VBA / Macros

Calculate Percentage of task completion with Checkboxes

Thread tools.

• Show Printable Version
• Subscribe to this Thread…

Rate This Thread

• Current Rating
• ‎ Excellent
• ‎ Average
• ‎ Terrible

I have a project management system I'm working on and need to calculate percentage of task completion based on tasks checked off. I've tried using the formula: The formula below works, but the problem I run into is not all milestones have five tasks. I need a way to factor in the variable of blank cells. I've done tons of research but nothing seems to apply to my specific situation. This site is great and I really appreciate those of you helping those of us who are technically deficient. =COUNTA(B5:B9)/5 The cells reflect the following: A B Task 1 check box Task 2 check box Task 3 check box Task 4 check box Task 5 check box TSK CPLT PERCENT : %

Re: Calculate Percentage of task completion with Checkboxes

Please Login or Register to view this content. new Clipboard(".copy2clipboard",{target:function(a){for(;a ? a.getAttribute?a.getAttribute?!/bbcode_description/.test(a.getAttribute("class")):null:null:null;)a=a.parentNode;for(var b=a.nextElementSibling;b?!b.classList.contains("bbcode_code"):null;)b=b.nextElementSibling;return b}}); Format the cell for % and that will do it

Last edited by optomyst; 11-18-2011 at 10:36 PM .

That formula works partially. If all the boxes next to a task are checked the total is accurate. However, if only some of the boxes are checked the formula returns a faulty value. For instance, I have one milestone that only has two tasks of the five... with both boxes checked it returns a value of 100%.... with only one box checked the value is %200. Sorry to be a pain, but I'm stoked that I'm almost there... I'm sure one of you smart folks can help me solve this. Thanks so much for the quick reply as well... I've been up all night trying to get this thing right.

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
• BB code is On
• Smilies are On
• [IMG] code is Off
• HTML code is Off
• Trackbacks are Off
• Pingbacks are Off
• Refbacks are Off
• ExcelForum.com

• Kutools for Excel
• Kutools for Word
• Kutools for Outlook
• How to Install or Uninstall
• End User License Agreement
• Tips & Tricks for Excel
• Tips & Tricks for Word
• Tips & Tricks for Outlook
• Excel Functions
• Excel Formulas
• Excel Charts
• Outlook Tutorials
• Office Tab Changelog
• Kutools for Excel Changelog
• Kutools for Outlook Changelog
• Kutools for Word Changelog
• User Testimonials Users Say
• Office Tab Feature Tutorials
• Kutools for Excel Feature Tutorials
• Kutools for Outlook Feature Tutorials
• Kutools for Word Feature Tutorials
• About Us Our Team
• Retrieve License Lost License?
• Report a Bug Bug Report
• Contact Us 24/7 email
• Forum Post in Forum
• Search Search more

How to change the percentage completed of tasks in Outlook?

In general, we can mark a task status as Not Stared , In Process, Waiting on someone else , Completes , etc. in Outlook. For more details, you can specify the percentage completes for a task, such as 30% completed . Thus, how could you change the percentage completed of tasks? There are two solutions:

Change one task’s percentage completed

Change multiple tasks’ percentage completed in the percentage column.

• Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by rules; Auto Reply without exchange server, and more automatic features...
• BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments , and more remind features...
• Reply (All) With All Attachments in the mail conversation; Reply Many Emails at once; Auto Add Greeting when reply; Auto Add Date&Time into subject...
• Attachment Tools : Auto Detach, Compress All, Rename All, Auto Save All... Quick Report , Count Selected Mails, Remove Duplicate Mails and Contacts...
• More than 100 advanced features will solve most of your problems in Outlook 2021 - 2010 or Office 365. Full features 60-day free trial.

For changing only one task’s percentage completed in Outlook, please do as follows:

1. In the Tasks view, double click to open the specified task whose percentage completed you want to change.

2. Please change the percentage completed in the % Complete box. See screenshot:

3. Click the File > Save & Close button to save the change.

For changing multiple tasks’ percentage completed in Outlook, you can add the % Complete column in the specified task folder, and then change the percentage completed of tasks in the folder easily.

1. In the Tasks view, please open the specified task folder where you will change the percentage completed of tasks.

2. Change the task view with clicking View > Change View > Detailed . See screenshot:

3. Go ahead to click View > Add Columns . See screenshot:

4. In the Show Columns dialog box, please do as below screenshot shown: (1) Click to select % Complete in the Available columns list box; (2) Click the Add button; (3) Keep the new % Complete column selected in the Show these columns in this order list box, and then click Move Up or Move Down button to change the new column’s order; (4) Click the OK button.

5. Now you return to the task folder, please type new percentages in cells of % Complete column to change corresponding tasks’ percentage completed one by one. See screenshot:

Related Articles

Hide completed tasks in Outlook

(Auto) archive completed tasks only in Outlook?

Recommended Productivity Tools for Outlook

Kutools for outlook - brings 100 advanced features to outlook, and make work much easier.

• Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features...
• BCC Warning - show message when you try to reply all if your mail address is in the BCC list ; Remind When Missing Attachments , and more remind features...
• Reply (All) With All Attachments in the mail conversation ; Reply Many Emails in seconds; Auto Add Greeting when reply; Add Date into subject...
• Attachment Tools: Manage All Attachments in All Mails, Auto Detach , Compress All , Rename All, Save All... Quick Report, Count Selected Mails ...
• Powerful Junk Emails by custom; Remove Duplicate Mails and Contacts ... Enable you to do smarter, faster and better in Outlook.

Percent (%) Work Complete fields

The % Work Complete fields contain the current status of a task, resource, or assignment, expressed as the percentage of work that has been completed. You can enter percent work complete, or you can have Project calculate it for you based on actual work on the task.

There are several categories of % Work Complete fields.

Data Type     Percentage

Percent (%) Work Complete (task field)

Entry Type     Calculated or entered

How Calculated     When a task is first created, the percent work complete is zero percent. If you enter actual work for the task, Project calculates percent work complete as follows:

Percent Work Complete = (Actual Work / Work) * 100

If you type a value in the % Work Complete field, Project automatically calculates actual work and remaining work. Similarly, entering a value in the Actual Work or Remaining Work field automatically recalculates the other fields.

Best Uses     Add the % Work Complete field to a task sheet when you want to display, filter, or edit percent work complete for tasks. If you type a value in the % Work Complete field, Project automatically calculates actual work and remaining work. If the % Work Complete field is set to a value greater than zero, the Actual Start field is set to the scheduled start date if you have not yet entered an actual start date. If the %Work Complete field is set to 100, the Actual Finish field is set to the scheduled finish date.

Example     The "Write proposal" task is scheduled for 40 hours of work. So far, the assigned resources have reported 10 hours of actual work on the task. Project calculates that the task is 25 percent work complete.

In addition, the "Conduct client meetings" task is scheduled for 32 hours of work. The assigned resources have reported that 16 hours of work have been completed. In the % Work Complete field, you enter 50 . The Actual Work field changes to 16 hours.

Remarks     By default, changes to a task's percent work complete value affect the actual work value. Similarly, changes to the actual work value affect its percent work complete value.

When you enter percent work complete, Project might adjust actual and remaining work around the current status date. If you prefer, you can leave these tracking fields in the project as originally scheduled, even if completed work is shown in the future or remaining work is shown in the past. You can do this in the Project Options dialog box.

You can set the status date to a date other than today's date in the Project Information dialog box.

Percent work complete indicates the status of the amount of work completed on a task so far. By contrast, percent complete indicates the status of the duration for a task so far.

Percent (%) Work Complete (resource field)

Entry Type     Calculated

Description     The % Work Complete field contains the current status of all tasks assigned to a resource expressed as the total percentage of the resource's work that has been completed.

How Calculated     When a resource is first added, the percent work complete for the resource is zero percent. As soon as tasks are assigned to the resource, and any actual work or percent work complete is entered for any of the resource's assignments, the total percent work complete for the resource is calculated. Project calculates the resource's percent work complete as follows:

Best Uses     Add the % Work Complete field to a resource sheet when you want to display or filter that percent work complete for a resource. This can help you review how a resource is progressing on all assigned tasks.

Example     Jamie is assigned to four tasks for a total of 40 hours of work. Until Jamie reports any actual work on any of the tasks, the percent work complete is zero. Jamie reports that five hours of work has been done on one task, and 15 hours of work has been done on another task. Because 20 hours of actual work has been performed out of 40 hours of total work scheduled, Project calculates that Jamie has 50 percent work complete on all assigned tasks.

Percent (%) Work Complete (assignment field)

Description     The % Work Complete field contains the current status of an assignment expressed as the percentage of the assignment's work that has been completed. You can enter percent work complete, or you can have Project calculate it for you based on actual work on the assignment.

How Calculated     When an assignment is first made, the percent work complete is zero. If you enter actual work for the assignment, Project calculates percent work complete as follows:

If you type a value in the % Work Complete field, Project automatically calculates actual work and remaining work. If the % Work Complete field is set to a value greater than zero, the Actual Start field is set to the scheduled start date if you have not yet entered an actual start date. If the % Work Complete field is set to 100, the Actual Finish field is set to the scheduled finish date. Similarly, entering a value in the Actual Work or Remaining Work field automatically recalculates the other fields.

Best Uses     Add the % Work Complete field to the sheet portion of the Task Usage or Resource Usage view when you want to display, filter, or edit percent work complete for assignments.

Example     Jamie is assigned to the "Write proposal" task for 40 hours of work. So far, Jamie has reported 20 hours of actual work on this assignment. Project calculates that the assignment is 50 percent work complete.

In addition, Jamie is assigned to 32 hours of work for the "Conduct client meetings" task. Jamie has reported that 16 hours have just been completed. In the % Work Complete field, you enter 50 . The Actual Work field changes to 16 hours.

When you enter % Work Complete, Project might adjust actual and remaining work around the current status date. If you prefer, you can leave these tracking fields in the project as originally scheduled, even if completed work is shown in the future or remaining work is shown in the past. You can do this in the Project Options dialog box.

Percent work complete indicates the status of the amount of work completed on the assignment so far. By contrast, percent complete indicates the status of the duration for the task.

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.