#1
|
|||
|
|||
Night shift and Day shift
Hi guys,
I have a query, i am programming some construction works and we are permitted to work at night and during the day. Of a night we are able to work Sunday Night through to Thursday morning (Wednesday night/Thursday morning). Of a Day we are working from Monday to Friday with normal hours of 6AM to 6PM. My issue is that i want to show my night works and day works in the same program, how do i make a calendar for the night shift that runs from Sunday to Thursday morning and not have all my day works instantly start working on Sunday, can i assign the night shift calendar to resources and do it that way? is so how? Any help greatly appreciated. Cheers. |
#2
|
|||
|
|||
The easiest method would be to create the night calendar and assign it to resources who work nights. If then assign those resources to tasks - the tasks will shift to align with their calendars.
Take a look at the built-in Night Shift calendar as an example of calendars that span over mid-night. Let's say your schedule is 11:00 pm - 7:00 pm starting Sunday night. For Sunday the working hours would be 11:00 pm - 12:00 am. Monday 12:00 am - 7:00 am 11:00 pm - 12:00 am The pattern established for Monday would run through Thursday morning. You'd also need a "day shift calendar" from 6:00 am to 6:00 pm Monday through Friday. Assign that base calendar to resources who work days. |
Tags |
#calendar, #nigthshift, #resources |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculate time from midnight on (Weekend hours, Fri-Sat night shift problem) | stormrider2230 | Excel | 1 | 01-20-2016 01:41 PM |
shift line | paulxxx | Word | 2 | 04-21-2013 05:44 AM |
How to prohibit the using of SHIFT key using VBA | beginner | Excel Programming | 5 | 04-17-2013 10:48 AM |
Noob here - I need a shift calendar by days with count of shift. | freeman | Excel | 8 | 09-12-2012 08:45 AM |
Shift cell right | gsrikanth | Excel Programming | 2 | 01-17-2012 11:29 PM |