Skip to main content
Go Search
MPUG Home
Membership
Resources
User Group Chapters
Knowledge Library
About MPUG
MySite
  

 

Ask the Experts: The Case of the Calendar Changes 

News Archive
Ask the Teacher: Earned Value Doesn’t Want to Calculate
Setting Recurring Non-working Time in Microsoft Office Project Standard 2007
Back to the Future
Ask the Teacher: Substituting Resources, Plus Changing the Current Date
4 Formulas for EPM Disaster
Ask the Experts: Define Critical
Oracle on Track to Buy Primavera
Ask the Experts: Why Self-Taught with Microsoft Project Isn't Such a Great Idea
Laying the Foundation for Leading a Project Management Office
Mail: Another Perspective on Defining "Critical"
Certification Insider: Creating a Project from an Existing One
A Rational Approach to Padding
Ask the Expert: Accounting for Material Resources
Chapter Spotlight: 3 Questions with London's Dharmesh Patel
Olympian Stephanie Trafton Connects Winning the Gold with Project Management
5 Compelling Reasons to Upgrade to Project 2007: Visual Reports
Ask the Experts: Displaying Availability Exceptions in Resource Usage Sheet
Certification Insider: How Calendars Control Schedules
Chapter Spotlight: 4 Questions with Houston's Vicki Eaker
The 30-second Report
Ask the Expert: Separating Time Completed from Work Completed
Certification Insider: Defining Working Times with Project 2007 Calendars
Columns I'd Like to See in Project
PMI Releases Updates to Four Standards
How to Reduce Your Project Costs
Ask the Expert: Custom Reports in Microsoft Project
The Work Breakdown Structure
The Strategies of Microsoft Project and Project Server
Certification Insider: Ready! Set! Start Creating Tasks!
Track Project Progress with Physical % Complete
Putting Project Portfolio Management to Work in a Bad Economy
Chapter Spotlight: 4 Questions with Twin Cities' Larry Christofaro
11 Reasons You Should Attend the Microsoft Project Conference
The Case of the Broken Task in Microsoft Project
Ask the Expert: Importing Data from Excel into Project
Certification Insider: Arranging Tasks
Ask the Expert: When Scheduling, Start at the Beginning
Chapter Spotlight: 3 Questions with Baltimore-Washington Metro's Gerald Leonard
Ask the Expert: Tips for Getting Project Server Buy-in from Users
Migrating to Microsoft Project Server 2007: Lessons from the Field
How Gantt Chart-Literate Are You?
Develop Your Project Management Skills: Scenes in the Negotiation Play
Ask the Expert: Optimize Microsoft Project Performance
Ask the Expert: Creating a Limited Resource Availability Schedule
Scheduling Master: Finish to Start Successors
How Gantt Chart-Literate Are You: The Puzzler Solution
The Power of Local Resources in Microsoft Project Server
Certification Insider: How To Influence Tasks and Win Friends (in Microsoft Project)
Ask the Experts: When % Complete Won't Calculate
Ask the Experts: Making Interim Plans Work for You
Project Budgeting: Money Changes Everything
Ask the Experts: How Resource Sharing Works in a Master Project
5 Principles of Program Management for the London Olympics
Certification Insider: Resourcing Project Plans
How to Replace Generic Resources with Named Resources
Ask the Experts: Building What-if Slack Time into Your Schedule
Automated Governance for Portfolio Management
Earn Your PMI-SP, Part 1: Explore the Credential
Creating Microsoft Project Custom Toolbars in 4 Steps
Certification Insider: Assigning Resources in Microsoft Project
Ask the Experts: When Linking Summary Tasks Makes Sense
Earn Your PMI-SP, Part 2: The Application Process and Getting Through the Exam
Working the Numbers: How to Inject Financial Savvy into Project Management
MPUG Thanks Community Leaders in Award Ceremony
Tips and Tricks for Microsoft Project 2007: Creating Useful Custom Views
Ask the Experts: Applying Two Constraints on One Task
Earn Your PMI-SP, Part 3: What You Need to Study
Best Practices for Microsoft Project, Part 1
Best Practices for Microsoft Project, Part 2
Certification Insider: Mastering Duration, Work, and Units
Creating Milestone Reports in Microsoft Project
Ask the Experts: Managing That Schedule with Drop-dead Deadlines
The Project 2010 Interview: Microsoft's Chris Capossela Talks to the Microsoft Project Community
How to Restore an Abandoned Project Schedule
Certification Insider: Modifying Resource Assignments
Why MPUG: Five Perspectives, One Member
The Purpose of Project Charters
Forecasting Schedule Issues with a Deadline Dashboard
Ask the Experts: Printing Notes in a Project
How to Achieve a More Realistic Schedule in Your Project Planning
Is Microsoft Project a Project Management Tool?
The New Year's Resolution of a Project Manager
Certification Insider: Understand Critical Path
Project Programming: Integrating Project Server's Timesheet with an Access Control System
Ask the Experts: What's Going on This Week?
Critical Path 2.0
Certification Insider: Exchanging Data between Programs
ProjecTalk Goes On the Air!
Ask the Experts: Making Sense of Current Activity Reports
Three Rules for a Happy Life with Project 2007
Project Date Numbering
Sign Up for MPUG Chapter Alerts!
MPUG Members: Tell Us What You're Going to Love about Microsoft Project 2010 -- and Get a Free Copy of the Software!
Microsoft Project 2010: Preparing for Launch
Certification Insider: Saving and Modifying Baselines
Ask the Experts: Creating a Report with Task and Resource Data
Microsoft Project 2010 Licensing
Microsoft Project 2010 Upgrade Path
Project Server 2010: Things to Note, and Avoid, as You Start the 2010 Journey
5 Tips for Formatting Text on a Gantt Chart
Microsoft Project 2010 Feature Rally: Sync to SharePoint
Microsoft Project 2010 Feature Rally: Manually Scheduled Tasks
Microsoft Project 2010 Feature Rally: Departmental Fields
Microsoft Project 2010 Feature Rally: Inactive Tasks
Microsoft Project 2010 Feature Rally: Team Planner
Microsoft Project 2010 Feature Rally: Reporting
Microsoft Project 2010 Feature Rally: The Ribbon
Microsoft Project 2010 Feature Rally: Synching with SharePoint
Microsoft Project 2010 Feature Rally: Project Timeline
Microsoft Project 2010 Feature Rally: Integrated Portfolio Management
Microsoft Project 2010 Feature Rally: No More ActiveX!
Microsoft Project 2010 Feature Rally: ROG, the Red Over-allocation Guy
Certification Insider: Making Resource Assignments Realistic
Ask the Experts: Exporting Only Tasks to Excel
The Great Demo! Top 10 List
The Great Demo! Top 10 List
Microsoft Project View Mastery
EPK Cost Tackles Cost Management for Microsoft Project Server
Lock Down Microsoft Project Progress Data
Certification Insider: Resource Overallocations
Don't Touch That Dial! What to Do Before Using Microsoft Project
Ask the Experts: Managing a Large Number of Resources
10 Easy Ways to Earn PDUs
The Awful Demo: Top 10 List of What NOT to Do
Microsoft Project Certification 2010 - How To Guide
Microsoft Project Certification 2010 Frequently Asked Questions
Ask the Experts: Quick Project Status Report
Schedule Tasks Your Way
Start Your Project Management Career
Calendar Exceptions in Microsoft Project 2010
Social Networking in Project Management, Part 1: Using Twitter
Ask the Experts: Updating the Baseline
Keeping Your Project Schedules Updated by the Team without Microsoft Project
Social Networking in Project Management, Part 2: Using Facebook, Blogging, and More
PMI Keynoters Clinton and Kundra Highly Value PMers
Laser Construction Wins PMI's Project of the Year Award
MPUG Mega-Guide for Learning Project 2010
Ask the Experts: Reports on Over-allocated Resources
Get To Your Control Documents Easily!
Three Reporting Questions
Certification Insider: Tracking Project Progress
The All-Time, Number-One Mistake Made by Schedulers
5 Reasons Not to Attend a PMP Exam Boot Camp
Ask the Experts: Bothersome Behavior of the New Version of My Old Friend
A Microsoft Project Beta Exam Experience
Certification Insider: Managing Multiple Projects
Focus: Getting Your Project People on the Same Page
A Call to Action: What is a Project "Schedule"?
Focus on Analytics: Stopping Project Derailments
Task Types: Don't Get Frustrated!
Ask the Experts: Configuring the Project Server 2010 Enterprise Global Template
Response to "What is a Project Schedule?"
Focusing on Deliverables, Not Just the Schedule
Certification Insider: Microsoft Project Budgets and Costs
Ask the Experts: Is Microsoft Project Overkill? And the Task Inspector Equivalent
The Basics of Estimation with Microsoft Project
How to Sell Project Management to Senior Executives Who Don't Want It
The Model Project Management Office
The Project Communication Plan
A Master at Project Management
Ask the Experts: Working Offline in Project Server 2010
10 Trends Ruling Project Management That Will Affect Your Future
Chapter Spotlight: 4 Questions with Madison's Wendy Anderson
How to Get Certified in Microsoft Project 2010
Certification Insider: Project Reporting
10 Key Business Analysis Trends to Guide Your IT Organization to Greater Results in 2011
Ask the Experts: 15 Microsoft Project Tips for New Users
Creating a High Performance Project Team
Tips for Taking the Microsoft Project 2010 Certification Exam
The Missing Link in Microsoft Project 2010: Project Financial Intelligence
Arpan Shah, Head of Microsoft Project Product Management, Discusses Service Pack 1
The Seven Deadly Sins of Project Schedules
Ask the Experts: Hammock Tasks
Project Management Advice: The Price of Right
Certification Insider: Analyzing Variance with Microsoft Project
How To Display Lag between Tasks in Your Gantt Chart
Tips on Handling a Problem Team Member on your Project
The Art and Science of Estimating Task Lengths
High-flying Jumpstart: Cloud-based Project Management
How to Use Free Analyst Reports to Build Your Case for Microsoft Project
Ask the Experts: Combining Resources across Projects
When Did You Revise the Estimates?
What's the Status of the Program? Dynamic Program Reporting
When Are You Working? Updating a Resource Calendar
Cost Decisions in Project Management Accounting
Ask the Experts: The Case of the Calendar Changes
Project Directions: Microsoft's Arpan Shah Fields Questions
What You Need to Know about Project Server 2010 Service Pack 1, Part 1
pmi2011
Is Project Management a Profession?
Project Pearls: Eliminate Over-Allocations
Microsoft Project on the Go
Ask the Experts: Selling your Message with the Project 2010 Timeline View
Quick Access Toolbar for Easy Navigation in Microsoft Project
Using Project Management for Social Change
Change Management during a Project Server Implementation
The Most-Read MPUG Microsoft Project Articles of 2011
The Most Viewed MPUG Forums Threads of 2011
Three Common Principles for Project Initiation
Ask the Experts: Over-allocation with 2.5 Hours of Work?
Group Resources for Effective Reports!
Too Tired to Care? Regain Your Perspective with 5 Proven Practices
Ask the Experts: Tying Tasks and Assignments across Projects
Manage Scheduling Contingency
Project Portfolio Management: Align Project Resources with Business Strategy
Team Players: Exchanging Project Data with Your Development Team
Ask the Experts: A Successful EPM Implementation Has More than Technology
Dealing With Uncertainty in Project Schedules
Microsoft Project Options you want to know about
Performance Tuning Your Scheduling Practices
Project Options You Want to Know About
Microsoft Community Leader Award Winners
8 Important Lessons I Learned During EPM Implementations
Insights for Scheduling
Creating an Agile Schedule with MS Project
Ask the Experts: Similar Task Names
Habits: Why Trader Joe’s Serves Free Coffee Every Day of the Year
Toolbar and Menu Commands for Microsoft Project 2007
 
 

Wayne from Santa Fe, NM asks: I created a project containing 400 tasks. After entering the tasks I realized that my calendar wasn't correct and made some changes. I also changed the Calendar options. The changes affected the task durations as well as the assignments and didn't result in what I was hoping for. What did I do wrong?

Ellen answers: You have discovered a feature that all levels of Microsoft Project have that encourages the user to establish the project calendar and calendar options before entering tasks.

Project provides access to calendars available for use in a project through the "Change Working Time" function. Think of Change Working Time as an access point to the group of calendars that will be available to be used in your project. You can use any calendar as the project, task, or resource calendars. When you adjust a calendar through Change Working Time, you're not assigning any specific calendar as the project calendar.

To assign a project calendar, for all versions of Microsoft Project click on:

Project | Project Information

Calendar option settings should be specified before entering tasks. If the settings are changed after tasks are entered, the duration values most likely will be affected. These settings are specified for each project. However, in Project 2010 you can set them to be consistent for all new projects.

To view and change the Calendar options for all projects in Project 2010, click on:

File | Options | Schedule

If you're using an earlier version of Project and you want to view and change calendar options, click on:

Tools | Options | Calendar

The Calendar settings that should be addressed for projects are default start and finish times as well as hours per day, hours per week, and days per month.

The values for default start and finish times are needed to establish the start and finish times of tasks if times aren't specified. In other words, if the tasks contain relationships, times will be calculated based on the relationships. Tasks might also have a constraint that will specify a time. If neither of those situations exists, this is the time that will be used to schedule a task.

When a task is entered, the values in these option fields will be used to determine the number of hours of work that will occur per day, per week, or number of days per month. The values in the options shouldn't be changed after tasks have been entered. To see the effect of making these changes, here are some examples.

I've entered Task 1 into a project file:

Lehnert Figure 1

I've set calendar hours per day to eight:

Lehnert Figure 2

Here is the result of changing that setting from eight hours to seven:

Lehnert Figure 3

Note that the Duration changed to 1.14 days. The task picked up the value of one day equaling eight hours when it was entered, and it will hold that value. The setting only affects future tasks that are entered. The existing tasks keep the setting of eight hours as one day on Task 1. The 1.14 days that shows up is the duration that will be necessary to accommodate the eight hours the task requires when a day contains a possible seven hours of work.

Below, in Figure 4, I've added Task 2 with the calendar option of hours per day set to seven. Note the difference in the task lengths.

Lehnert Figure 4

The next step is to assign a resource and then change the calendar to see the result.

In the next example I've assigned a resource to both tasks using the default calendar times of eight to five. Note that Task 1 is for eight hours of work and Task 2 is for seven hours of work.

Lehnert Figure 5

Next I change the Project Calendar to reflect that the work day is four hours long. Here's the result of the adjustment to the assignments. Note that the work day for each day doesn't exceed four hours. The duration of the tasks are affected as well.

Lehnert Figure 6

So best practice says to enter Project Calendar and Calendar option settings before the tasks are entered.

Note! When using the import function to a new project, the values might not be set correctly, particularly in Microsoft Project versions prior to 2010. Consider creating a file, entering the correct settings, and then importing tasks by appending them to the end of an existing project.

Ellen Lehnert
With over 20 years of corporate training experience, Ellen Lehnert, MVP, PMP, MCT, MCITP, is a specialist in Microsoft Project and Microsoft Project Server. She's the co-author of "Managing Projects with Microsoft Project 2010 Desktop," published and available for puchase through MVP-Press. Ellen brings a unique combination of licensed teacher and programming background to the classes she teaches as well as process development, installations, and consulting. Contact her at ellen@lehnertcs.com or at LehnertCS.

Do you have a question for our experts? Send that to editor@mpug.com. 

 

© Copyright 1997- MPUG.com. All Rights Reserved. Privacy Policy - Contact Us