View Single Post
 
Old 10-16-2013, 12:48 PM
ketanco ketanco is offline Windows 7 64bit Office 2007
Expert
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

Thanks so much.

So What I did was, I created the new 7 day calendar first. Then, without changing my Project calendar, (keeping the standard 5 day calendar), I added the column "Duration1" and modified that column with your formula. Now I am showing that column (I called it "Calendar days duration" and I am displaying that column near my regular "Duration" column, which is still based on 5 day calendar.

So this way, except showing that new column to the user, I am not causing any modifications in any calculations to my project, and, still I am keeping my regular 5 day calendar right? So I am showing the new column just for information. By the way I am not able to enter data to this new column. I can only change it if I change my regular duration column, and my new column displays the corresponding number of calendar days. Is there a way to edit this column directly also?

Also now I wanted to name my old duration column as "workday duration" but i wasnt able to change it. how can i do it?
Reply With Quote