calculate days out of actual work column

[martijn.damen]

Hi all,

I'm trying to pimp our ms project plan a bit.

Currently we have a project plan which is hour based, so in the
columns work, actual work and remaining work we have values in hours.
Unfortunately I have to report these as days, where we calculate each
working day with 9 hours. So I want to add a column which
automatically takes the value of the column 'actual work' and puts it
times 9 in a customer field column.

I have done the following:

add custom field duration1
customized the field duration1 with the formula "[Actual Work]/9"

But somehow the numbers don't make sense..

Who can help me out here. Tnx, Martijn

 

[Jan De Messemaeker]

Dag Martijn,

It looks as if you redo something Project is already doing.
When enetring a work or duration value into a custom duration field the
result is displayed according to the relevant option (I think yours is days)
And the value is converted along the hours per day option
So if this option is 9, your formula should simply be:

=[Work]

Hope this helps

 

[Jan De Messemaeker]

Dag Martijn,

It looks as if you redo something Project is already doing.
When enetring a work or duration value into a custom duration field the
result is displayed according to the relevant option (I think yours is days)
And the value is converted along the hours per day option
So if this option is 9, your formula should simply be:

=[Actual Work]

Hope this helps

 

[Gérard Ducouret]

Hello,

Be careful: Actual Work is calculated by Project in minutes. So your formula
will be:
[Travail réel]/[Minutes par jour]
....for the French version, or, for the English version:
[Actual Work]/[Minutes Per Day]

Hope this helps,

Gérard Ducouret

Dag Martijn,

It looks as if you redo something Project is already doing.
When enetring a work or duration value into a custom duration field the
result is displayed according to the relevant option (I think yours is
days)
And the value is converted along the hours per day option
So if this option is 9, your formula should simply be:

=[Actual Work]

Hope this helps

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Hi all,

I'm trying to pimp our ms project plan a bit.

Currently we have a project plan which is hour based, so in the
columns work, actual work and remaining work we have values in hours.
Unfortunately I have to report these as days, where we calculate each
working day with 9 hours. So I want to add a column which
automatically takes the value of the column 'actual work' and puts it
times 9 in a customer field column.

I have done the following:

add custom field duration1
customized the field duration1 with the formula "[Actual Work]/9"

But somehow the numbers don't make sense..

Who can help me out here. Tnx, Martijn

 

[martijn.damen]

Guys, you're great. That solved my problem perfectly.

For the actual work, it is set to hours for our project as default. So
I can really take this [actual work] and it works.

Bedankt and Merci ;-)
Martijn

 

[Gérard Ducouret]

You are welcome, Martijn!

Gérard

 

[Jan De Messemaeker]

Hi Gerard,

When you enter Actual Work in a custom DURATION column it is automatically
converted to the units duration is shown in.; No need to divide in that
case.

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Hello,

Be careful: Actual Work is calculated by Project in minutes. So your
formula will be:
[Travail réel]/[Minutes par jour]
...for the French version, or, for the English version:
[Actual Work]/[Minutes Per Day]

Hope this helps,

Gérard Ducouret

Dag Martijn,

It looks as if you redo something Project is already doing.
When enetring a work or duration value into a custom duration field the
result is displayed according to the relevant option (I think yours is
days)
And the value is converted along the hours per day option
So if this option is 9, your formula should simply be:

=[Actual Work]

Hope this helps

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Hi all,

I'm trying to pimp our ms project plan a bit.

Currently we have a project plan which is hour based, so in the
columns work, actual work and remaining work we have values in hours.
Unfortunately I have to report these as days, where we calculate each
working day with 9 hours. So I want to add a column which
automatically takes the value of the column 'actual work' and puts it
times 9 in a customer field column.

I have done the following:

add custom field duration1
customized the field duration1 with the formula "[Actual Work]/9"

But somehow the numbers don't make sense..

Who can help me out here. Tnx, Martijn

 

[Gérard Ducouret]

Hi Jan,

You are right. I used a Number(x) field. In a Duration(x) field, we don't
need that.
;-(

Gérard

Hi Gerard,

When you enter Actual Work in a custom DURATION column it is automatically
converted to the units duration is shown in.; No need to divide in that
case.

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Hello,

Be careful: Actual Work is calculated by Project in minutes. So your
formula will be:
[Travail réel]/[Minutes par jour]
...for the French version, or, for the English version:
[Actual Work]/[Minutes Per Day]

Hope this helps,

Gérard Ducouret

Dag Martijn,

It looks as if you redo something Project is already doing.
When enetring a work or duration value into a custom duration field the
result is displayed according to the relevant option (I think yours is
days)
And the value is converted along the hours per day option
So if this option is 9, your formula should simply be:

=[Actual Work]

Hope this helps

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade
Hi all,

I'm trying to pimp our ms project plan a bit.

Currently we have a project plan which is hour based, so in the
columns work, actual work and remaining work we have values in hours.
Unfortunately I have to report these as days, where we calculate each
working day with 9 hours. So I want to add a column which
automatically takes the value of the column 'actual work' and puts it
times 9 in a customer field column.

I have done the following:

add custom field duration1
customized the field duration1 with the formula "[Actual Work]/9"

But somehow the numbers don't make sense..

Who can help me out here. Tnx, Martijn