Sheduling with lunch break

[tinhtu]

Empolyees are scheduled to work with their lunch breaks. To make sure there is at least one person to cover, I like to visually see the bars which represent their work hours so that I can schedule lunch breaks properly.
For example:
Person A is scheduled from 8:00 to 12:00 lunch break from 12:00 to 1:00 and back to work from 1:00 to 5:00
Person B is scheduled from 8:00 to 1:00 lunch break from 1:00 to 2:00 and back to work from 2:00 to 5:00
Please help me with VBA code to automatically represent these work hours by highlighting in different columns?

 

[Akashwani]

Hi and welcome to MrExcel.

I think that you need to give a bit more information here.
Who decides which lunch period someone has?
Does this change daily?
If it's you, then perhaps this simple NONE VBA solution will work for you...

Sample data and example results using Condtional Formatting....

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1		08:00	09:00	10:00	11:00	12:00	13:00	14:00	15:00	16:00	17:00
2	Person A					X
3	Person B						X
4
Sheet1

I have filled ALL the cells green and set Conditional Formatting for any cell that contains an X, you could use Lunch, Break or any other word you choose.

I hope that helps, if not, then you really do need to provide us with a lot more information, preferably with some sample data and your expected results.

Ak

 

[tinhtu]

Hi and welcome to MrExcel.


Ak

Thank you. That should work for my case. How can I attach the excel file for you to see?

 

[Akashwani]

Hi,

You cannot attach a file, but you can post sample data using one of the links in my signature.

Ak