Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-09-2016, 02:22 PM
Tinbot11 Tinbot11 is offline Night shift and Day shift Windows 10 Night shift and Day shift Office 2007
Novice
Night shift and Day shift
 
Join Date: May 2016
Posts: 1
Tinbot11 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 05-09-2016, 06:32 PM
JulieS JulieS is offline Night shift and Day shift Windows 7 64bit Night shift and Day shift Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
Reply

Tags
#calendar, #nigthshift, #resources

Thread Tools
Display Modes


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
Night shift and Day shift 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
Night shift and Day shift Noob here - I need a shift calendar by days with count of shift. freeman Excel 8 09-12-2012 08:45 AM
Night shift and Day shift Shift cell right gsrikanth Excel Programming 2 01-17-2012 11:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:20 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