Changing working days to calender days - microsoft.public.project

I have a schedule I am working on and I need to convert the work days to calender days, but I am not able to find how to do that. I tried one way (put ed after the days number) and that changed the finish time, but I would like the start and end dates to remain the same, but have full calender days reflected in the duration of days. This seems like it would be a simple thing, I just can't find it. Lastly, is there a way for the Duration days and the start/finish times to be in lockstep? Thanks, Paul

That is not how Project works. Duration is the number of days *at work*, not calendar. Elapsed days is when a task's duration is "elapsed" without regard to working time defined in the work calendar, e.g. it taks 1.5 eDays for paint to dry (since it will dry overnight when there is no work time allocated on the calendar). What are you trying to do? --rms www.rmschneider.com On 14/01/10 13:22, rugbysecondrow wrote: > I have a schedule I am working on and I need to convert the work days to > calender days, but I am not able to find how to do that. I tried one way > (put ed after the days number) and that changed the finish time, but I would > like the start and end dates to remain the same, but have full calender days > reflected in the duration of days. This seems like it would be a simple > thing, I just can't find it. > > Lastly, is there a way for the Duration days and the start/finish times to > be in lockstep? > Thanks, > > Paul

Hello Paul, A couple points of clarification: When you refer to "work days" you really the value shown in the duration field, not the work field. You wish to maintain the current schedule (M-F as days when work can occur) but you would like to count non-working time (Sat & Sun) in the duration measure. If those two points are correct, the following will work. 1. Create a new calendar making all days Sunday through Saturday as working time. I would use the same working hours on Saturday and Sunday as you have defined for Monday through Friday. I called the new calendar "7Day". 2. Add a spare duration field (Duration1) to the table in the view. 3. Rename the field "Calendar Duration" or something suitable. 4. Add the following formula to the field: ProjDateDiff([Start],[Finish],"7Day") 5. Ensure the setting for "Calculation for task and group summary rows" is set to "Use formula." You should now have a field available to you in all task views that will show the number of calendar days between the task start and finish. To your question: "Lastly, is there a way for the Duration days and the start/finish times to be in lockstep?" I'm sorry, but I don't understand the question. Can you explain a bit more? I hope this helps. Let us know how you get along. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project On 1/14/2010 8:22 AM, rugbysecondrow wrote: > I have a schedule I am working on and I need to convert the work days to > calender days, but I am not able to find how to do that. I tried one way > (put ed after the days number) and that changed the finish time, but I would > like the start and end dates to remain the same, but have full calender days > reflected in the duration of days. This seems like it would be a simple > thing, I just can't find it. > > Lastly, is there a way for the Duration days and the start/finish times to > be in lockstep? > Thanks, > > Paul >

Hello everybody!!! Dear JulieS, I have encountered your solution to this common problem many times and tried it numerously but something does not work right. Let me give the following example. I have a summary task, say "A". It has three subtask. Each of these three subtasks is a milestone. The first milestone occurs on the 27 May 2008, the second one on the 29 May 2008 and the third one on 2 June 2008. There is one weekend between them. Now I will describe the exact steps I have performed after I entered these initial information: Project - Project Information - Calendar: Standard Tools - Change Working Time - Work weeks - Details - Saturday: Set day(s) to these specific working times: 08:00 AM - 12:00 AM; 01:00 PM - 05:00 PM - Sunday: Set day(s) to these specific working times: 08:00 AM - 12:00 AM; 01:00 PM - 05:00 PM - OK - OK Right mouse click on Predecessors - Insert Column - Duration1 Right mouse click on Duration1 - Customize fields - Custom attributes: Formula: ProjDateDiff([Start],[Finish],"Standard") - Calculation for task and group summary rows: Use formula - OK The result of all this was that the value in the new column for summary task A was 5,25 instead of 6 (the same value as in the duration field). How comes? Thank you. -- MalkiaSashko ------------------------------------------------------------------------ MalkiaSashko's Profile: http://forums.techarena.in/members/149228.htm View this thread: http://forums.techarena.in/microsoft-project/1293119.htm http://forums.techarena.in

This is a multi-part message in MIME format. ------=_NextPart_000_00C5_01CA9601.CBA6CB40 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Malkia, I've created exactly a project as you describe. In my Summary Task (A) = shows 6 hours as I expected and the Duration1 value was the same. I = suspect you have some mismatch of times. Change the Duration Format = (Tools/Options/View) to show times of the day and check all the = milestones and the Project Start show 08:00 start times. Mike Glen Project MVP See http://tinyurl.com/2xbhc for my free Project Tutorials "MalkiaSashko" <MalkiaSashko.44sxvb@DoNotSpam.com> wrote in message = news:MalkiaSashko.44sxvb@DoNotSpam.com... Hello everybody!!! Dear JulieS, I have encountered your solution to this common problem many times and tried it numerously but something does not work right. Let me give the following example. I have a summary task, say "A". It has three subtask. Each of these three subtasks is a milestone. The first milestone occurs on the 27 = May 2008, the second one on the 29 May 2008 and the third one on 2 June 2008. There is one weekend between them. Now I will describe the exact steps I have performed after I entered these initial information: Project - Project Information - Calendar: Standard Tools - Change Working Time - Work weeks - Details - Saturday: Set day(s) to these specific working times: 08:00 AM - 12:00 AM; 01:00 PM = - 05:00 PM - Sunday: Set day(s) to these specific working times: 08:00 = AM - 12:00 AM; 01:00 PM - 05:00 PM - OK - OK Right mouse click on Predecessors - Insert Column - Duration1 Right mouse click on Duration1 - Customize fields - Custom attributes: Formula: ProjDateDiff([Start],[Finish],"Standard") - Calculation for task and group summary rows: Use formula - OK The result of all this was that the value in the new column for = summary task A was 5,25 instead of 6 (the same value as in the duration = field). How comes?=20 Thank you. --=20 MalkiaSashko = ------------------------------------------------------------------------ MalkiaSashko's Profile: http://forums.techarena.in/members/149228.htm View this thread: = http://forums.techarena.in/microsoft-project/1293119.htm http://forums.techarena.in ------=_NextPart_000_00C5_01CA9601.CBA6CB40 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3Dtext/html;charset=3DWindows-1252 = http-equiv=3DContent-Type> <META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16466"></HEAD> <BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: = 15px"=20 id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 = CanvasTabStop=3D"true"=20 name=3D"Compose message area"> <DIV><FONT face=3D"Comic Sans MS">Hi Malkia,</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS"></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS">I've created exactly a project as you=20 describe.  In my Summary Task (A) shows 6 hours as I expected and = the=20 Duration1 value was the same.  I suspect you have some mismatch of=20 times.  Change the Duration Format (Tools/Options/View) to show = times of=20 the day and check all the milestones and the Project Start show 08:00 = start=20 times.</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS"></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS">Mike Glen</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS">Project MVP</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS">See <A=20 href=3D"http://tinyurl.com/2xbhc">http://tinyurl.com/2xbhc</A> for my = free Project=20 Tutorials</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS"></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS"></FONT> </DIV> <BLOCKQUOTE=20 style=3D"BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; = PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"> <DIV>"MalkiaSashko" <<A=20 title=3D"mailto:MalkiaSashko.44sxvb@DoNotSpam.com
CTRL + Click to = follow link"=20 = href=3D"mailto:MalkiaSashko.44sxvb@DoNotSpam.com">MalkiaSashko.44sxvb@DoN= otSpam.com</A>>=20 wrote in message <A=20 title=3D"news:MalkiaSashko.44sxvb@DoNotSpam.com
CTRL + Click to = follow link"=20 = href=3D"news:MalkiaSashko.44sxvb@DoNotSpam.com">news:MalkiaSashko.44sxvb@= DoNotSpam.com</A>...</DIV><BR>Hello=20 everybody!!!<BR><BR>Dear JulieS,<BR><BR>I have encountered your = solution to=20 this common problem many times and<BR>tried it numerously but = something does=20 not work right. Let me give the<BR>following example.<BR><BR>I have a = summary=20 task, say "A". It has three subtask. Each of these<BR>three subtasks = is a=20 milestone. The first milestone occurs on the 27 May<BR>2008, the = second one on=20 the 29 May 2008 and the third one on 2 June<BR>2008. There is one = weekend=20 between them. Now I will describe the exact<BR>steps I have performed = after I=20 entered these initial information:<BR><BR>Project - Project = Information -=20 Calendar: Standard<BR><BR>Tools - Change Working Time - Work weeks - = Details -=20 Saturday: Set<BR>day(s) to these specific working times: 08:00 AM - = 12:00 AM;=20 01:00 PM -<BR>05:00 PM - Sunday: Set day(s) to these specific working = times:=20 08:00 AM<BR>- 12:00 AM; 01:00 PM - 05:00 PM - OK - OK<BR><BR>Right = mouse click=20 on Predecessors - Insert Column - Duration1<BR><BR>Right mouse click = on=20 Duration1 - Customize fields - Custom attributes:<BR>Formula:=20 ProjDateDiff([Start],[Finish],"Standard") - Calculation for<BR>task = and group=20 summary rows: Use formula - OK<BR><BR>The result of all this was that = the=20 value in the new column for summary<BR>task A was 5,25 instead of 6 = (the same=20 value as in the duration field).<BR><BR>How comes? <BR><BR>Thank=20 you.<BR><BR><BR>--=20 = <BR>MalkiaSashko<BR>-----------------------------------------------------= -------------------<BR>MalkiaSashko's=20 Profile: <A=20 = href=3D"http://forums.techarena.in/members/149228.htm">http://forums.tech= arena.in/members/149228.htm</A><BR>View=20 this thread: <A=20 = href=3D"http://forums.techarena.in/microsoft-project/1293119.htm">http://= forums.techarena.in/microsoft-project/1293119.htm</A><BR><BR><A=20 = href=3D"http://forums.techarena.in">http://forums.techarena.in</A><BR></B= LOCKQUOTE></BODY></HTML> ------=_NextPart_000_00C5_01CA9601.CBA6CB40--

Hello MalkiaSashko, I see Mike as given you the perfect answer. Thanks, Mike {waving at Mike}. Even though you are seeing dates, Project is storing dates and time. My guess would be either the first milestone doesn't start at 08:00 or the last milestone ends before 17:00 I hope this helps. Let us know how you get along. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project On 1/14/2010 5:26 PM, MalkiaSashko wrote: > Hello everybody!!! > > Dear JulieS, > > I have encountered your solution to this common problem many times and > tried it numerously but something does not work right. Let me give the > following example. > > I have a summary task, say "A". It has three subtask. Each of these > three subtasks is a milestone. The first milestone occurs on the 27 May > 2008, the second one on the 29 May 2008 and the third one on 2 June > 2008. There is one weekend between them. Now I will describe the exact > steps I have performed after I entered these initial information: > > Project - Project Information - Calendar: Standard > > Tools - Change Working Time - Work weeks - Details - Saturday: Set > day(s) to these specific working times: 08:00 AM - 12:00 AM; 01:00 PM - > 05:00 PM - Sunday: Set day(s) to these specific working times: 08:00 AM > - 12:00 AM; 01:00 PM - 05:00 PM - OK - OK > > Right mouse click on Predecessors - Insert Column - Duration1 > > Right mouse click on Duration1 - Customize fields - Custom attributes: > Formula: ProjDateDiff([Start],[Finish],"Standard") - Calculation for > task and group summary rows: Use formula - OK > > The result of all this was that the value in the new column for summary > task A was 5,25 instead of 6 (the same value as in the duration field). > > How comes? > > Thank you. > > >

Another more subtle issue with your example is you really don't have any scheduable tasks at all. Tasks are observable physical actions extending over time. A milestone, OTOH, is an instantaneous event that is the outcome of one or more tasks and marks the transition from one state into another, ie a transition from "contract not signed" to "contract signed." Tasks can be scheduled, milestones happen whenever the tasks driving them allow them to happen. As far as the project work schedule is concerned, a summary task that only has milestones as its subtasks is at the very best merely a restatement of the project's objectives. -- Steve House MS Project Trainer & Consultant "MalkiaSashko" <MalkiaSashko.44sxvb@DoNotSpam.com> wrote in message news:MalkiaSashko.44sxvb@DoNotSpam.com... > > Hello everybody!!! > > ...> > I have a summary task, say "A". It has three subtask. Each of these > three subtasks is a milestone. The first milestone occurs on the 27 May > 2008, the second one on the 29 May 2008 and the third one on 2 June > 2008. There is one weekend between them. Now I will describe the exact > steps I have performed after I entered these initial information: > > ...> MalkiaSashko > ------------------------------------------------------------------------ > MalkiaSashko's Profile: http://forums.techarena.in/members/149228.htm > View this thread: http://forums.techarena.in/microsoft-project/1293119.htm > > http://forums.techarena.in >

Thank you all for the extensive replies :-))) As I mentioned in my last post, I had entered wrong working times for Sat and Sun. It appears that when I enter "17:00" in the second cell of the second row than I have to click again in the table, so that this value is entered successfully. Otherwise, if a click on another week day or even click OK (while the cell is still active), it automatically transforms 17:00 to 14:00 (since the value in the first cell of the second row is 13:00 and by default Project generates one hour blocks). When I enter the working times correctly though, it all works fine. By the way, I encountered another issue. When I create the new calendar with a seven day work week, I, of course, set it as a project calendar in the Project Information dialog box. After that the start and finish dates of tasks are recalculated correctly. However, when I look at the Gantt chart it still shows Sats and Suns as work days (gray pattern). This is not a big deal since I can just change the pattern for showing nonworking time to white, but still does anybody has a clue why this is not done automatically by Project? Thanks. -- MalkiaSashko ------------------------------------------------------------------------ MalkiaSashko's Profile: http://forums.techarena.in/members/149228.htm View this thread: http://forums.techarena.in/microsoft-project/1293119.htm http://forums.techarena.in

Hello MalkiaSashko, Yes, the issue with the need to press Enter or Tab into the next row while changing working time is a bother. To your new question, if you change the Project Calendar to a different calendar (not modifying the Standard calendar), set the new calendar as the background of the timescaled views through Format > Timescale, Nonworking time tab. I hope this helps. Julie On 1/19/2010 5:30 AM, MalkiaSashko wrote: > Thank you all for the extensive replies :-))) > > As I mentioned in my last post, I had entered wrong working times for > Sat and Sun. It appears that when I enter "17:00" in the second cell of > the second row than I have to click again in the table, so that this > value is entered successfully. Otherwise, if a click on another week day > or even click OK (while the cell is still active), it automatically > transforms 17:00 to 14:00 (since the value in the first cell of the > second row is 13:00 and by default Project generates one hour blocks). > When I enter the working times correctly though, it all works fine. > > By the way, I encountered another issue. When I create the new calendar > with a seven day work week, I, of course, set it as a project calendar > in the Project Information dialog box. After that the start and finish > dates of tasks are recalculated correctly. However, when I look at the > Gantt chart it still shows Sats and Suns as work days (gray pattern). > This is not a big deal since I can just change the pattern for showing > nonworking time to white, but still does anybody has a clue why this is > not done automatically by Project? > > Thanks. > >

Similiar Articles:

Changing working days to calender days - microsoft.public.project ...
I have a schedule I am working on and I need to convert the work days to calender days, but I am not able to find how to do that. I tried one way ...

Work Days, Not Calendar Days in MSProject - microsoft.public ...
I cannot find anywhere where anyone's done this: I don't want to change working hours, I want to put 'Work Day 1' instead of 'Monday, Jan. 1', etc....

Selecting specific work times for every day in a calendar ...
Change Working Time, Work Weeks, Detail, Select the remaining day then Set days to specific ... the working calendar to have a seven day work ...

changing to a 24 hour calendar - microsoft.public.project ...
I have a project that will run 24 hours a day until it's finished,I can't get the calendar to change to a ... nap, won't see the family, etc for at least 4 days, working ...

exception - working day - microsoft.public.project
... Change Working time" button to show the resource's calendar. Click >> the day(s) in ... working day - microsoft.public.project changing the scale from hours to days in the ...

Duration shown as Calendar Days - microsoft.public.project ...
Changing working days to calender days - microsoft.public.project ... Duration shown as ... box, click a time when you want to begin your calendar day.

7 working days a week - microsoft.public.project
Populating 7 day calendar with information - microsoft.public ... 7 working days a week - microsoft.public.project How do I change the project calander from 5 day to 7 day ...

changing settings to non-standard work week - microsoft.public ...
Changing working days to calender days - microsoft.public ... Project - Microsoft Support How to change working ... How do you change a Project from 5 day work week to a 7 day ...

Calculating calendar days and completion dates. - microsoft.public ...
Hi, I need help converting working days to calendar days, to give me a ... Hi OssieMac, How do i change the workday function to a 6 day week? "OssieMac" wrote ...

change color of weekend days - microsoft.public.outlook ...
... like to change the overall color of weekend days in the calendar ... on multi-day event shape ... change color of weekend days ... in the calendar views. ... > > Or work days ...

Change your Calendar work days and the start of your week ...
By default in Microsoft Office Outlook 2007 , the work week is set from Monday through Friday with a work day extending from 8 A.M. to 5 P.M.. The first day of the ...

Project 2010 - Changing Calendar - Microsoft Answers
... calendar to change. I want to use a generic schedule in days, including weekends: ie - 90 day ... days you want to be defined as a standard working day in your calendar.

Changing working days to calender days Project
I have a schedule I am working on and I need to convert the work days to calender days, but I am not able to find how to do that. I tried one way (put ed

How to change working time in Project - Microsoft Support
This article includes information about changing the working time of the Microsoft Project Standard calendar. ... hours divided by 6 hours per day equals 1.3333 days duration.

How do I change the project calander from 5 day to 7 day week ...
Then go to Tools/Options/Calendar > tab and set the Hours per week to be 56, assuming you are still using a > standard 8 hour work day. I wouldn't change the Days per month ...

7/27/2012 7:17:42 PM