Employee Scheduling in Excel

[Mayrie]

My Problem:
I currently create my employee schedule in excel and I am trying to find a way to decrease the time I spend entering date. Currently worksheet A lists the employee name in the first column and the days of the week as column headers, where I input the employee shifts for the week. This view is good for the employees because it shows them their total hours for the week. But I need to make sure we have the right staffing in the different departments, we have 6 job codes. Right now I manually enter the data onto worksheet B, the set up of B is not ideal. I have the days fo the week listed as column headers and the job codes in the first column. I basically type in the shift and employee name this table to see staffing by department. This ends up taking a ridiculous amount of time.

What I Want to Do:
Worksheet A: row headers-employee name, column headers-day of the week, start and end times desplayed in table
Worksheet B: row headers-job code, column headers-day of the week, employee name and shift displayed in table
I want to be able to enter only the shift times into either table and have the other table pull the information. The problem is that I want to be able to sort my list of employees (depending on job code, shift, a to z etc) and not have it mess up the other worksheet. I thought a pivot table would work best for this, but I cannot figure out the best way to set up my worksheet to allow for all the data to be on the pivot table.

Any suggestions would be greatly appreciated!

 

[bertie]

I hope I have the layout of your worksheets OK.

On Shhet "B" I have inserted a lookup column "A" which concatenates employee_Name and day of the week

In the example below I have set up a named range
i.e, highlight range A2:E7
Insert => Name => Define
and called it data

Tip: Using Validation lists for Days of the week, Employee names and shift patterns will remove any typos

Sheet B


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 150px"><COL style="WIDTH: 140px"><COL style="WIDTH: 93px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Lookup</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Job Code</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Day of the Week</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Employee Name</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Shift</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD>BMonday</TD><TD style="TEXT-ALIGN: right">1234</TD><TD>Monday</TD><TD>B</TD><TD style="TEXT-ALIGN: right">9am</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>ATuesday</TD><TD style="TEXT-ALIGN: right">2345</TD><TD>Tuesday</TD><TD>A</TD><TD style="TEXT-ALIGN: right">10am</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>BWednesday</TD><TD style="TEXT-ALIGN: right">2345</TD><TD>Wednesday</TD><TD>B</TD><TD style="TEXT-ALIGN: right">10am</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD>DThursday</TD><TD style="TEXT-ALIGN: right">3456</TD><TD>Thursday</TD><TD>D</TD><TD style="TEXT-ALIGN: right">9am</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD>EFriday</TD><TD style="TEXT-ALIGN: right">3456</TD><TD>Friday</TD><TD>E</TD><TD style="TEXT-ALIGN: right">10am</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD>FSaturday</TD><TD style="TEXT-ALIGN: right">3456</TD><TD>Saturday</TD><TD>F</TD><TD style="TEXT-ALIGN: right">11am</TD></TR></TBODY></TABLE>


<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>A2</TD><TD>=D2&C2</TD></TR><TR><TD>A3</TD><TD>=D3&C3</TD></TR><TR><TD>A4</TD><TD>=D4&C4</TD></TR><TR><TD>A5</TD><TD>=D5&C5</TD></TR><TR><TD>A6</TD><TD>=D6&C6</TD></TR><TR><TD>A7</TD><TD>=D7&C7</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Sheet A I have set out as below

Enter the formula for row 2 and drag it down to fill out the rest of the range.

ISNA if the vlookup return #N/A the cell remain blank or else it returns the value. Relpace the double "" with anything you wish

Sorting the data will not affect the formula. However, the formula will recalculate each time the data is sorted.

Rather than sorting the data I would advise
Click within the data on sheet "A"
Data => Filter => AutoFilter
and use the drop down boxes to isolate the data you want.

With tis layout either sheet can be used for a pivot table

Hope this helps, or at least gives you some ideas

Sheet A

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 179px"><COL style="WIDTH: 79px"><COL style="WIDTH: 79px"><COL style="WIDTH: 79px"><COL style="WIDTH: 79px"><COL style="WIDTH: 79px"><COL style="WIDTH: 79px"><COL style="WIDTH: 79px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Employee Name</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Monday</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Tuesday</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Wednesday</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Thursday</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Friday</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Saturday</TD><TD style="BACKGROUND-COLOR: #000080; COLOR: #ffffff">Sunday</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD>B</TD><TD style="TEXT-ALIGN: right">9am</TD><TD></TD><TD style="TEXT-ALIGN: right">10am</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>A</TD><TD></TD><TD style="TEXT-ALIGN: right">10am</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>F</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">11am</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD>D</TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">9am</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>B2</TD><TD>=IF(ISNA(VLOOKUP($A2&$B$1,data,5,FALSE)),"",VLOOKUP($A2&$B$1,data,5,FALSE))</TD></TR><TR><TD>C2</TD><TD>=IF(ISNA(VLOOKUP($A2&$C$1,data,5,FALSE)),"",VLOOKUP($A2&$C$1,data,5,FALSE))</TD></TR><TR><TD>D2</TD><TD>=IF(ISNA(VLOOKUP($A2&$D$1,data,5,FALSE)),"",VLOOKUP($A2&$D$1,data,5,FALSE))</TD></TR><TR><TD>E2</TD><TD>=IF(ISNA(VLOOKUP($A2&$E$1,data,5,FALSE)),"",VLOOKUP($A2&$E$1,data,5,FALSE))</TD></TR><TR><TD>F2</TD><TD>=IF(ISNA(VLOOKUP($A2&$F$1,data,5,FALSE)),"",VLOOKUP($A2&$F$1,data,5,FALSE))</TD></TR><TR><TD>G2</TD><TD>=IF(ISNA(VLOOKUP($A2&$G$1,data,5,FALSE)),"",VLOOKUP($A2&$G$1,data,5,FALSE))</TD></TR><TR><TD>H2</TD><TD>=IF(ISNA(VLOOKUP($A2&$H$1,data,5,FALSE)),"",VLOOKUP($A2&$H$1,data,5,FALSE))</TD></TR><TR><TD>B3</TD><TD>=IF(ISNA(VLOOKUP($A3&$B$1,data,5,FALSE)),"",VLOOKUP($A3&$B$1,data,5,FALSE))</TD></TR><TR><TD>C3</TD><TD>=IF(ISNA(VLOOKUP($A3&$C$1,data,5,FALSE)),"",VLOOKUP($A3&$C$1,data,5,FALSE))</TD></TR><TR><TD>D3</TD><TD>=IF(ISNA(VLOOKUP($A3&$D$1,data,5,FALSE)),"",VLOOKUP($A3&$D$1,data,5,FALSE))</TD></TR><TR><TD>E3</TD><TD>=IF(ISNA(VLOOKUP($A3&$E$1,data,5,FALSE)),"",VLOOKUP($A3&$E$1,data,5,FALSE))</TD></TR><TR><TD>F3</TD><TD>=IF(ISNA(VLOOKUP($A3&$F$1,data,5,FALSE)),"",VLOOKUP($A3&$F$1,data,5,FALSE))</TD></TR><TR><TD>G3</TD><TD>=IF(ISNA(VLOOKUP($A3&$G$1,data,5,FALSE)),"",VLOOKUP($A3&$G$1,data,5,FALSE))</TD></TR><TR><TD>H3</TD><TD>=IF(ISNA(VLOOKUP($A3&$H$1,data,5,FALSE)),"",VLOOKUP($A3&$H$1,data,5,FALSE))</TD></TR><TR><TD>B4</TD><TD>=IF(ISNA(VLOOKUP($A4&$B$1,data,5,FALSE)),"",VLOOKUP($A4&$B$1,data,5,FALSE))</TD></TR><TR><TD>C4</TD><TD>=IF(ISNA(VLOOKUP($A4&$C$1,data,5,FALSE)),"",VLOOKUP($A4&$C$1,data,5,FALSE))</TD></TR><TR><TD>D4</TD><TD>=IF(ISNA(VLOOKUP($A4&$D$1,data,5,FALSE)),"",VLOOKUP($A4&$D$1,data,5,FALSE))</TD></TR><TR><TD>E4</TD><TD>=IF(ISNA(VLOOKUP($A4&$E$1,data,5,FALSE)),"",VLOOKUP($A4&$E$1,data,5,FALSE))</TD></TR><TR><TD>F4</TD><TD>=IF(ISNA(VLOOKUP($A4&$F$1,data,5,FALSE)),"",VLOOKUP($A4&$F$1,data,5,FALSE))</TD></TR><TR><TD>G4</TD><TD>=IF(ISNA(VLOOKUP($A4&$G$1,data,5,FALSE)),"",VLOOKUP($A4&$G$1,data,5,FALSE))</TD></TR><TR><TD>H4</TD><TD>=IF(ISNA(VLOOKUP($A4&$H$1,data,5,FALSE)),"",VLOOKUP($A4&$H$1,data,5,FALSE))</TD></TR><TR><TD>B5</TD><TD>=IF(ISNA(VLOOKUP($A5&$B$1,data,5,FALSE)),"",VLOOKUP($A5&$B$1,data,5,FALSE))</TD></TR><TR><TD>C5</TD><TD>=IF(ISNA(VLOOKUP($A5&$C$1,data,5,FALSE)),"",VLOOKUP($A5&$C$1,data,5,FALSE))</TD></TR><TR><TD>D5</TD><TD>=IF(ISNA(VLOOKUP($A5&$D$1,data,5,FALSE)),"",VLOOKUP($A5&$D$1,data,5,FALSE))</TD></TR><TR><TD>E5</TD><TD>=IF(ISNA(VLOOKUP($A5&$E$1,data,5,FALSE)),"",VLOOKUP($A5&$E$1,data,5,FALSE))</TD></TR><TR><TD>F5</TD><TD>=IF(ISNA(VLOOKUP($A5&$F$1,data,5,FALSE)),"",VLOOKUP($A5&$F$1,data,5,FALSE))</TD></TR><TR><TD>G5</TD><TD>=IF(ISNA(VLOOKUP($A5&$G$1,data,5,FALSE)),"",VLOOKUP($A5&$G$1,data,5,FALSE))</TD></TR><TR><TD>H5</TD><TD>=IF(ISNA(VLOOKUP($A5&$H$1,data,5,FALSE)),"",VLOOKUP($A5&$H$1,data,5,FALSE))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[Mayrie]

Thank you. This is a good start. I only have basic excel knowledge, so I hope you don't mind if I ask a few questions...
So I would input the shifts and employee name into worksheet B right? As for a simplistic view of all information (day, shift, employee and job) I would use a pivot table?

I failed to explain the way I have my shift cells set up. This is not necessarily the most efficient way, but it is the best way I know that will allow for weekly hour calculations. I have 2 cells for each shift, one for a start time, and one for an end time. For example.

Employee Monday Tuesday... Sunday Tot Hrs
A 9 am 6 pm 9

Is there a way to incorporate this into the example you gave?

Thanks so much for taking the time to reply!

 

[Mayrie]

Also in worksheet B, there is the column for the day of the week and then column for employee. I need to be able to list more than one employee for each day of the week (up to the number of employees I have, 20). and each employee may be assigned different job codes on different days. I think that part is easy I can just type the job code in. But it seems like I would have an extremely long list, having to create a new row for the day of the week for each new shift scheduled? Of course I could be interpreting your suggestion all wrong...Is there another way?


Much appreciation in advance

 

[asad]

Are you looking for something like this

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK
1	20/09/2009
2
3	Name	Mon	Start	Finish	Tue	Start	Finish	Wed	Start	End	Thu	Start	End	Fri	Start	End	Sat	Sun		Mon Hrs	Mon Hrs	Tues Hrs	Tues Hrs	Wed Hrs	Wed Hrs	Thu Hrs	Thu Hrs	Fri Hrs	Fri Hrs	Sat Hrs	Sat Hrs	Total (N1)	Total (N15)	Total (N2)	RDO	Total Hrs Week
4		14/9/09			15/9/09			16/9/09			17/9/09			18/9/09			19/9/09	20/9/09		1.00	1.50	1.00	1.50	1.00	1.50	1.00	1.50	1.00	1.50	1.50	2.00	1.00	1.50	2.00	RDO
5		Shift No			Shift No			Shift No			Shift No			Shift No			Shift No	Shift No
6	A	12	7:28	18:40	10	7:13	18:04	12	7:28	18:40	11	7:15	18:01	OFF	0:00	0:00	9	OFF	A	8:00	1:42	8:00	1:21	8:00	1:42	8:00	1:16	0:00	0:00	2:05	1:02	32:00	8:06	1:02	0:00	41:08
7	B	7	6:41	16:48	7	6:41	16:48	OFF	0:00	0:00	10	7:13	18:04	9	7:01	17:03	4	OFF	B	8:00	0:37	8:00	0:37	0:00	0:00	8:00	1:21	8:00	1:04	3:39	3:24	32:00	7:18	3:24	0:00	42:42
8	C	5	6:19	16:45	2	5:53	12:58	4	6:16	14:04	9	7:01	17:03	10	7:13	18:04	OFF	OFF	C	8:00	0:56	6:24	0:00	7:02	0:00	8:00	1:04	8:00	1:21	0:00	0:00	37:26	3:21	0:00	0:00	40:47
9	D	11	7:15	18:01	4	6:16	14:04	1	5:43	16:26	OFF	0:00	0:00	11	7:15	18:01	6	OFF	D	8:00	1:16	7:02	0:00	8:00	1:13	0:00	0:00	8:00	1:16	3:27	4:36	31:02	7:12	4:36	0:00	42:50
Sheet1

We can then build another sheet where you can allocate the line numbers to the employees and in this sheet shown above we can then have a lookup or index and match formula to work out which employee is doing what line.

 

[Mayrie]

Here is my first and second table:

<TABLE style="MARGIN: auto 6.75pt; WIDTH: 736pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-table-lspace: 9.0pt; mso-table-rspace: 9.0pt; mso-table-anchor-vertical: margin; mso-table-anchor-horizontal: margin; mso-table-left: center; mso-table-top: -42.75pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=981 align=left><TBODY><TR style="HEIGHT: 10.5pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 43pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 10.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=57 noWrap> <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 10.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

Friday<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 10.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

Saturday<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 10.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

Sunday<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 10.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

Monday<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 10.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

Tuesday<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 10.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

Wednesday<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 10.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

Thursday<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 10.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=65 noWrap>

Total<o></o>​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 43pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=57 noWrap> <o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

6/26/2009<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

6/27/2009<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

6/28/2009<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

6/29/2009<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

6/30/2009<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

7/1/2009<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 92pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=123 colSpan=2 noWrap>

7/2/2009<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 49pt; PADDING-RIGHT: 5.4pt; BACKGROUND: silver; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=65 noWrap>

Hours<o></o>​

</TD></TR><TR style="HEIGHT: 14.1pt; mso-yfti-irow: 2; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 43pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=57 noWrap>Superman<o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 46pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=61 noWrap>

11:15 AM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 46pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=61 noWrap>

12:15 AM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 49.05pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=65 noWrap>

11:15 AM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 42.95pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=57 noWrap>

6:00 PM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 42.95pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=57 noWrap>

6:00 PM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 49.05pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=65 noWrap>

12:15 AM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 46pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=61 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 46pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=61 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 46pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=61 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 46pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=61 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 46pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=61 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 46pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=61 noWrap></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 49.05pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=65 noWrap>

11:15 AM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 42.95pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=57 noWrap>

6:00 PM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 49pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.1pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=65 noWrap>

32:45:00<o></o>​

</TD></TR><TR height=0><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=68></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=61></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=61></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=65></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=57></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=57></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=65></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=61></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=61></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=61></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=61></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=61></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=61></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=65></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=57></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=65></TD></TR></TBODY></TABLE><TABLE style="MARGIN: auto auto auto 4.9pt; WIDTH: 415pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=553><TBODY><TR style="HEIGHT: 0.25in; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 125.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=167 noWrap> <o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>Friday<o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

6/26/2009<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap> <o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap> <o></o>
</TD></TR><TR style="HEIGHT: 0.25in; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 125.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=167 noWrap>Job Code 1<o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

10:30 AM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

6:00 PM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

7:30:00<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>A<o></o>
</TD></TR><TR style="HEIGHT: 0.25in; mso-yfti-irow: 2; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 125.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=167 noWrap>Job Code 2<o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

4:00 PM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

12:15 AM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

8:15:00<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>B<o></o>
</TD></TR></TBODY></TABLE>
The two table are not connected at all, I use the 2nd table to make the schedule and then transfer the data to the first table for the employees. I think your idea will work, and I could possibly incorporate it into my first table? How would I go about doing this?

Thanks!

 

[Mayrie]

<TABLE style="MARGIN: auto auto auto 4.9pt; WIDTH: 415pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=553><TBODY><TR style="HEIGHT: 0.25in; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 125.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=167 noWrap> <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>Friday<o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

6/26/2009<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap> <o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap> <o></o>
</TD></TR><TR style="HEIGHT: 0.25in; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 125.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=167 noWrap>Job Code 1<o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

10:30 AM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

6:00 PM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

7:30:00<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>A<o></o>
</TD></TR><TR style="HEIGHT: 0.25in; mso-yfti-irow: 2; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 125.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=167 noWrap>Job Code 2<o></o>
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

4:00 PM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

12:15 AM<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

8:15:00<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>B<o></o>
</TD></TR></TBODY></TABLE>


Here is the second table....

 

[asad]

<TABLE style="MARGIN: auto auto auto 4.9pt; WIDTH: 415pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=553><TBODY><TR style="HEIGHT: 0.25in; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 125.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=167 noWrap><?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>Friday<o></o>

​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

6/26/2009<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap><o></o>

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap><o></o>

</TD></TR><TR style="HEIGHT: 0.25in; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 125.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=167 noWrap>Job Code 1<o></o>

​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

10:30 AM<o></o>

​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

6:00 PM<o></o>

​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

7:30:00<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>A<o></o>

</TD></TR><TR style="HEIGHT: 0.25in; mso-yfti-irow: 2; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 125.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=167 noWrap>Job Code 2<o></o>

​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

4:00 PM<o></o>

​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

12:15 AM<o></o>

​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>

8:15:00<o></o>​

</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 72.4pt; PADDING-RIGHT: 5.4pt; HEIGHT: 0.25in; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in" vAlign=bottom width=97 noWrap>B<o></o>

</TD></TR></TBODY></TABLE>


Here is the second table....

What does A and B stand for?

The way I would do it is just get a list of job codes and their respective start and finish times along with the total paid hours. Then I would just make a validation list in Table 1 to allocate each employee their job code and the times will be picked by the formula either vlookup or index and match - Your choice.
How do you actually allocate the jobs to employees? Is there a set criteria or just random?

 

[asad]

Excel Workbook
	B	C	D	E	F
1	20/09/2009
2
3	Name	Mon	Start	Finish	Paid Hrs
4		14/9/09
5		Shift No
6	A	Job Code 1	10:30	18:00	7:30
7	B	Job Code 2	16:00	0:15	8:15
8	C	Job Code 4	3:00	12:45	9:45
9	D	Job Code 3	21:30	6:30	9:00
10
11
12
13
14
15	Job Code 1	10:30 AM	6:00 PM	7:30:00
16	Job Code 2	4:00 PM	12:15 AM	8:15:00
17	Job Code 3	9:30 PM	6:30 AM	9:00:00
18	Job Code 4	3:00 AM	12:45 PM	9:45:00
19	Job Code 5	8:30 AM	7:00 PM	10:30:00
Sheet1

I have Named the range B15 - B19 as Jobs and used Data Validation --> Settings --> Allow --> List and in the formula I used "=Jobs". This is done to make sure there is no Typo because the vlookup formula will not pick the times if the Job Code is spelt wrong.

 

[Mayrie]

For the job codes, each employee is trained in at least 1 area, but up to 3 or 4 areas. And one person can work in a different area on different days of the week. I assign the job codes when I put the schedule together.

Also, the business is entertainment/service and I schedule up to 100 hours on any given day. For one job code I usually have to schedule several different timed shifts in one day. It can get pretty complex, and I want a way to visualize the shifts so I know I am staffing appropriately, that's why I use table 2, and then transfer to table 1.

I don't know if I am explaining everything I need to correctly. It just seems like what I am trying to do is more complex...what do you think?