Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-24-2014, 11:36 PM
marif300 marif300 is offline Saturday off alternately Windows XP Saturday off alternately Office 2007
Advanced Beginner
Saturday off alternately
 
Join Date: Jun 2014
Location: Pakistan
Posts: 38
marif300 is on a distinguished road
Default Saturday off alternately

In our organization, we get alternate Saturday off viz-a-viz 1st and third Saturday off. So I want to know, is there any option in MS-project to do this change at the time of calender generation, rather than manually.



Regards,

Arif
Reply With Quote
  #2  
Old 06-25-2014, 07:21 AM
JulieS JulieS is offline Saturday off alternately Windows 7 64bit Saturday off alternately Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I'm not sure I fully follow your question.

The default calendar in Project (Standard calendar) has all Saturdays as non-working. You can create a new calendar with every other Saturday as working and then copy that calendar to the Global template, making it available in all new projects.

So, is your question
  • How to create a calendar with every other Saturday as working time?
  • How to copy that calendar to Global?
  • Something else?
Please also let us know what version of Project. The directions for changing calendars may be different depending upon what version of Project you use.
Reply With Quote
  #3  
Old 06-25-2014, 08:31 PM
marif300 marif300 is offline Saturday off alternately Windows XP Saturday off alternately Office 2007
Advanced Beginner
Saturday off alternately
 
Join Date: Jun 2014
Location: Pakistan
Posts: 38
marif300 is on a distinguished road
Default

Q1. How to create a calendar with every other Saturday as working time?

A1. I can easily modify the standard / new generated calender, but we can only mark all Saturdays off. I want to mark 1st and 3rd Saturday off for 4 years calender, because if we modify the calendar manually, it takes alot of time.

Q2. How to copy that calendar to Global?
A2. Already known.

Q3. About version?
A3. Currently I am using MS project 2007, while I already searched the same in 2013 but same problem occurs.

Waiting for your reply.

Regards,

Arif
Reply With Quote
  #4  
Old 06-26-2014, 06:22 AM
JulieS JulieS is offline Saturday off alternately Windows 7 64bit Saturday off alternately Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

The easiest approach is to create the new calendar and modify the Work Week to include all Saturdays as working time. Then create a recurring exception for every other Saturday as non-working. Project 2007 introduced the recurring exception and this negates the need for manually marking each non-working Saturday. This method works in all Project releases beginning with 2007.
Reply With Quote
  #5  
Old 06-27-2014, 09:07 PM
marif300 marif300 is offline Saturday off alternately Windows XP Saturday off alternately Office 2007
Advanced Beginner
Saturday off alternately
 
Join Date: Jun 2014
Location: Pakistan
Posts: 38
marif300 is on a distinguished road
Default

I just want to mark 1st and 3rd Saturday off only. It means, this change can be possible by manual process only.
Reply With Quote
  #6  
Old 06-28-2014, 06:16 AM
JulieS JulieS is offline Saturday off alternately Windows 7 64bit Saturday off alternately Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I think we are talking past one another. What exactly do you mean by "manual process only." I have explained (briefly) how to create a calendar and use the recurring exceptions to mark every other Saturday off which will not require you to manually change every Saturday. For step by step:

  1. Create a new calendar in Project 2007.
  2. In the Change Working Time dialog, click the Work Weeks tab, select the [Default] entry and click the Details button to open the Details for [Default] dialog.
  3. Select Saturday from the Select days list.
  4. Click the button next to Set day(s) to these specific working times:
  5. Enter the working times for Saturdays.
  6. Click OK to close the Details for [Default] dialog.
At this point you now have a calendar with every Saturday as working. Now you need to create a recurring Exception to mark every other Saturday off.

  1. Still in the Change Working Time dialog with the custom calendar open, click the Exceptions tab.
  2. Select the first Saturday in June - June 7
  3. Click in the first empty row on the Exceptions tab and name the Exception "Alternate Saturday".
  4. Click in the Start field to populate the start and finish with June 7, 2014.
  5. Click the Details button to open the Details for "Alternate Saturday" dialog.
  6. Under Recurrence pattern select Weekly.
  7. Select Recur every 2 weeks on Saturday.
  8. Set your range of recurrence as needed.
  9. Click OK to close the Details dialog and return to Change working time.
You now have a calendar where every other week has a working Saturday. You may now copy this calendar to the Organizer to make it available in all new projects.
Attached Images
File Type: png Details.png (36.3 KB, 34 views)
Reply With Quote
  #7  
Old 06-29-2014, 08:25 PM
marif300 marif300 is offline Saturday off alternately Windows XP Saturday off alternately Office 2007
Advanced Beginner
Saturday off alternately
 
Join Date: Jun 2014
Location: Pakistan
Posts: 38
marif300 is on a distinguished road
Default

Thanks,

I got your point.
Reply With Quote
  #8  
Old 06-30-2014, 06:23 AM
JulieS JulieS is offline Saturday off alternately Windows 7 64bit Saturday off alternately Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Great. Were you able to make the calendar to get what you need?
Reply With Quote
  #9  
Old 06-30-2014, 10:03 PM
marif300 marif300 is offline Saturday off alternately Windows XP Saturday off alternately Office 2007
Advanced Beginner
Saturday off alternately
 
Join Date: Jun 2014
Location: Pakistan
Posts: 38
marif300 is on a distinguished road
Default

By using recurrence option, we can mark every 1st, 2nd, 3rd or 4th week as off day, but my query was to mark 1st and 3rd week off simultaneously.

After using recurrence option, 1st or 3rd Saturday will have to mark as off day forcefully.
Reply With Quote
  #10  
Old 07-01-2014, 06:50 AM
JulieS JulieS is offline Saturday off alternately Windows 7 64bit Saturday off alternately Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Please re-read the step by step directions again. You select Weekly every 2 weeks on Saturday starting with the first Saturday of the month you will see every other Saturday is off.
Reply With Quote
  #11  
Old 07-14-2014, 09:48 PM
marif300 marif300 is offline Saturday off alternately Windows XP Saturday off alternately Office 2007
Advanced Beginner
Saturday off alternately
 
Join Date: Jun 2014
Location: Pakistan
Posts: 38
marif300 is on a distinguished road
Default

By using this option, every 2nd Saturday is marked as off day, while I just want 1st and 3rd Saturday of every month as off day.

See attached file

Regards,

Arif
Attached Images
File Type: jpg problem.JPG (129.4 KB, 30 views)
Reply With Quote
  #12  
Old 07-15-2014, 06:28 AM
JulieS JulieS is offline Saturday off alternately Windows 7 64bit Saturday off alternately Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Okay, so in months with 5 weeks you would still only get the first and third Saturday off? In that case, create two recurring exceptions - one for the first Saturday of every month and one for the third Saturday of every month.
Attached Images
File Type: jpg saturday.jpg (128.7 KB, 30 views)
Reply With Quote
  #13  
Old 07-15-2014, 06:31 AM
JulieS JulieS is offline Saturday off alternately Windows 7 64bit Saturday off alternately Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Here are the detailed screen shots for both the First Saturday and Third Saturday
Attached Images
File Type: jpg first.jpg (55.4 KB, 31 views)
File Type: jpg third.jpg (57.4 KB, 29 views)
Reply With Quote
  #14  
Old 07-15-2014, 08:42 PM
marif300 marif300 is offline Saturday off alternately Windows XP Saturday off alternately Office 2007
Advanced Beginner
Saturday off alternately
 
Join Date: Jun 2014
Location: Pakistan
Posts: 38
marif300 is on a distinguished road
Default

Great!

Now it is working perfectly.

Thanks alot

Regards,

Arif
Reply With Quote
  #15  
Old 07-16-2014, 06:31 AM
JulieS JulieS is offline Saturday off alternately Windows 7 64bit Saturday off alternately Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Great. Glad we were finally able to get it sorted.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2013 macro to generate last day of each week (Saturday) CrabApple Word 1 11-08-2013 02:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft