Converting work days to calendar days

[sushrutj]

The MS Project 2007 file was created with work days. Now i want to
convert them to calendar days - how do i do this?

thanks.

 

[Jan De Messemaeker]

Hi,

Customize a custom duration field to contain a formula, using the Datediff
function to calculate the difference between start and finish;than will show
duration in calendar days.

 

[MalkiaSashko]

Hi, I have a similar problems, however the issue is different.

I have already entered all the tasks and their durations in th
duration field. By default, Project used the Standard calendar (5 wor
days) and all the durations are calculated in work days. So for example
if I have a 6 day task it will be 8 calendar days. Now I want to conver
these durations in calendar days but without changing the numbers of th
durations and only reschedule them. So for example, if the 6 day tas
previously had been starting on 04.01.2010 and ended on the 11.01., no
I want it to end on 09.01. (Saturday). I tried this by creating a ne
calendar with a 7 day work week. Is this the right way

 

[sai]

Hi, I have a similar problems, however the issue is different.

I have already entered all the tasks and their durations in the
duration field. By default, Project used the Standard calendar (5 work
days) and all the durations are calculated in work days. So for example,
if I have a 6 day task it will be 8 calendar days. Now I want to convert
these durations in calendar days but without changing the numbers of the
durations and only reschedule them. So for example, if the 6 day task
previously had been starting on 04.01.2010 and ended on the 11.01., now
I want it to end on 09.01. (Saturday). I tried this by creating a new
calendar with a 7 day work week. Is this the right way?

--
MalkiaSashko
------------------------------------------------------------------------
MalkiaSashko's Profile:http://forums.techarena.in/members/149228.htm
View this thread:http://forums.techarena.in/microsoft-project/773756.htm

http://forums.techarena.in

Yes, you have followed the right approach. The start and finish date
of a task is calculated with respect to the calendar, and so changing
the working time (or) the working days in the calendar will affect the
start and finish dates of these tasks but without affecting the
duration (business days) of these tasks.

If you would like to do this for selected tasks only, try creating a
new base calendar (Tools | Change working time) and assign this
calendar as task calendar for this task. You can open the Task
informaiton form of the task, go to the Advanced tab, and set the new
calendar in Calendar drop down.

Please let me know if this helps

- Sai, PMP, PMI-SP, MCT, MCTS
http://saipower.wordpress.com

 

[MalkiaSashko]

Hello

Yes, this helped. I created a new base calendar with 7 work days
However, since the dates of all tasks must be calculated based on th
already entered durations, I applied the new base calendar to the whol
project. Thank you for the quick reply. :-

 

[sai]

Hello,

Yes, this helped. I created a new base calendar with 7 work days.
However, since the dates of all tasks must be calculated based on the
already entered durations, I applied the new base calendar to the whole
project. Thank you for the quick reply.

--
MalkiaSashko
------------------------------------------------------------------------
MalkiaSashko's Profile:http://forums.techarena.in/members/149228.htm
View this thread:http://forums.techarena.in/microsoft-project/773756.htm

http://forums.techarena.in

Thanks MalkiaSashko for confirming my solution worked.

- Sai, PMP, PMI-SP, MCT, MCTS
http://saipower.wordpress.com

 

[FLCivilPE]

I am attempting to use the DateDiff Function to do this. I figured-ou
how to enter the start and finish dates. I'm not so sure what it i
asking for with the interval, firstdayofweek, and firstweekofyear.

DateDiff( interval, date1, date2, firstdayofweek, firstweekofyear

 

[Andrew Lavinsky]

A couple of ways:

1) Take a spare number field and add the formula [Finish]-[Start]
2) Add a 7 day working calendar. Call it "7day" and then use this formula
in a duration field: ProjDateDiff([Start],[Finish],"7day")

Why do you need this, if I may ask?


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[Jan De Messemaeker]

Hi,

Interval: the time unit you want, "m", "h", "d", "w"
first and last day of week: only if you use "w". Never used that.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[FLCivilPE]

Thank you Andrew. That doesn't completely answer my question about ho
to complete the DateDiff fields (interval, date1, date2, firstdayofweek
firstweekofyear)

Basically I have a schedule developed using a five day work week, bu
the client has requirements for meeting calendar durations. I just wan
to show the calendar durations for each task

 

[Andrew Lavinsky]

Both of those formulas satisfy that requirement, no?


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[Dale Howard [MVP]]

FLCivilPE --

Create a custom Base calendar called 7-Day Work Week and set the working
schedule for 8:00 AM - 12:00 PM and 1:00 PM - 5:00 PM for every day of the
week including Saturday and Sunday. Do not include any company holidays on
this calendar.

When you create your custom field, use one of the available Duration fields
such as Duration 1, for example. When you write the formula in the custom
field, instead of using the DateDiff function, use the ProjDateDiff function
instead. Write your formula using this function as follows:

ProjDateDiff([Start], [Finish], "7-Day Work Week")

After creating the custom field and formula, if necessary, press the F9
function key to recalculate your project. Hope this helps.

 

[FLCivilPE]

Thank you everyone. I was able to get the calendar durations shown o
my project. I appreciate all your help