Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-20-2016, 04:07 PM
lwlewis367 lwlewis367 is offline Create a calendar based on shifts not days Windows 7 64bit Create a calendar based on shifts not days Office 2010 64bit
Novice
Create a calendar based on shifts not days
 
Join Date: Oct 2016
Posts: 1
lwlewis367 is on a distinguished road
Default Create a calendar based on shifts not days

Where I work we set our tasks on a project schedule based on a duration of shifts not days. I am trying to figure out how to get this to work and to reflect proper time frames for follow on work as the schedule code is changed.



Example:

a 1-0 calendar is one 8 hr shift 7 days a week without regards to holidays
a 1-5 calendar is one 8 hr shift 5 days a week (Mon-Fri) no holidays
a 1-6 calendar is one 8 hr shifts 6 days a week (Mon-Sat) no holidays
a 2-5 calendar is two 8 hr shift 5 days a week (Mon-Fri)
a 2-6 calendar is two 8 hr shifts 6 days a week (Mon-Sat)
a 3-0 calendar is three 8 hr shift 7 days a week without regards to holidays

Thanks in advance for help in solving this issue.
Reply With Quote
  #2  
Old 11-04-2016, 09:59 AM
JulieS JulieS is offline Create a calendar based on shifts not days Windows 7 64bit Create a calendar based on shifts not days Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I don't follow exactly. The duration of the tasks vary or do the start and finish of the tasks vary. I would suggest the following. Express the duration in days where 1 day = 8 hours. You can define multiple calendars with the different working configurations. Then add the task calendar column and change the task calendar to reflect which "shift" is going to perform the task. The duration will stay the same but the finish date will change depending upon the definition of the calendar.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
12 hour work days (shifts) John Franklin Project 22 11-12-2013 03:19 PM
12 shifts/7 days John Franklin Project 1 11-11-2013 09:11 AM
showing calendar days by keeping normal workday calendar ketanco Project 11 11-01-2013 08:27 AM
Create a calendar based on shifts not days Calendars, 12 hr shifts, 24 hrs/ 7 days John Franklin Project 3 10-30-2013 08:16 AM
calendar for rotating shifts dude1 Excel 0 05-29-2011 01:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:35 AM.


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