Customized Unit on Task Duration

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
Fri Apr 18 10:35:06 CDT 2008

In article <4BF6FC23-16B2-455D-99A4-0C2DA57C384C@microsoft.com>,
Studer <Studer@discussions.microsoft.com> wrote:

> 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
Fri Apr 18 10:53:00 CDT 2008

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.


"John" wrote:

> In article <4BF6FC23-16B2-455D-99A4-0C2DA57C384C@microsoft.com>,
> Studer <Studer@discussions.microsoft.com> wrote:
>
> > 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
Fri Apr 18 11:01:00 CDT 2008

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

"John" wrote:

> In article <4BF6FC23-16B2-455D-99A4-0C2DA57C384C@microsoft.com>,
> Studer <Studer@discussions.microsoft.com> wrote:
>
> > 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
Sat Apr 19 10:59:56 CDT 2008

In article <86D917CB-4019-4D65-8E7F-B9F29017BF04@microsoft.com>,
Studer <Studer@discussions.microsoft.com> wrote:

> 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
>
> "John" wrote:
>
> > In article <4BF6FC23-16B2-455D-99A4-0C2DA57C384C@microsoft.com>,
> > Studer <Studer@discussions.microsoft.com> wrote:
> >
> > > 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
> >