Hello,

I am trying to figure out how to limit my workload a bit. When creating a schedule, I already have start time, end time and, I can easily calculate length of a shift. On another sheet, I have a graphical version of these schedules. Times are filled down in 30 minute increments in column A. The rest of columnscorrespond to employees. To enter employee's schedules into this sheet, I just enter 1 into a cell that corresponds with the employee's name and start time and drag that cell down until the end of their shift time.

Question is...can excel look up that employee's start time and enter 1 into cells until the end time (or down to match the length of the shift). In other words, John Smith works from 8:00 AM to 5:00 PM. Excel would need to find John Smith column. Then, it would go down to row corresponding with 8:00 AM and enter 1 into it. It would continue entering 1 into each cell in the same column until either length of shift condition is met or until it reaches the row corresponding to the end of shift time.

Let me know if that makes sense. I'm not sure if there is a formula for this or if I should have posted this into VBA thread because it's a more of a programming thing?

Any help/advice is appreciated!!