Customized Unit on Task Duration

[Studer]

Hello,
I work in an international Enterprise and we use MsProject 2003. We have
projects in several countrys so we need to show our clients Gantt charts with
the duration units using their local language. We use the english version, so
MsP gives me the possibility to show the duration of a task using "d" "dy" ou
"day", but I need to be able to show it in, for example, Portuguese "dia".
When talking about weeks it's even more diferent, in Portuguese you say
"semana" in french "semaine".

How can I change this? MsP Options don't allow me to change the text of the
units, so I think I'll have to use a custom fielsd. Using a Text custom field
and the following formula:
[Duration]/480 & " dia",
I've managed to show me a customized field where the duration comes with
"dia" unit, but I need it to show me the plural of days ("dias") when the
durations is bigger than one day, and when the durantion reaaly big, weeks
("semanas").

How should I do this?

Thank for the help.

 

[John]

Hello,
I work in an international Enterprise and we use MsProject 2003. We have
projects in several countrys so we need to show our clients Gantt charts with
the duration units using their local language. We use the english version, so
MsP gives me the possibility to show the duration of a task using "d" "dy" ou
"day", but I need to be able to show it in, for example, Portuguese "dia".
When talking about weeks it's even more diferent, in Portuguese you say
"semana" in french "semaine".

How can I change this? MsP Options don't allow me to change the text of the
units, so I think I'll have to use a custom fielsd. Using a Text custom field
and the following formula:
[Duration]/480 & " dia",
I've managed to show me a customized field where the duration comes with
"dia" unit, but I need it to show me the plural of days ("dias") when the
durations is bigger than one day, and when the durantion reaaly big, weeks
("semanas").

How should I do this?

Thank for the help.

Studer,
I think your best bet is to use an "if" statement in your formula. It
might look something like this, but I don't have Project open so I
haven't tested it.

Text1=IIF([Duration]/480 > 5, [Duration]/480] & "semanas",
[Duration]/480 > 1, [Duration]/480 & "dias", [Duration]/480 & "dia")

Hope this helps.
John
Project MVP

 

[Studer]

Thanks John,
"IIf" function is certenly the way. Tried the following formula, but it
keeps anouncing a syntax error:

IIf([Duration]/480=1;[Duration]/480 & " dia"; IIf( (([Duration]/480) MOD 5 =
0) AND ([Duration]/480 > 5); ([Duration]/(480*5) & " semanas");
([Duration]/480 & " dias") )

Any ideas?

Thanks.

Hello,
I work in an international Enterprise and we use MsProject 2003. We have
projects in several countrys so we need to show our clients Gantt charts with
the duration units using their local language. We use the english version, so
MsP gives me the possibility to show the duration of a task using "d" "dy" ou
"day", but I need to be able to show it in, for example, Portuguese "dia".
When talking about weeks it's even more diferent, in Portuguese you say
"semana" in french "semaine".

How can I change this? MsP Options don't allow me to change the text of the
units, so I think I'll have to use a custom fielsd. Using a Text custom field
and the following formula:
[Duration]/480 & " dia",
I've managed to show me a customized field where the duration comes with
"dia" unit, but I need it to show me the plural of days ("dias") when the
durations is bigger than one day, and when the durantion reaaly big, weeks
("semanas").

How should I do this?

Thank for the help.

Studer,
I think your best bet is to use an "if" statement in your formula. It
might look something like this, but I don't have Project open so I
haven't tested it.

Text1=IIF([Duration]/480 > 5, [Duration]/480] & "semanas",
[Duration]/480 > 1, [Duration]/480 & "dias", [Duration]/480 & "dia")

Hope this helps.
John
Project MVP

 

[Studer]

BINGO!!!!

IIf([Duration]/480=1;[Duration]/480 & " dia";IIf((([Duration]/480) Mod 5=0)
And ([Duration]/480>5),([Duration]/(480*5) & " sem"),([Duration]/480 & "
dias")))

The problem was in the " ; " after the "And", got to put " , " !!!!

Problem solved!

Studer

Hello,
I work in an international Enterprise and we use MsProject 2003. We have
projects in several countrys so we need to show our clients Gantt charts with
the duration units using their local language. We use the english version, so
MsP gives me the possibility to show the duration of a task using "d" "dy" ou
"day", but I need to be able to show it in, for example, Portuguese "dia".
When talking about weeks it's even more diferent, in Portuguese you say
"semana" in french "semaine".

How can I change this? MsP Options don't allow me to change the text of the
units, so I think I'll have to use a custom fielsd. Using a Text custom field
and the following formula:
[Duration]/480 & " dia",
I've managed to show me a customized field where the duration comes with
"dia" unit, but I need it to show me the plural of days ("dias") when the
durations is bigger than one day, and when the durantion reaaly big, weeks
("semanas").

How should I do this?

Thank for the help.

Studer,
I think your best bet is to use an "if" statement in your formula. It
might look something like this, but I don't have Project open so I
haven't tested it.

Text1=IIF([Duration]/480 > 5, [Duration]/480] & "semanas",
[Duration]/480 > 1, [Duration]/480 & "dias", [Duration]/480 & "dia")

Hope this helps.
John
Project MVP

 

[John]

BINGO!!!!

IIf([Duration]/480=1;[Duration]/480 & " dia";IIf((([Duration]/480) Mod 5=0)
And ([Duration]/480>5),([Duration]/(480*5) & " sem"),([Duration]/480 & "
dias")))

The problem was in the " ; " after the "And", got to put " , " !!!!

Problem solved!

Studer

Studer,
I'm glad you got it working and thanks for the feedback.
John

Hello,
I work in an international Enterprise and we use MsProject 2003. We have
projects in several countrys so we need to show our clients Gantt charts
with
the duration units using their local language. We use the english
version, so
MsP gives me the possibility to show the duration of a task using "d"
"dy" ou
"day", but I need to be able to show it in, for example, Portuguese
"dia".
When talking about weeks it's even more diferent, in Portuguese you say
"semana" in french "semaine".

How can I change this? MsP Options don't allow me to change the text of
the
units, so I think I'll have to use a custom fielsd. Using a Text custom
field
and the following formula:
[Duration]/480 & " dia",
I've managed to show me a customized field where the duration comes with
"dia" unit, but I need it to show me the plural of days ("dias") when the
durations is bigger than one day, and when the durantion reaaly big,
weeks
("semanas").

How should I do this?

Thank for the help.

Studer,
I think your best bet is to use an "if" statement in your formula. It
might look something like this, but I don't have Project open so I
haven't tested it.

Text1=IIF([Duration]/480 > 5, [Duration]/480] & "semanas",
[Duration]/480 > 1, [Duration]/480 & "dias", [Duration]/480 & "dia")

Hope this helps.
John
Project MVP