Project Function

[Turki Ben Sumih]

dear All,
I am a project server administartor.One of my responsibilities is to create
custom fields with formula.The question is that how can i create i a field
that shows only the duration in months instead of days using formula.

Regards,

 

[Gérard Ducouret]

Hello,
First of all, have you set the default unit duration to months :
Tools / Options / Schedule / Duration in entered in...months
Then, to convert all the durations already entered, use a macro:
Tools / Macro / Macros... / Format_Duration

Gérard Ducouret

 

[Turki Ben Sumih]

thank you so much dear for your quick answer,
actually the PM enters the duration of tasks in days and i don't want to
change that default input, what i am asking about is how to show the duration
for each project in months or years , i want to createa field with formula to
show only the duration in months or years per project in project web access.

regards,

 

[JulieS]

Hello Turki Ben Sumih,

I can't answer specifically how to do this in PWA, but you can convert
durations in a custom duration field in Project using the ProjDurConv
function. Insert a custom duration field (Duration1 for example.). Click
the inserted column and choose Tools>Customize>Fields. In the Customize
Fields dialog box under custom attributes click the Formula... button. In
the Formula dialog box enter the formula:

ProjDurConv([Duration],pjMonths)

to convert the value in the [Duration] field to months. If you look for
help project functions and then select Conversion functions then the
ProjDurConv function it will lend some additional assistance.

Hope this helps. Let us know how you get along.

Julie

 

[Turki Ben Sumih]

DearJulieS, thank you so much for helping me,
I actually did the customized field using the
ProjDurConv([Duration],pjMonths) formula in the project level BUT when i open
a project in the MS project the customized field gives me ERROR ! and when i
add this field to the project web access view, the field in the project
center gives me 0 for each project !
dears, can you help me solving this issue?

Thanks and Best regards

Hello Turki Ben Sumih,

I can't answer specifically how to do this in PWA, but you can convert
durations in a custom duration field in Project using the ProjDurConv
function. Insert a custom duration field (Duration1 for example.). Click
the inserted column and choose Tools>Customize>Fields. In the Customize
Fields dialog box under custom attributes click the Formula... button. In
the Formula dialog box enter the formula:

ProjDurConv([Duration],pjMonths)

to convert the value in the [Duration] field to months. If you look for
help project functions and then select Conversion functions then the
ProjDurConv function it will lend some additional assistance.

Hope this helps. Let us know how you get along.

Julie

thank you so much dear for your quick answer,
actually the PM enters the duration of tasks in days and i don't want to
change that default input, what i am asking about is how to show the
duration
for each project in months or years , i want to createa field with formula
to
show only the duration in months or years per project in project web
access.

regards,

 

[Turki Ben Sumih]

dear JulieS,
I actually found the solution why the field gives me error in MS Project and
0 in project center.
after you create the field , insert the customized field then open the
project ,the customized field will give you error.so what you should do now
is to retype the duration for one task only then the error will disappear
showing the required duration then publish the project to PWA.

THANKS TO ALL WHO READ AND ANSWER MY ISSUE.

DearJulieS, thank you so much for helping me,
I actually did the customized field using the
ProjDurConv([Duration],pjMonths) formula in the project level BUT when i open
a project in the MS project the customized field gives me ERROR ! and when i
add this field to the project web access view, the field in the project
center gives me 0 for each project !
dears, can you help me solving this issue?

Thanks and Best regards

Hello Turki Ben Sumih,

I can't answer specifically how to do this in PWA, but you can convert
durations in a custom duration field in Project using the ProjDurConv
function. Insert a custom duration field (Duration1 for example.). Click
the inserted column and choose Tools>Customize>Fields. In the Customize
Fields dialog box under custom attributes click the Formula... button. In
the Formula dialog box enter the formula:

ProjDurConv([Duration],pjMonths)

to convert the value in the [Duration] field to months. If you look for
help project functions and then select Conversion functions then the
ProjDurConv function it will lend some additional assistance.

Hope this helps. Let us know how you get along.

Julie

thank you so much dear for your quick answer,
actually the PM enters the duration of tasks in days and i don't want to
change that default input, what i am asking about is how to show the
duration
for each project in months or years , i want to createa field with formula
to
show only the duration in months or years per project in project web
access.

regards,

:

Hello,
First of all, have you set the default unit duration to months :
Tools / Options / Schedule / Duration in entered in...months
Then, to convert all the durations already entered, use a macro:
Tools / Macro / Macros... / Format_Duration

Gérard Ducouret

"Turki Ben Sumih" <[email protected]> a écrit dans
le
message de dear All,
I am a project server administartor.One of my responsibilities is to
create
custom fields with formula.The question is that how can i create i a
field
that shows only the duration in months instead of days using formula.

Regards,

 

[Mike Glen]

Hi Turki,

Glad you got it sorted Next time, try posting on the server newsgroup.
Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and
other useful Project information can be seen at this web address:
http://www.mvps.org/project/.

Mike Glen
Project MVP

dear JulieS,
I actually found the solution why the field gives me error in MS
Project and 0 in project center.
after you create the field , insert the customized field then open the
project ,the customized field will give you error.so what you should
do now is to retype the duration for one task only then the error
will disappear showing the required duration then publish the project
to PWA.

THANKS TO ALL WHO READ AND ANSWER MY ISSUE.

DearJulieS, thank you so much for helping me,
I actually did the customized field using the
ProjDurConv([Duration],pjMonths) formula in the project level BUT
when i open a project in the MS project the customized field gives
me ERROR ! and when i add this field to the project web access view,
the field in the project center gives me 0 for each project !
dears, can you help me solving this issue?

Thanks and Best regards

Hello Turki Ben Sumih,

I can't answer specifically how to do this in PWA, but you can
convert durations in a custom duration field in Project using the
ProjDurConv function. Insert a custom duration field (Duration1
for example.). Click the inserted column and choose
Tools>Customize>Fields. In the Customize Fields dialog box under
custom attributes click the Formula... button. In the Formula
dialog box enter the formula:

ProjDurConv([Duration],pjMonths)

to convert the value in the [Duration] field to months. If you
look for help project functions and then select Conversion
functions then the ProjDurConv function it will lend some
additional assistance.

Hope this helps. Let us know how you get along.

Julie

in message
thank you so much dear for your quick answer,
actually the PM enters the duration of tasks in days and i don't
want to change that default input, what i am asking about is how
to show the duration
for each project in months or years , i want to createa field with
formula to
show only the duration in months or years per project in project
web access.

regards,

:

Hello,
First of all, have you set the default unit duration to months :
Tools / Options / Schedule / Duration in entered in...months
Then, to convert all the durations already entered, use a macro:
Tools / Macro / Macros... / Format_Duration

Gérard Ducouret

"Turki Ben Sumih" <[email protected]> a
écrit dans le
message de
dear All,
I am a project server administartor.One of my responsibilities
is to create custom fields with formula.The question is that how
can i create i a field
that shows only the duration in months instead of days using
formula.

Regards,