Project Server Duration Percentage Spent

[Turki Ben Sumih]

Dear Friends,
Could you lease help me providing me with a formula to calculate the project
duration spent % ?
Thanks in Adnvanced !

 

[Dale Howard [MVP]]

Turki --

Microsoft Project calculates the % Complete value, which actually represents
% Duration Complete, as follows:

% Complete = (Actual Duration/Duration) * 100

If you use the Hours of work per day or per week method of tracking in PWA,
with actuals entered on a daily basis, then the % Complete value for any
task represents the percentage of the Duration "used up" to date on the
task. Hope this helps.

 

[Turki Ben Sumih]

Dale Howard --
Thank you So much, it helped me

 

[Turki Ben Sumih]

Dale Howard --
i noticed that this formula calculates the work complete where it reflects
the percentage of completion,what i need is a formula to calculate project
duration spent over the project age enven without update the % complete

 

[Dale Howard [MVP]]

Turki --

I'm really not sure what you are looking for. Perhaps you need to explore
Earned Value Analysis for this purpose. Hope this helps.

 

[Turki Ben Sumih]

Dear Dale
I need a formula to calculate the project duration spent time even without
any update to the work complete (spent duration/duration)

 

[Dale Howard [MVP]]

PMO --

I think you are looking for something like Elapsed Duration, which would
require the use of a custom field and formula. To calculate this, you would
need a custom enterprise Project field that calculates the difference
between today's date and the Start date of the project, divided by the
Duration of the project. Hope this helps.

 

[Turki Ben Sumih]

Dale Howard --
I think your solution will help me,So could you please write down the
formula if you dont mind ?

 

[Dale Howard [MVP]]

PMO --

Create a new custom enterprise Project text field and rename it as something
like Elapsed Duration. Enter the following custom Formula in the field:

(ProjDateDiff([Start],[Current Date])/480)/([Duration]/480)*100 & "%"

In the preceding formula, if you don't want to use the Current Date, then
use the Status Date instead, but remember to specify the Status Date in
Project - Project Information. I think you'll get the general idea from
there. Hope this helps.

 

[Turki Ben Sumih]

Dale --
I'm So happy with you helped so much, but how can i remove the digits from
the result percentage.It gives me79.12135874477 % i need only 79% .
--
PMO Specialist

PMO --

Create a new custom enterprise Project text field and rename it as something
like Elapsed Duration. Enter the following custom Formula in the field:

(ProjDateDiff([Start],[Current Date])/480)/([Duration]/480)*100 & "%"

In the preceding formula, if you don't want to use the Current Date, then
use the Status Date instead, but remember to specify the Status Date in
Project - Project Information. I think you'll get the general idea from
there. Hope this helps.

Dale Howard --
I think your solution will help me,So could you please write down the
formula if you dont mind ?

 

[Turki Ben Sumih]

Dale --
I have a second question,
when i calculate your formula for the old closed projects, it gives me over
100% .
Can you provide me with a formula to not go over 100% closed old projects.
Thanks !!!!!
--
PMO Specialist

PMO --

Create a new custom enterprise Project text field and rename it as something
like Elapsed Duration. Enter the following custom Formula in the field:

(ProjDateDiff([Start],[Current Date])/480)/([Duration]/480)*100 & "%"

In the preceding formula, if you don't want to use the Current Date, then
use the Status Date instead, but remember to specify the Status Date in
Project - Project Information. I think you'll get the general idea from
there. Hope this helps.

Dale Howard --
I think your solution will help me,So could you please write down the
formula if you dont mind ?

 

[Dale Howard [MVP]]

PMO --

To answer both of your questions, copy the following formula into an
enterprise Project text field:

IIf([Current Date]>[Finish],100,Format((ProjDateDiff([Start],[Current
Date],"Standard")/480)/([Duration]/480)*100,"0")) & "%"

You also need to know that I have reached the end of line of line offering
you free help on this formula, as I think I have done more than enough to
get you going in the right direction. At this point, I would like you to
study the above formula to determine how I wrote it and why, and what each
function performs in the formula. If you do not understand the formula, let
me know and I will explain it. Otherwise, I believe it will meet the
criteria presented in your last two posts. Hope this helps.

Dale --
I have a second question,
when i calculate your formula for the old closed projects, it gives me
over
100% .
Can you provide me with a formula to not go over 100% closed old projects.
Thanks !!!!!
--
PMO Specialist

PMO --

Create a new custom enterprise Project text field and rename it as
something
like Elapsed Duration. Enter the following custom Formula in the field:

(ProjDateDiff([Start],[Current Date])/480)/([Duration]/480)*100 & "%"

In the preceding formula, if you don't want to use the Current Date, then
use the Status Date instead, but remember to specify the Status Date in
Project - Project Information. I think you'll get the general idea from
there. Hope this helps.




message

Dale Howard --
I think your solution will help me,So could you please write down the
formula if you dont mind ?
--
PMO Specialist


:

PMO --

I think you are looking for something like Elapsed Duration, which
would
require the use of a custom field and formula. To calculate this, you
would
need a custom enterprise Project field that calculates the difference
between today's date and the Start date of the project, divided by the
Duration of the project. Hope this helps.




message
Dear Dale
I need a formula to calculate the project duration spent time even
without
any update to the work complete (spent duration/duration)
--
PMO Specialist


:

Turki --

I'm really not sure what you are looking for. Perhaps you need to
explore
Earned Value Analysis for this purpose. Hope this helps.




in
message
Dale Howard --
i noticed that this formula calculates the work complete where it
reflects
the percentage of completion,what i need is a formula to
calculate
project
duration spent over the project age enven without update the %
complete
--
PMO Specialist


:

Turki --

Microsoft Project calculates the % Complete value, which
actually
represents
% Duration Complete, as follows:

% Complete = (Actual Duration/Duration) * 100

If you use the Hours of work per day or per week method of
tracking
in
PWA,
with actuals entered on a daily basis, then the % Complete value
for
any
task represents the percentage of the Duration "used up" to date
on
the
task. Hope this helps.




"Turki Ben Sumih" <[email protected]>
wrote
in
message
Dear Friends,
Could you lease help me providing me with a formula to
calculate
the
project
duration spent % ?
Thanks in Adnvanced !

 

[Turki Ben Sumih]

Dale --
Thank you So So So SO So SO Much you really helped me may god make you happy
all your life.
--
PMO Specialist

PMO --

To answer both of your questions, copy the following formula into an
enterprise Project text field:

IIf([Current Date]>[Finish],100,Format((ProjDateDiff([Start],[Current
Date],"Standard")/480)/([Duration]/480)*100,"0")) & "%"

You also need to know that I have reached the end of line of line offering
you free help on this formula, as I think I have done more than enough to
get you going in the right direction. At this point, I would like you to
study the above formula to determine how I wrote it and why, and what each
function performs in the formula. If you do not understand the formula, let
me know and I will explain it. Otherwise, I believe it will meet the
criteria presented in your last two posts. Hope this helps.

Dale --
I have a second question,
when i calculate your formula for the old closed projects, it gives me
over
100% .
Can you provide me with a formula to not go over 100% closed old projects.
Thanks !!!!!
--
PMO Specialist

PMO --

Create a new custom enterprise Project text field and rename it as
something
like Elapsed Duration. Enter the following custom Formula in the field:

(ProjDateDiff([Start],[Current Date])/480)/([Duration]/480)*100 & "%"

In the preceding formula, if you don't want to use the Current Date, then
use the Status Date instead, but remember to specify the Status Date in
Project - Project Information. I think you'll get the general idea from
there. Hope this helps.




message
Dale Howard --
I think your solution will help me,So could you please write down the
formula if you dont mind ?
--
PMO Specialist


:

PMO --

I think you are looking for something like Elapsed Duration, which
would
require the use of a custom field and formula. To calculate this, you
would
need a custom enterprise Project field that calculates the difference
between today's date and the Start date of the project, divided by the
Duration of the project. Hope this helps.




message
Dear Dale
I need a formula to calculate the project duration spent time even
without
any update to the work complete (spent duration/duration)
--
PMO Specialist


:

Turki --

I'm really not sure what you are looking for. Perhaps you need to
explore
Earned Value Analysis for this purpose. Hope this helps.




in
message
Dale Howard --
i noticed that this formula calculates the work complete where it
reflects
the percentage of completion,what i need is a formula to
calculate
project
duration spent over the project age enven without update the %
complete
--
PMO Specialist


:

Turki --

Microsoft Project calculates the % Complete value, which
actually
represents
% Duration Complete, as follows:

% Complete = (Actual Duration/Duration) * 100

If you use the Hours of work per day or per week method of
tracking
in
PWA,
with actuals entered on a daily basis, then the % Complete value
for
any
task represents the percentage of the Duration "used up" to date
on
the
task. Hope this helps.




"Turki Ben Sumih" <[email protected]>
wrote
in
message
Dear Friends,
Could you lease help me providing me with a formula to
calculate
the
project
duration spent % ?
Thanks in Adnvanced !

 

[Dale Howard [MVP]]

PMO --

You are more than welcome, my friend!

Dale --
Thank you So So So SO So SO Much you really helped me may god make you
happy
all your life.
--
PMO Specialist

PMO --

To answer both of your questions, copy the following formula into an
enterprise Project text field:

IIf([Current Date]>[Finish],100,Format((ProjDateDiff([Start],[Current
Date],"Standard")/480)/([Duration]/480)*100,"0")) & "%"

You also need to know that I have reached the end of line of line
offering
you free help on this formula, as I think I have done more than enough to
get you going in the right direction. At this point, I would like you to
study the above formula to determine how I wrote it and why, and what
each
function performs in the formula. If you do not understand the formula,
let
me know and I will explain it. Otherwise, I believe it will meet the
criteria presented in your last two posts. Hope this helps.




message

Dale --
I have a second question,
when i calculate your formula for the old closed projects, it gives me
over
100% .
Can you provide me with a formula to not go over 100% closed old
projects.
Thanks !!!!!
--
PMO Specialist


:

PMO --

Create a new custom enterprise Project text field and rename it as
something
like Elapsed Duration. Enter the following custom Formula in the
field:

(ProjDateDiff([Start],[Current Date])/480)/([Duration]/480)*100 & "%"

In the preceding formula, if you don't want to use the Current Date,
then
use the Status Date instead, but remember to specify the Status Date
in
Project - Project Information. I think you'll get the general idea
from
there. Hope this helps.




message
Dale Howard --
I think your solution will help me,So could you please write down
the
formula if you dont mind ?
--
PMO Specialist


:

PMO --

I think you are looking for something like Elapsed Duration, which
would
require the use of a custom field and formula. To calculate this,
you
would
need a custom enterprise Project field that calculates the
difference
between today's date and the Start date of the project, divided by
the
Duration of the project. Hope this helps.




in
message
Dear Dale
I need a formula to calculate the project duration spent time
even
without
any update to the work complete (spent duration/duration)
--
PMO Specialist


:

Turki --

I'm really not sure what you are looking for. Perhaps you need
to
explore
Earned Value Analysis for this purpose. Hope this helps.




"Turki Ben Sumih" <[email protected]>
wrote
in
message
Dale Howard --
i noticed that this formula calculates the work complete where
it
reflects
the percentage of completion,what i need is a formula to
calculate
project
duration spent over the project age enven without update the %
complete
--
PMO Specialist


:

Turki --

Microsoft Project calculates the % Complete value, which
actually
represents
% Duration Complete, as follows:

% Complete = (Actual Duration/Duration) * 100

If you use the Hours of work per day or per week method of
tracking
in
PWA,
with actuals entered on a daily basis, then the % Complete
value
for
any
task represents the percentage of the Duration "used up" to
date
on
the
task. Hope this helps.




"Turki Ben Sumih" <[email protected]>
wrote
in
message
Dear Friends,
Could you lease help me providing me with a formula to
calculate
the
project
duration spent % ?
Thanks in Adnvanced !

 

[Turki Ben Sumih]

Dear Dale:
How are you ?
Could you Please explain to me for the last formula why did you write 480 ?
--
PMO Specialist

PMO --

You are more than welcome, my friend!

Dale --
Thank you So So So SO So SO Much you really helped me may god make you
happy
all your life.
--
PMO Specialist

PMO --

To answer both of your questions, copy the following formula into an
enterprise Project text field:

IIf([Current Date]>[Finish],100,Format((ProjDateDiff([Start],[Current
Date],"Standard")/480)/([Duration]/480)*100,"0")) & "%"

You also need to know that I have reached the end of line of line
offering
you free help on this formula, as I think I have done more than enough to
get you going in the right direction. At this point, I would like you to
study the above formula to determine how I wrote it and why, and what
each
function performs in the formula. If you do not understand the formula,
let
me know and I will explain it. Otherwise, I believe it will meet the
criteria presented in your last two posts. Hope this helps.




message
Dale --
I have a second question,
when i calculate your formula for the old closed projects, it gives me
over
100% .
Can you provide me with a formula to not go over 100% closed old
projects.
Thanks !!!!!
--
PMO Specialist


:

PMO --

Create a new custom enterprise Project text field and rename it as
something
like Elapsed Duration. Enter the following custom Formula in the
field:

(ProjDateDiff([Start],[Current Date])/480)/([Duration]/480)*100 & "%"

In the preceding formula, if you don't want to use the Current Date,
then
use the Status Date instead, but remember to specify the Status Date
in
Project - Project Information. I think you'll get the general idea
from
there. Hope this helps.




message
Dale Howard --
I think your solution will help me,So could you please write down
the
formula if you dont mind ?
--
PMO Specialist


:

PMO --

I think you are looking for something like Elapsed Duration, which
would
require the use of a custom field and formula. To calculate this,
you
would
need a custom enterprise Project field that calculates the
difference
between today's date and the Start date of the project, divided by
the
Duration of the project. Hope this helps.




in
message
Dear Dale
I need a formula to calculate the project duration spent time
even
without
any update to the work complete (spent duration/duration)
--
PMO Specialist


:

Turki --

I'm really not sure what you are looking for. Perhaps you need
to
explore
Earned Value Analysis for this purpose. Hope this helps.




"Turki Ben Sumih" <[email protected]>
wrote
in
message
Dale Howard --
i noticed that this formula calculates the work complete where
it
reflects
the percentage of completion,what i need is a formula to
calculate
project
duration spent over the project age enven without update the %
complete
--
PMO Specialist


:

Turki --

Microsoft Project calculates the % Complete value, which
actually
represents
% Duration Complete, as follows:

% Complete = (Actual Duration/Duration) * 100

If you use the Hours of work per day or per week method of
tracking
in
PWA,
with actuals entered on a daily basis, then the % Complete
value
for
any
task represents the percentage of the Duration "used up" to
date
on
the
task. Hope this helps.




"Turki Ben Sumih" <[email protected]>
wrote
in
message
Dear Friends,
Could you lease help me providing me with a formula to
calculate
the
project
duration spent % ?
Thanks in Adnvanced !

 

[Dale Howard [MVP]]

Turki --

In the Project Server database, the system stores both Work and Duration in
minutes. Divide by 60 to convert to Hours and divide by 480 to convert to
Days. Hope this helps.

Dear Dale:
How are you ?
Could you Please explain to me for the last formula why did you write 480
?
--
PMO Specialist

PMO --

You are more than welcome, my friend!




message

Dale --
Thank you So So So SO So SO Much you really helped me may god make you
happy
all your life.
--
PMO Specialist


:

PMO --

To answer both of your questions, copy the following formula into an
enterprise Project text field:

IIf([Current Date]>[Finish],100,Format((ProjDateDiff([Start],[Current
Date],"Standard")/480)/([Duration]/480)*100,"0")) & "%"

You also need to know that I have reached the end of line of line
offering
you free help on this formula, as I think I have done more than enough
to
get you going in the right direction. At this point, I would like you
to
study the above formula to determine how I wrote it and why, and what
each
function performs in the formula. If you do not understand the
formula,
let
me know and I will explain it. Otherwise, I believe it will meet the
criteria presented in your last two posts. Hope this helps.




message
Dale --
I have a second question,
when i calculate your formula for the old closed projects, it gives
me
over
100% .
Can you provide me with a formula to not go over 100% closed old
projects.
Thanks !!!!!
--
PMO Specialist


:

PMO --

Create a new custom enterprise Project text field and rename it as
something
like Elapsed Duration. Enter the following custom Formula in the
field:

(ProjDateDiff([Start],[Current Date])/480)/([Duration]/480)*100 &
"%"

In the preceding formula, if you don't want to use the Current
Date,
then
use the Status Date instead, but remember to specify the Status
Date
in
Project - Project Information. I think you'll get the general idea
from
there. Hope this helps.




in
message
Dale Howard --
I think your solution will help me,So could you please write down
the
formula if you dont mind ?
--
PMO Specialist


:

PMO --

I think you are looking for something like Elapsed Duration,
which
would
require the use of a custom field and formula. To calculate
this,
you
would
need a custom enterprise Project field that calculates the
difference
between today's date and the Start date of the project, divided
by
the
Duration of the project. Hope this helps.




"Turki Ben Sumih" <[email protected]>
wrote
in
message
Dear Dale
I need a formula to calculate the project duration spent time
even
without
any update to the work complete (spent duration/duration)
--
PMO Specialist


:

Turki --

I'm really not sure what you are looking for. Perhaps you
need
to
explore
Earned Value Analysis for this purpose. Hope this helps.




"Turki Ben Sumih" <[email protected]>
wrote
in
message
Dale Howard --
i noticed that this formula calculates the work complete
where
it
reflects
the percentage of completion,what i need is a formula to
calculate
project
duration spent over the project age enven without update
the %
complete
--
PMO Specialist


:

Turki --

Microsoft Project calculates the % Complete value, which
actually
represents
% Duration Complete, as follows:

% Complete = (Actual Duration/Duration) * 100

If you use the Hours of work per day or per week method of
tracking
in
PWA,
with actuals entered on a daily basis, then the % Complete
value
for
any
task represents the percentage of the Duration "used up"
to
date
on
the
task. Hope this helps.




"Turki Ben Sumih"
<[email protected]>
wrote
in
message
Dear Friends,
Could you lease help me providing me with a formula to
calculate
the
project
duration spent % ?
Thanks in Adnvanced !

 

[Turki Ben Sumih]

Dear Dale,
I slightly did not understand but is 480 used because of standard calendar
where the month equals 40 days
--
PMO Specialist

Turki --

In the Project Server database, the system stores both Work and Duration in
minutes. Divide by 60 to convert to Hours and divide by 480 to convert to
Days. Hope this helps.

Dear Dale:
How are you ?
Could you Please explain to me for the last formula why did you write 480
?
--
PMO Specialist

PMO --

You are more than welcome, my friend!




message
Dale --
Thank you So So So SO So SO Much you really helped me may god make you
happy
all your life.
--
PMO Specialist


:

PMO --

To answer both of your questions, copy the following formula into an
enterprise Project text field:

IIf([Current Date]>[Finish],100,Format((ProjDateDiff([Start],[Current
Date],"Standard")/480)/([Duration]/480)*100,"0")) & "%"

You also need to know that I have reached the end of line of line
offering
you free help on this formula, as I think I have done more than enough
to
get you going in the right direction. At this point, I would like you
to
study the above formula to determine how I wrote it and why, and what
each
function performs in the formula. If you do not understand the
formula,
let
me know and I will explain it. Otherwise, I believe it will meet the
criteria presented in your last two posts. Hope this helps.




message
Dale --
I have a second question,
when i calculate your formula for the old closed projects, it gives
me
over
100% .
Can you provide me with a formula to not go over 100% closed old
projects.
Thanks !!!!!
--
PMO Specialist


:

PMO --

Create a new custom enterprise Project text field and rename it as
something
like Elapsed Duration. Enter the following custom Formula in the
field:

(ProjDateDiff([Start],[Current Date])/480)/([Duration]/480)*100 &
"%"

In the preceding formula, if you don't want to use the Current
Date,
then
use the Status Date instead, but remember to specify the Status
Date
in
Project - Project Information. I think you'll get the general idea
from
there. Hope this helps.




in
message
Dale Howard --
I think your solution will help me,So could you please write down
the
formula if you dont mind ?
--
PMO Specialist


:

PMO --

I think you are looking for something like Elapsed Duration,
which
would
require the use of a custom field and formula. To calculate
this,
you
would
need a custom enterprise Project field that calculates the
difference
between today's date and the Start date of the project, divided
by
the
Duration of the project. Hope this helps.




"Turki Ben Sumih" <[email protected]>
wrote
in
message
Dear Dale
I need a formula to calculate the project duration spent time
even
without
any update to the work complete (spent duration/duration)
--
PMO Specialist


:

Turki --

I'm really not sure what you are looking for. Perhaps you
need
to
explore
Earned Value Analysis for this purpose. Hope this helps.




"Turki Ben Sumih" <[email protected]>
wrote
in
message
Dale Howard --
i noticed that this formula calculates the work complete
where
it
reflects
the percentage of completion,what i need is a formula to
calculate
project
duration spent over the project age enven without update
the %
complete
--
PMO Specialist


:

Turki --

Microsoft Project calculates the % Complete value, which
actually
represents
% Duration Complete, as follows:

% Complete = (Actual Duration/Duration) * 100

If you use the Hours of work per day or per week method of
tracking
in
PWA,
with actuals entered on a daily basis, then the % Complete
value
for
any
task represents the percentage of the Duration "used up"
to
date
on
the
task. Hope this helps.




"Turki Ben Sumih"
<[email protected]>
wrote
in
message
Dear Friends,
Could you lease help me providing me with a formula to
calculate
the
project
duration spent % ?
Thanks in Adnvanced !

 

[tonyzink]

Actually, I don't think that you need the 480 terms in the formula,
since there is a 480 in the numerator and a 480 in the denominator, so
they should cancel each other out.

It may be helpful to keep them, however, for educational purposes,
since MSProject calculates durations in minutes, and most people like
to show task durations in days. Here is what the 480 means:

(8hrs per standard workday) * (60min per hour) = 480min per standard
workday

So... when MSProject calculates a task duration, the result is returned
in minutes, rather than days. To return a duration in days, divide the
result by 480.

Good luck!

Tony Zink
========================================
http://www.msprojectreporter.com
http://www.pmreporter.com
http://www.sharepointreporter.com
http://www.msofficereporter.com
http://www.dotnetreporter.com
========================================

 

[Turki Ben Sumih]

Thanks Tonyzin & Dale for your help