
Nov 28, 2014
I am often asked how to schedule non-working time for resources in Project 2013 who have a nine day fortnight so I have put together this little set of instructions. It is actually a lot easier than you would imagine it would be. For RDOs, use the person’s resource calendar. It has the same name as that resource. (You can either use the “Change Working Time” icon on the Project tab and choose the “Resource Calendar” or you can go to the “Resource Sheet” and double click on the Resource you want to change.)- On the Exceptions tab, add a name for the exception e.g. RDO, start date, and finish date for the RDO day.
- Click Details.
- Under Recurrence pattern, pick how often the RDO day repeats (e.g. every 2 weeks on a Friday).
- Under Range of recurrence, add the first non-working date in the Start box.
- Click End after or End by.
- End after: Choose how many times it repeats.
- End by: Choose when the repeating time off ends. (You could use the Project Finish Date or have no end date so that you could use this as a template calendar for future projects)
How do your Excel skills stack up?
Test NowNext up:
- ‘CONNECT ANY DATABASE’ in SQL Server 2014
- Using the ‘Flash Fill’ feature to apply the desired formatting in Excel 2013
- Here’s how situational leaders spend more time watching sunsets than watching their people
- Save time with print presets in Adobe InDesign CS6
- Normalising your database: First Normal Form (1NF) – Part 1
- Change the Spell Check Language on all slides in PowerPoint using VBA (2007 onwards)
- Fruitcakes and lines in the sand
- The changing face of the Office 365 plans
- Two ways to put a sticky note on your desktop
- Excel formulas are not just for numbers
Previously
- Apply permissions on web parts in SharePoint
- Fabulous, fitting feedback
- Comparing and combining two lists using VLOOKUPs
- The Windows Server 2012 R2 Desktop Experience
- Removing the background from a picture in Microsoft Office
- Deliver successful organisational transformation
- Using SharePoint to create a ‘Team Based Master Calendar’
- Control your digital world from your mobile device
- Charts that aren’t charts
- Using Delegates in .NET