Converting Finish Variance to total Calendar days

[Dan Roach]

Hi

I am trying to use a custom number field to calculate the total number of
calendar days between 'Baseline Finish' and 'Actual Finish'. I want the value
to represent all working and non-working time between the 2 dates.
Thank you very much for any advice or solutions.

Dan

 

[Manmeet Chaudhari]

Hi Dan,
Try out the following steps.
1. Tools- Customize- fields.
2. Click on task and in the type option select number
3. Give it a specific name by renaming it.
4. Click on formula select fields
5. Goto dates select baseline finish
6. Click the minus sign
7. Again goto fields and now select actual finish date.
8. Click ok and
This is one approach, another one is to use projdatediff function.
Refer to the following link

http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html

Hope it helps

Regard,
Manmeet Chaudhari
Technical Trainer
Maestros Mediline Systems Ltd
Mumbai

 

[Haris Rashid]

hi Dan,

You can use the following formula in the number field in MS Project. Simply
paste it, for example, in the Number1 field:

DateDiff("d",[Baseline Finish],[Actual Finish])

Regards

 

[Dan Roach]

Dear Harris and Manmeet

Thank you very much for your helpful response.

Dan

hi Dan,

You can use the following formula in the number field in MS Project. Simply
paste it, for example, in the Number1 field:

DateDiff("d",[Baseline Finish],[Actual Finish])

Regards
------------
Haris
http://www.manage-systems.com
---------------------------------------

Hi

I am trying to use a custom number field to calculate the total number of
calendar days between 'Baseline Finish' and 'Actual Finish'. I want the value
to represent all working and non-working time between the 2 dates.
Thank you very much for any advice or solutions.

Dan

 

[Penny]

Hi Dan. I was searching for this exact answer and found it. Was very
helpful. I applied your formula on 2003 Std and it worked great. I am now
trying to apply it on 2003 Professional and am not having the same
experience. Would the formula differ in 2003 Prof?

thank you.

Penny

hi Dan,

You can use the following formula in the number field in MS Project. Simply
paste it, for example, in the Number1 field:

DateDiff("d",[Baseline Finish],[Actual Finish])

Regards
------------
Haris
http://www.manage-systems.com
---------------------------------------

Hi

I am trying to use a custom number field to calculate the total number of
calendar days between 'Baseline Finish' and 'Actual Finish'. I want the value
to represent all working and non-working time between the 2 dates.
Thank you very much for any advice or solutions.

Dan

 

[Jan De Messemaeker]

Hi,

No, both versions give the same result.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Hi Dan. I was searching for this exact answer and found it. Was very
helpful. I applied your formula on 2003 Std and it worked great. I am
now
trying to apply it on 2003 Professional and am not having the same
experience. Would the formula differ in 2003 Prof?

thank you.

Penny

hi Dan,

You can use the following formula in the number field in MS Project.
Simply
paste it, for example, in the Number1 field:

DateDiff("d",[Baseline Finish],[Actual Finish])

Regards
------------
Haris
http://www.manage-systems.com
---------------------------------------

Hi

I am trying to use a custom number field to calculate the total number
of
calendar days between 'Baseline Finish' and 'Actual Finish'. I want the
value
to represent all working and non-working time between the 2 dates.
Thank you very much for any advice or solutions.

Dan

 

[Penny]

Thank you Jan for your response.

Okay I should be able to do this in Pro... I am not being successful but am
also having some other things that I can't do in the pro that I can do in my
std so maybe I need to have someone from our CSU look at it.

Again thanks for your help. And.. if you can think of anything else that I
could look at to trouble shoot why I am not getting the same results in Pro I
would apprecite it.
Penny

Hi,

No, both versions give the same result.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Hi Dan. I was searching for this exact answer and found it. Was very
helpful. I applied your formula on 2003 Std and it worked great. I am
now
trying to apply it on 2003 Professional and am not having the same
experience. Would the formula differ in 2003 Prof?

thank you.

Penny

hi Dan,

You can use the following formula in the number field in MS Project.
Simply
paste it, for example, in the Number1 field:

DateDiff("d",[Baseline Finish],[Actual Finish])

Regards
------------
Haris
http://www.manage-systems.com
---------------------------------------

:

Hi

I am trying to use a custom number field to calculate the total number
of
calendar days between 'Baseline Finish' and 'Actual Finish'. I want the
value
to represent all working and non-working time between the 2 dates.
Thank you very much for any advice or solutions.

Dan

 

[Jan De Messemaeker]

Hi,

Pro as such will allow everything Standard can.
But, if you have your Pro connected to Project Server, the Server
Administrator can and will impose some rules such as you cannot change the
default calendar or some resource properties etc., but that is Server, not
Pro itself.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Thank you Jan for your response.

Okay I should be able to do this in Pro... I am not being successful but
am
also having some other things that I can't do in the pro that I can do in
my
std so maybe I need to have someone from our CSU look at it.

Again thanks for your help. And.. if you can think of anything else that
I
could look at to trouble shoot why I am not getting the same results in
Pro I
would apprecite it.
Penny

Hi,

No, both versions give the same result.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Hi Dan. I was searching for this exact answer and found it. Was very
helpful. I applied your formula on 2003 Std and it worked great. I am
now
trying to apply it on 2003 Professional and am not having the same
experience. Would the formula differ in 2003 Prof?

thank you.

Penny

:

hi Dan,

You can use the following formula in the number field in MS Project.
Simply
paste it, for example, in the Number1 field:

DateDiff("d",[Baseline Finish],[Actual Finish])

Regards
------------
Haris
http://www.manage-systems.com
---------------------------------------

:

Hi

I am trying to use a custom number field to calculate the total
number
of
calendar days between 'Baseline Finish' and 'Actual Finish'. I want
the
value
to represent all working and non-working time between the 2 dates.
Thank you very much for any advice or solutions.

Dan

 

[Penny]

This works great for me. One more question please. This formular does not
work for calculating a delta on summary tasks. Is there something that I can
add into this formula to make it give me a delta on a summary task? Taking
early finish and subtracting a finish 1 custom code field... again all on a
summary task?

Penny

hi Dan,

You can use the following formula in the number field in MS Project. Simply
paste it, for example, in the Number1 field:

DateDiff("d",[Baseline Finish],[Actual Finish])

Regards
------------
Haris
http://www.manage-systems.com
---------------------------------------

Hi

I am trying to use a custom number field to calculate the total number of
calendar days between 'Baseline Finish' and 'Actual Finish'. I want the value
to represent all working and non-working time between the 2 dates.
Thank you very much for any advice or solutions.

Dan

 

[JulieS]

Hi Penny,

Make sure in the Customize Fields dialog box you select the "Use
formula" option for Group and Summary rows.

This works great for me. One more question please. This formular
does not
work for calculating a delta on summary tasks. Is there something
that I can
add into this formula to make it give me a delta on a summary
task? Taking
early finish and subtracting a finish 1 custom code field...
again all on a
summary task?

Penny

hi Dan,

You can use the following formula in the number field in MS
Project. Simply
paste it, for example, in the Number1 field:

DateDiff("d",[Baseline Finish],[Actual Finish])

Regards
------------
Haris
http://www.manage-systems.com
---------------------------------------

Hi

I am trying to use a custom number field to calculate the total
number of
calendar days between 'Baseline Finish' and 'Actual Finish'. I
want the value
to represent all working and non-working time between the 2
dates.
Thank you very much for any advice or solutions.

Dan

 

[JulieS]

Great to hear Penny. You're welcome for the help and thanks for the
feedback.

Julie

Thanks so much Julie. Got it and working like a charm.

Hi Penny,

Make sure in the Customize Fields dialog box you select the "Use
formula" option for Group and Summary rows.

This works great for me. One more question please. This
formular
does not
work for calculating a delta on summary tasks. Is there
something
that I can
add into this formula to make it give me a delta on a summary
task? Taking
early finish and subtracting a finish 1 custom code field...
again all on a
summary task?

Penny

:

hi Dan,

You can use the following formula in the number field in MS
Project. Simply
paste it, for example, in the Number1 field:

DateDiff("d",[Baseline Finish],[Actual Finish])

Regards
------------
Haris
http://www.manage-systems.com
---------------------------------------

:

Hi

I am trying to use a custom number field to calculate the
total
number of
calendar days between 'Baseline Finish' and 'Actual Finish'.
I
want the value
to represent all working and non-working time between the 2
dates.
Thank you very much for any advice or solutions.

Dan