Displaying Elapsed Time

[A. Faisal Shaazi, PMP]

Hi group,

Is there a way of displaying elapsed duration in addition to task duration?
I would like to create a view that shows the task duration as e.g. 3 days
and the elasped duration as 5 days (if the 3 days spans over a 2-day
nonworking weekend).

Any ideas?

Thank you.

A. Faisal Shaazi, PMP
Subang Jaya
Malaysia

 

[Gérard DUCOURET]

Hello,
Insert a custom Duration1 field and place the following formula :
(DateDiff("d";[Start];[Finish];2)+1)*480
NB : 480 means 8hr per day. Change it if necessary.
Hope this help,

Gérard Ducouret

 

[Mike Glen]

Hi A. Faisal,

Welcome to this Microsoft Project newsgroup

Inset a column for Text1, right click on its heading and select Customise
Fields... Click the Formula... button and insert [Finish]-[Start] and OK
your way out.

FAQs, companion products and other useful Project information can be seen at
this web address: http://www.mvps.org/project/

Hope this helps - please let us know how you get on

Mike Glen
Project MVP

 

[A. Faisal Shaazi, PMP]

Gérard and Mike,

thank you!
I was cracking my head to find how to do this... you guys make make it seem
so QED..

A. Faisal Shaazi, PMP

Hi A. Faisal,

Welcome to this Microsoft Project newsgroup

Inset a column for Text1, right click on its heading and select Customise
Fields... Click the Formula... button and insert [Finish]-[Start] and OK
your way out.

FAQs, companion products and other useful Project information can be seen at
this web address: http://www.mvps.org/project/

Hope this helps - please let us know how you get on

Mike Glen
Project MVP

Hi group,

Is there a way of displaying elapsed duration in addition to task duration?
I would like to create a view that shows the task duration as e.g. 3 days
and the elasped duration as 5 days (if the 3 days spans over a 2-day
nonworking weekend).

Any ideas?

Thank you.

A. Faisal Shaazi, PMP
Subang Jaya
Malaysia

 

[Mike Glen]

You're welcome,

Mike Glen
MS Project MVP

Gérard and Mike,

thank you!
I was cracking my head to find how to do this... you guys make make it seem
so QED..

A. Faisal Shaazi, PMP

Hi A. Faisal,

Welcome to this Microsoft Project newsgroup

Inset a column for Text1, right click on its heading and select Customise
Fields... Click the Formula... button and insert [Finish]-[Start] and OK
your way out.

FAQs, companion products and other useful Project information can be

seen

at
this web address: http://www.mvps.org/project/

Hope this helps - please let us know how you get on

Mike Glen
Project MVP