I'm having an issue with my gantt chart. I have a list of employees and their starting and ending shifts times. I have 24 hours across the top in 15 minute intervals. The very last column is being shaded for everyonee. The 11:45 (23:45) box.
Here is my formula. =AND(M$1>=$H2,N$1<=$I2)
The chart is huge so I'm not sure about cut and paste onto here. In the formula above M is the starting point, so midnight in my case, H is the start time of the employees shift, N is 12:15am and I is the ending time of the employees shift.
Also- how do I get a border around the whole shaded shift of one employee?