Home

Having 2 agenda's in one project?

%3CLINGO-SUB%20id%3D%22lingo-sub-677082%22%20slang%3D%22en-US%22%3EHaving%202%20agenda's%20in%20one%20project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-677082%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20made%20a%20project%20planning%20with%20Microsoft%20project.%3C%2FP%3E%3CP%3EHowever%20im%20trying%20to%20get%20colums%20with%20days.%3C%2FP%3E%3CP%3EOne%20is%20working%20days%20(this%20is%20default%20i%20believe)%20and%20the%20other%20one%20should%20be%20calendar-days.%3C%2FP%3E%3CP%3EThis%20means%20that%20if%20a%20task%20takes%20from%2001-01-2019%20to%2006-01-2019%20one%20colum%20should%20state%20its%204%20(working)days%20and%20the%20other%20should%20state%20its%206%20(calendar)%20days.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20i%20get%20this%20to%20work%3F%3C%2FP%3E%3CP%3Ethe%20example%20is%20in%20the%20appendix.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20spending%20time%20to%20help%20me%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-753376%22%20slang%3D%22en-US%22%3ERe%3A%20Having%202%20agenda's%20in%20one%20project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753376%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351130%22%20target%3D%22_blank%22%3E%40Steinrusman%3C%2FA%3E%26nbsp%3BPerhaps%20you%20could%20try%20out%20with%20using%20formula%20Finish%20Date%20-%20Start%20Date%20%3F%20While%20the%20working%20days%20should%20be%20there%20by%20using%20Duration%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754335%22%20slang%3D%22en-US%22%3ERe%3A%20Having%202%20agenda's%20in%20one%20project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754335%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351130%22%20target%3D%22_blank%22%3E%40Steinrusman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPretty%20much%20as%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368326%22%20target%3D%22_blank%22%3E%40Ade_Budiman_Lim%3C%2FA%3E%26nbsp%3Breferred%2C%20more%20detail%20as%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1-%20Right%20Click%20%3D%26gt%3B%20Insert%20Column%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351130%22%20target%3D%22_blank%22%3E%40Steinrusman%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20made%20a%20project%20planning%20with%20Microsoft%20project.%3C%2FP%3E%3CP%3EHowever%20im%20trying%20to%20get%20colums%20with%20days.%3C%2FP%3E%3CP%3EOne%20is%20working%20days%20(this%20is%20default%20i%20believe)%20and%20the%20other%20one%20should%20be%20calendar-days.%3C%2FP%3E%3CP%3EThis%20means%20that%20if%20a%20task%20takes%20from%2001-01-2019%20to%2006-01-2019%20one%20colum%20should%20state%20its%204%20(working)days%20and%20the%20other%20should%20state%20its%206%20(calendar)%20days.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20i%20get%20this%20to%20work%3F%3C%2FP%3E%3CP%3Ethe%20example%20is%20in%20the%20appendix.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20spending%20time%20to%20help%20me%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E2-%20Select%20Number1%20(or%20Any%20Number%20column%20from%201%20to%2020)%3C%2FP%3E%3CP%3E3-%20Right%20Click%20on%20the%20column%20%3D%26gt%3B%20Select%20%22Custom%20Fields%22%3C%2FP%3E%3CP%3E4-%20Select%20Formula%20radio%20bottom%3C%2FP%3E%3CP%3E5-%20Select%20Formula%20to%20open%20%22Formula%20for%20%22Number1%22%3C%2FP%3E%3CP%3E6-%20Put%20the%20formula%20%3D%26gt%3B%20int(%5BFinish%5D-%5BStart%5D)%3C%2FP%3E%3CP%3EPS%3A%20You%20need%20to%20use%20%22integer%22%20because%20date%20are%20formatted%20as%20dd%2Fmm%2Fyyyy%20HH%3AMM%20am%2Fpm%20but%20you%20probably%20don't%20need%20the%20decimal%20in%20your%20report%3C%2FP%3E%3CP%3E7-Ok%3C%2FP%3E%3CP%3EResult%3A%20You%20will%20get%20the%20difference%20between%20%22Finish%22%20date%20and%20%22Start%22%20date%20Not%20considering%20non-working%20days.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20considering%20non-working%20days%2C%20simply%20using%20%22Duration%22%20column%20and%20proper%20calendar.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20it%20helps!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754342%22%20slang%3D%22en-US%22%3ERe%3A%20Having%202%20agenda's%20in%20one%20project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754342%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F369971%22%20target%3D%22_blank%22%3E%40Behzad78%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAgree%2C%20this%20solution%20should%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Steinrusman
New Contributor

Hello,

 

I made a project planning with Microsoft project.

However im trying to get colums with days.

One is working days (this is default i believe) and the other one should be calendar-days.

This means that if a task takes from 01-01-2019 to 06-01-2019 one colum should state its 4 (working)days and the other should state its 6 (calendar) days.

 

How do i get this to work?

the example is in the appendix.

 

Thanks in advance for spending time to help me :)

 

3 Replies

@Steinrusman Perhaps you could try out with using formula Finish Date - Start Date ? While the working days should be there by using Duration?

@Steinrusman 

Pretty much as @Ade_Budiman_Lim referred, more detail as below:

 

1- Right Click => Insert Column


@Steinrusman wrote:

Hello,

 

I made a project planning with Microsoft project.

However im trying to get colums with days.

One is working days (this is default i believe) and the other one should be calendar-days.

This means that if a task takes from 01-01-2019 to 06-01-2019 one colum should state its 4 (working)days and the other should state its 6 (calendar) days.

 

How do i get this to work?

the example is in the appendix.

 

Thanks in advance for spending time to help me :)

 


2- Select Number1 (or Any Number column from 1 to 20)

3- Right Click on the column => Select "Custom Fields"

4- Select Formula radio bottom

5- Select Formula to open "Formula for "Number1"

6- Put the formula => int([Finish]-[Start])

PS: You need to use "integer" because date are formatted as dd/mm/yyyy HH:MM am/pm but you probably don't need the decimal in your report

7-Ok

Result: You will get the difference between "Finish" date and "Start" date Not considering non-working days.

 

For considering non-working days, simply using "Duration" column and proper calendar.

 

Hope it helps!

@Behzad78 

 

Agree, this solution should work.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies