We help IT Professionals succeed at work.

change excel timeline based on shift times

kwatt562 asked
Last Modified: 2012-05-11
Need some help with this, have tried using formulas but think some vba is needed to help with this problem. On the attached file (shifts worksheet) it outlines the start and end time for two shifts - Day & Night. the sheet next to it (Machine Selector) shows the timeline for the machine for each day. What I want to do is when the shift times are modified for say Monday, the cells on the timeline for monday are modified in the following way.
Day shift might start 7:30 to 4pm, thus the timeline would have the cells clear and available for that period, night shift might start at 21:30 to 7:30 am, so between 4pm anf 21:30pm there is no shift so the timeline would display NA. However if I decided to run overtime and modify the shift end time of day shift to 7pm, then the time line would update to show those cells (blank)

I hope its clear, thanks plant-load-trials.xlsm
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.