How to Set Up 24-Hour Shutdowns and Shift Calendars in Microsoft Project
Question details
The user needs to configure a custom schedule in Microsoft Project that includes a 10-day, 24-hour continuous work period (shutdown) alongside standard working hours and three distinct 8-hour shifts, including an overnight shift that crosses midnight.
- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Creating custom project calendars to accommodate continuous 24-hour shutdowns and multi-shift resource workforces.
- Observed behavior
- When entering an overnight shift (e.g., 6:00 AM to 6:00 AM or 10:00 PM to 6:00 AM), the system incorrectly calculates the duration as 1 hour or fails to accept the input, because the shift crosses midnight.
Ensure you have project manager permissions in Microsoft Project to create and modify base calendars and assign them to resources.
Set Up a 10-Day 24-Hour Shutdown Exception
Use this method to override your standard project calendar with a continuous 24-hour work period for a specific 10-day duration.
Instead of changing the base standard working hours for the entire project, you should create a calendar exception. This allows normal working hours to resume automatically after the 10-day shutdown period is over.
Click on the 'Project' tab in the top ribbon and select 'Change Working Time'.
Click 'Create New Calendar', choose to make a copy of the Standard calendar, and give it a recognizable name (e.g., 'Shutdown Calendar').
Navigate to the 'Exceptions' tab in the lower half of the dialog box. Type a name for the shutdown period and define the exact Start and Finish dates for the 10-day block.
Click the 'Details' button for your new exception. Select 'Working times' and adjust the hours to run continuously (e.g., 12:00 AM to 12:00 AM) to establish a 24-hour schedule for these specific days.
Configure Three Shift Calendars and Fix the Overnight Shift
Create distinct resource calendars for 1st, 2nd, and 3rd shifts, utilizing a specific workaround for shifts that cross midnight.
Simplify Project Tracking with WPS Office
While Microsoft Project is excellent for heavy-duty resource leveling, it can be overly complex for standard shift tracking and timeline management. WPS Office provides a lightweight, free alternative. Use WPS Spreadsheet's built-in Gantt chart templates to manage timelines, coordinate team shifts, and track daily tasks with a familiar, easy-to-use interface.
- 1. Download and Install: Install WPS Office for free and open the WPS Spreadsheet application.
- 2. Find a Project Template: Navigate to the template library and search for 'Gantt Chart' or 'Shift Schedule' to instantly generate a tracking sheet.
- 3. Customize Your Schedule: Input your team's shifts and project timelines seamlessly using familiar spreadsheet formulas and formatting tools.
Frequently Asked Questions
Why does my third shift change to 1 hour when I enter 6:00 AM to 6:00 AM in Microsoft Project?
Microsoft Project calculates daily schedules starting at 12:00 AM. When a shift crosses midnight, entering identical start and end times confuses the system's day-logic. You must split the shift into two blocks on the work week details tab: one block ending at 12:00 AM, and the next block starting at 12:00 AM.
Do I need to link resources together for a multi-shift project?
No, resources themselves are not linked in Microsoft Project; only tasks are linked. You should assign the built-in 24-hour calendar as the base Project Calendar, and then assign specific custom shift calendars to individual resources. The software will automatically schedule tasks based on when those resources are available.
How do I assign different shift calendars to my project team?
Open the 'Resource Sheet' view in your project. Locate the 'Base Calendar' column for each team member and select the custom shift calendar (e.g., 1st shift, 2nd shift, or 3rd shift) you previously created for them.
Can I have a 24-hour project calendar while resources work standard 8-hour shifts?
Yes. Set the Project Calendar to a 24-hour schedule (or your 10-day exception calendar). Then, ensure each resource on the Resource Sheet is assigned an 8-hour base calendar. Microsoft Project will schedule continuous work on the task only if you assign enough resources covering all three shifts.
