At Work Employees Gantt Chart

27458

Board Regular
Joined
Sep 20, 2004
Messages
71
I'm trying to create a gantt chart that allows me to see how many employees are on the clock at certain times. I have a gantt set up that thru conditional formating highlights the cells yellow if the employee is scheduled. I used various sources to try to get excel to count the number of yellow cells, but couldn't get it to work. Probably because the cells themselves were set to conditional formating. Then I tried to enter a formula to put "W" for work and "O" for off, then a simply countif to count by hourly increments. I can't get it to work. I suspect it has something to do with the fact that for the end times after midnight, I'm entering in for example, 3am as 27:00.

Basically, what I need is not necessary a gant chart, but I will have a list of employees in column A and start time in Column B and end time in column C. I then need to be able to determine how many employees were on the clock at each hourly increment.

Any help would be greatly appreciated. I hope my code comes thru.


<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=28><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - Night SAA Gantt2.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2002 XP : OS = Windows XP </FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=28><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb755237><INPUT onclick='window.clipboardData.setData("Text",document.formFb078704.sltNb935705.value);' type=button value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=28><TABLE border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb078704.txbFb426622.value = document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION value='=IF($B2<D$1,"W","O")' selected>D2<OPTION value='=IF($B2<E$1,"W","O")'>E2<OPTION value='=IF($B2<F$1,"W","O")'>F2<OPTION value='=IF($B2<G$1,"W","O")'>G2<OPTION value='=IF($B2<H$1,"W","O")'>H2<OPTION value='=IF($B2<I$1,"W","O")'>I2<OPTION value='=IF($B2<J$1,"W","O")'>J2<OPTION value='=IF($B2<K$1,"W","O")'>K2<OPTION value='=IF($B2<L$1,"W","O")'>L2<OPTION value='=IF($B2<M$1,"W","O")'>M2<OPTION value='=IF($B2<N$1,"W","O")'>N2<OPTION value='=IF($B2<O$1,"W","O")'>O2<OPTION value='=IF($B2<P$1,"W","O")'>P2<OPTION value='=IF($B2<Q$1,"W","O")'>Q2<OPTION value='=IF($B2<R$1,"W","O")'>R2<OPTION value='=IF($B2<S$1,"W","O")'>S2<OPTION value='=IF($B2<T$1,"W","O")'>T2<OPTION value='=IF($B2<U$1,"W","O")'>U2<OPTION value='=IF($B2<V$1,"W","O")'>V2<OPTION value='=IF($B2<W$1,"W","O")'>W2<OPTION value='=IF($B2<X$1,"W","O")'>X2<OPTION value='=IF(B2>0,C2-B2,"")-Y2'>Z2<OPTION value==Z2*5>AA2<OPTION value='=IF($B3<D$1,"W","O")'>D3<OPTION value='=IF($B3<E$1,"W","O")'>E3<OPTION value='=IF($B3<F$1,"W","O")'>F3<OPTION value='=IF($B3<G$1,"W","O")'>G3<OPTION value='=IF($B3<H$1,"W","O")'>H3<OPTION value='=IF($B3<I$1,"W","O")'>I3<OPTION value='=IF($B3<J$1,"W","O")'>J3<OPTION value='=IF($B3<K$1,"W","O")'>K3<OPTION value='=IF($B3<L$1,"W","O")'>L3<OPTION value='=IF($B3<M$1,"W","O")'>M3<OPTION value='=IF($B3<N$1,"W","O")'>N3<OPTION value='=IF($B3<O$1,"W","O")'>O3<OPTION value='=IF($B3<P$1,"W","O")'>P3<OPTION value='=IF($B3<Q$1,"W","O")'>Q3<OPTION value='=IF($B3<R$1,"W","O")'>R3<OPTION value='=IF($B3<S$1,"W","O")'>S3<OPTION value='=IF($B3<T$1,"W","O")'>T3<OPTION value='=IF($B3<U$1,"W","O")'>U3<OPTION value='=IF($B3<V$1,"W","O")'>V3<OPTION value='=IF($B3<W$1,"W","O")'>W3<OPTION value='=IF($B3<X$1,"W","O")'>X3<OPTION value='=IF(B3>0,C3-B3,"")-Y3'>Z3<OPTION value==Z3*5>AA3<OPTION value='=IF($B4<D$1,"W","O")'>D4<OPTION value='=IF($B4<E$1,"W","O")'>E4<OPTION value='=IF($B4<F$1,"W","O")'>F4<OPTION value='=IF($B4<G$1,"W","O")'>G4<OPTION value='=IF($B4<H$1,"W","O")'>H4<OPTION value='=IF($B4<I$1,"W","O")'>I4<OPTION value='=IF($B4<J$1,"W","O")'>J4<OPTION value='=IF($B4<K$1,"W","O")'>K4<OPTION value='=IF($B4<L$1,"W","O")'>L4<OPTION value='=IF($B4<M$1,"W","O")'>M4<OPTION value='=IF($B4<N$1,"W","O")'>N4<OPTION value='=IF($B4<O$1,"W","O")'>O4<OPTION value='=IF($B4<P$1,"W","O")'>P4<OPTION value='=IF($B4<Q$1,"W","O")'>Q4<OPTION value='=IF($B4<R$1,"W","O")'>R4<OPTION value='=IF($B4<S$1,"W","O")'>S4<OPTION value='=IF($B4<T$1,"W","O")'>T4<OPTION value='=IF($B4<U$1,"W","O")'>U4<OPTION value='=IF($B4<V$1,"W","O")'>V4<OPTION value='=IF($B4<W$1,"W","O")'>W4<OPTION value='=IF($B4<X$1,"W","O")'>X4<OPTION value='=IF(B4>0,C4-B4,"")-Y4'>Z4<OPTION value==Z4*5>AA4<OPTION value='=IF($B5<D$1,"W","O")'>D5<OPTION value='=IF($B5<E$1,"W","O")'>E5<OPTION value='=IF($B5<F$1,"W","O")'>F5<OPTION value='=IF($B5<G$1,"W","O")'>G5<OPTION value='=IF($B5<H$1,"W","O")'>H5<OPTION value='=IF($B5<I$1,"W","O")'>I5<OPTION value='=IF($B5<J$1,"W","O")'>J5<OPTION value='=IF($B5<K$1,"W","O")'>K5<OPTION value='=IF($B5<L$1,"W","O")'>L5<OPTION value='=IF($B5<M$1,"W","O")'>M5<OPTION value='=IF($B5<N$1,"W","O")'>N5<OPTION value='=IF($B5<O$1,"W","O")'>O5<OPTION value='=IF($B5<P$1,"W","O")'>P5<OPTION value='=IF($B5<Q$1,"W","O")'>Q5<OPTION value='=IF($B5<R$1,"W","O")'>R5<OPTION value='=IF($B5<S$1,"W","O")'>S5<OPTION value='=IF($B5<T$1,"W","O")'>T5<OPTION value='=IF($B5<U$1,"W","O")'>U5<OPTION value='=IF($B5<V$1,"W","O")'>V5<OPTION value='=IF($B5<W$1,"W","O")'>W5<OPTION value='=IF($B5<X$1,"W","O")'>X5<OPTION value='=IF(B5>0,C5-B5,"")-Y5'>Z5<OPTION value==Z5*5>AA5<OPTION value='=IF($B6<D$1,"W","O")'>D6<OPTION value='=IF($B6<E$1,"W","O")'>E6<OPTION value='=IF($B6<F$1,"W","O")'>F6<OPTION value='=IF($B6<G$1,"W","O")'>G6<OPTION value='=IF($B6<H$1,"W","O")'>H6<OPTION value='=IF($B6<I$1,"W","O")'>I6<OPTION value='=IF($B6<J$1,"W","O")'>J6<OPTION value='=IF($B6<K$1,"W","O")'>K6<OPTION value='=IF($B6<L$1,"W","O")'>L6<OPTION value='=IF($B6<M$1,"W","O")'>M6<OPTION value='=IF($B6<N$1,"W","O")'>N6<OPTION value='=IF($B6<O$1,"W","O")'>O6<OPTION value='=IF($B6<P$1,"W","O")'>P6<OPTION value='=IF($B6<Q$1,"W","O")'>Q6<OPTION value='=IF($B6<R$1,"W","O")'>R6<OPTION value='=IF($B6<S$1,"W","O")'>S6<OPTION value='=IF($B6<T$1,"W","O")'>T6<OPTION value='=IF($B6<U$1,"W","O")'>U6<OPTION value='=IF($B6<V$1,"W","O")'>V6<OPTION value='=IF($B6<W$1,"W","O")'>W6<OPTION value='=IF($B6<X$1,"W","O")'>X6<OPTION value='=IF(B6>0,C6-B6,"")-Y6'>Z6<OPTION value==Z6*5>AA6<OPTION value='=IF($B7<D$1,"W","O")'>D7<OPTION value='=IF($B7<E$1,"W","O")'>E7<OPTION value='=IF($B7<F$1,"W","O")'>F7<OPTION value='=IF($B7<G$1,"W","O")'>G7<OPTION value='=IF($B7<H$1,"W","O")'>H7<OPTION value='=IF($B7<I$1,"W","O")'>I7<OPTION value='=IF($B7<J$1,"W","O")'>J7<OPTION value='=IF($B7<K$1,"W","O")'>K7<OPTION value='=IF($B7<L$1,"W","O")'>L7<OPTION value='=IF($B7<M$1,"W","O")'>M7<OPTION value='=IF($B7<N$1,"W","O")'>N7<OPTION value='=IF($B7<O$1,"W","O")'>O7<OPTION value='=IF($B7<P$1,"W","O")'>P7<OPTION value='=IF($B7<Q$1,"W","O")'>Q7<OPTION value='=IF($B7<R$1,"W","O")'>R7<OPTION value='=IF($B7<S$1,"W","O")'>S7<OPTION value='=IF($B7<T$1,"W","O")'>T7<OPTION value='=IF($B7<U$1,"W","O")'>U7<OPTION value='=IF($B7<V$1,"W","O")'>V7<OPTION value='=IF($B7<W$1,"W","O")'>W7<OPTION value='=IF($B7<X$1,"W","O")'>X7<OPTION value='=IF(B7>0,C7-B7,"")-Y7'>Z7<OPTION value==Z7*5>AA7<OPTION value='=IF($B8<D$1,"W","O")'>D8<OPTION value='=IF($B8<E$1,"W","O")'>E8<OPTION value='=IF($B8<F$1,"W","O")'>F8<OPTION value='=IF($B8<G$1,"W","O")'>G8<OPTION value='=IF($B8<H$1,"W","O")'>H8<OPTION value='=IF($B8<I$1,"W","O")'>I8<OPTION value='=IF($B8<J$1,"W","O")'>J8<OPTION value='=IF($B8<K$1,"W","O")'>K8<OPTION value='=IF($B8<L$1,"W","O")'>L8<OPTION value='=IF($B8<M$1,"W","O")'>M8<OPTION value='=IF($B8<N$1,"W","O")'>N8<OPTION value='=IF($B8<O$1,"W","O")'>O8<OPTION value='=IF($B8<P$1,"W","O")'>P8<OPTION value='=IF($B8<Q$1,"W","O")'>Q8<OPTION value='=IF($B8<R$1,"W","O")'>R8<OPTION value='=IF($B8<S$1,"W","O")'>S8<OPTION value='=IF($B8<T$1,"W","O")'>T8<OPTION value='=IF($B8<U$1,"W","O")'>U8<OPTION value='=IF($B8<V$1,"W","O")'>V8<OPTION value='=IF($B8<W$1,"W","O")'>W8<OPTION value='=IF($B8<X$1,"W","O")'>X8<OPTION value='=IF(B8>0,C8-B8,"")-Y8'>Z8<OPTION value==Z8*5>AA8<OPTION value='=IF($B9<D$1,"W","O")'>D9<OPTION value='=IF($B9<E$1,"W","O")'>E9<OPTION value='=IF($B9<F$1,"W","O")'>F9<OPTION value='=IF($B9<G$1,"W","O")'>G9<OPTION value='=IF($B9<H$1,"W","O")'>H9<OPTION value='=IF($B9<I$1,"W","O")'>I9<OPTION value='=IF($B9<J$1,"W","O")'>J9<OPTION value='=IF($B9<K$1,"W","O")'>K9<OPTION value='=IF($B9<L$1,"W","O")'>L9<OPTION value='=IF($B9<M$1,"W","O")'>M9<OPTION value='=IF($B9<N$1,"W","O")'>N9<OPTION value='=IF($B9<O$1,"W","O")'>O9<OPTION value='=IF($B9<P$1,"W","O")'>P9<OPTION value='=IF($B9<Q$1,"W","O")'>Q9<OPTION value='=IF($B9<R$1,"W","O")'>R9<OPTION value='=IF($B9<S$1,"W","O")'>S9<OPTION value='=IF($B9<T$1,"W","O")'>T9<OPTION value='=IF($B9<U$1,"W","O")'>U9<OPTION value='=IF($B9<V$1,"W","O")'>V9<OPTION value='=IF($B9<W$1,"W","O")'>W9<OPTION value='=IF($B9<X$1,"W","O")'>X9<OPTION value='=IF(B9>0,C9-B9,"")-Y9'>Z9<OPTION value==Z9*5>AA9<OPTION value='=IF($B10<D$1,"W","O")'>D10<OPTION value='=IF($B10<E$1,"W","O")'>E10<OPTION value='=IF($B10<F$1,"W","O")'>F10<OPTION value='=IF($B10<G$1,"W","O")'>G10<OPTION value='=IF($B10<H$1,"W","O")'>H10<OPTION value='=IF($B10<I$1,"W","O")'>I10<OPTION value='=IF($B10<J$1,"W","O")'>J10<OPTION value='=IF($B10<K$1,"W","O")'>K10<OPTION value='=IF($B10<L$1,"W","O")'>L10<OPTION value='=IF($B10<M$1,"W","O")'>M10<OPTION value='=IF($B10<N$1,"W","O")'>N10<OPTION value='=IF($B10<O$1,"W","O")'>O10<OPTION value='=IF($B10<P$1,"W","O")'>P10<OPTION value='=IF($B10<Q$1,"W","O")'>Q10<OPTION value='=IF($B10<R$1,"W","O")'>R10<OPTION value='=IF($B10<S$1,"W","O")'>S10<OPTION value='=IF($B10<T$1,"W","O")'>T10<OPTION value='=IF($B10<U$1,"W","O")'>U10<OPTION value='=IF($B10<V$1,"W","O")'>V10<OPTION value='=IF($B10<W$1,"W","O")'>W10<OPTION value='=IF($B10<X$1,"W","O")'>X10<OPTION value='=IF(B10>0,C10-B10,"")-Y10'>Z10<OPTION value==Z10*5>AA10<OPTION value='=IF($B11<D$1,"W","O")'>D11<OPTION value='=IF($B11<E$1,"W","O")'>E11<OPTION value='=IF($B11<F$1,"W","O")'>F11<OPTION value='=IF($B11<G$1,"W","O")'>G11<OPTION value='=IF($B11<H$1,"W","O")'>H11<OPTION value='=IF($B11<I$1,"W","O")'>I11<OPTION value='=IF($B11<J$1,"W","O")'>J11<OPTION value='=IF($B11<K$1,"W","O")'>K11<OPTION value='=IF($B11<L$1,"W","O")'>L11<OPTION value='=IF($B11<M$1,"W","O")'>M11<OPTION value='=IF($B11<N$1,"W","O")'>N11<OPTION value='=IF($B11<O$1,"W","O")'>O11<OPTION value='=IF($B11<P$1,"W","O")'>P11<OPTION value='=IF($B11<Q$1,"W","O")'>Q11<OPTION value='=IF($B11<R$1,"W","O")'>R11<OPTION value='=IF($B11<S$1,"W","O")'>S11<OPTION value='=IF($B11<T$1,"W","O")'>T11<OPTION value='=IF($B11<U$1,"W","O")'>U11<OPTION value='=IF($B11<V$1,"W","O")'>V11<OPTION value='=IF($B11<W$1,"W","O")'>W11<OPTION value='=IF($B11<X$1,"W","O")'>X11<OPTION value='=IF(B11>0,C11-B11,"")-Y11'>Z11<OPTION value==Z11*5>AA11<OPTION value='=IF($B12<D$1,"W","O")'>D12<OPTION value='=IF($B12<E$1,"W","O")'>E12<OPTION value='=IF($B12<F$1,"W","O")'>F12<OPTION value='=IF($B12<G$1,"W","O")'>G12<OPTION value='=IF($B12<H$1,"W","O")'>H12<OPTION value='=IF($B12<I$1,"W","O")'>I12<OPTION value='=IF($B12<J$1,"W","O")'>J12<OPTION value='=IF($B12<K$1,"W","O")'>K12<OPTION value='=IF($B12<L$1,"W","O")'>L12<OPTION value='=IF($B12<M$1,"W","O")'>M12<OPTION value='=IF($B12<N$1,"W","O")'>N12<OPTION value='=IF($B12<O$1,"W","O")'>O12<OPTION value='=IF($B12<P$1,"W","O")'>P12<OPTION value='=IF($B12<Q$1,"W","O")'>Q12<OPTION value='=IF($B12<R$1,"W","O")'>R12<OPTION value='=IF($B12<S$1,"W","O")'>S12<OPTION value='=IF($B12<T$1,"W","O")'>T12<OPTION value='=IF($B12<U$1,"W","O")'>U12<OPTION value='=IF($B12<V$1,"W","O")'>V12<OPTION value='=IF($B12<W$1,"W","O")'>W12<OPTION value='=IF($B12<X$1,"W","O")'>X12<OPTION value='=IF(B12>0,C12-B12,"")-Y12'>Z12<OPTION value==Z12*5>AA12<OPTION value='=IF($B13<D$1,"W","O")'>D13<OPTION value='=IF($B13<E$1,"W","O")'>E13<OPTION value='=IF($B13<F$1,"W","O")'>F13<OPTION value='=IF($B13<G$1,"W","O")'>G13<OPTION value='=IF($B13<H$1,"W","O")'>H13<OPTION value='=IF($B13<I$1,"W","O")'>I13<OPTION value='=IF($B13<J$1,"W","O")'>J13<OPTION value='=IF($B13<K$1,"W","O")'>K13<OPTION value='=IF($B13<L$1,"W","O")'>L13<OPTION value='=IF($B13<M$1,"W","O")'>M13<OPTION value='=IF($B13<N$1,"W","O")'>N13<OPTION value='=IF($B13<O$1,"W","O")'>O13<OPTION value='=IF($B13<P$1,"W","O")'>P13<OPTION value='=IF($B13<Q$1,"W","O")'>Q13<OPTION value='=IF($B13<R$1,"W","O")'>R13<OPTION value='=IF($B13<S$1,"W","O")'>S13<OPTION value='=IF($B13<T$1,"W","O")'>T13<OPTION value='=IF($B13<U$1,"W","O")'>U13<OPTION value='=IF($B13<V$1,"W","O")'>V13<OPTION value='=IF($B13<W$1,"W","O")'>W13<OPTION value='=IF($B13<X$1,"W","O")'>X13<OPTION value='=IF(B13>0,C13-B13,"")-Y13'>Z13<OPTION value==Z13*5>AA13<OPTION value='=IF($B14<D$1,"W","O")'>D14<OPTION value='=IF($B14<E$1,"W","O")'>E14<OPTION value='=IF($B14<F$1,"W","O")'>F14<OPTION value='=IF($B14<G$1,"W","O")'>G14<OPTION value='=IF($B14<H$1,"W","O")'>H14<OPTION value='=IF($B14<I$1,"W","O")'>I14<OPTION value='=IF($B14<J$1,"W","O")'>J14<OPTION value='=IF($B14<K$1,"W","O")'>K14<OPTION value='=IF($B14<L$1,"W","O")'>L14<OPTION value='=IF($B14<M$1,"W","O")'>M14<OPTION value='=IF($B14<N$1,"W","O")'>N14<OPTION value='=IF($B14<O$1,"W","O")'>O14<OPTION value='=IF($B14<P$1,"W","O")'>P14<OPTION value='=IF($B14<Q$1,"W","O")'>Q14<OPTION value='=IF($B14<R$1,"W","O")'>R14<OPTION value='=IF($B14<S$1,"W","O")'>S14<OPTION value='=IF($B14<T$1,"W","O")'>T14<OPTION value='=IF($B14<U$1,"W","O")'>U14<OPTION value='=IF($B14<V$1,"W","O")'>V14<OPTION value='=IF($B14<W$1,"W","O")'>W14<OPTION value='=IF($B14<X$1,"W","O")'>X14<OPTION value='=IF(B14>0,C14-B14,"")-Y14'>Z14<OPTION value==Z14*5>AA14<OPTION value='=IF($B15<D$1,"W","O")'>D15<OPTION value='=IF($B15<E$1,"W","O")'>E15<OPTION value='=IF($B15<F$1,"W","O")'>F15<OPTION value='=IF($B15<G$1,"W","O")'>G15<OPTION value='=IF($B15<H$1,"W","O")'>H15<OPTION value='=IF($B15<I$1,"W","O")'>I15<OPTION value='=IF($B15<J$1,"W","O")'>J15<OPTION value='=IF($B15<K$1,"W","O")'>K15<OPTION value='=IF($B15<L$1,"W","O")'>L15<OPTION value='=IF($B15<M$1,"W","O")'>M15<OPTION value='=IF($B15<N$1,"W","O")'>N15<OPTION value='=IF($B15<O$1,"W","O")'>O15<OPTION value='=IF($B15<P$1,"W","O")'>P15<OPTION value='=IF($B15<Q$1,"W","O")'>Q15<OPTION value='=IF($B15<R$1,"W","O")'>R15<OPTION value='=IF($B15<S$1,"W","O")'>S15<OPTION value='=IF($B15<T$1,"W","O")'>T15<OPTION value='=IF($B15<U$1,"W","O")'>U15<OPTION value='=IF($B15<V$1,"W","O")'>V15<OPTION value='=IF($B15<W$1,"W","O")'>W15<OPTION value='=IF($B15<X$1,"W","O")'>X15<OPTION value='=IF(B15>0,C15-B15,"")-Y15'>Z15<OPTION value==Z15*5>AA15<OPTION value='=IF(B16<$D$1,"W","O")'>D16<OPTION value='=COUNTIF(F2:F3,"W")'>E16<OPTION value='=COUNTIF(G2:G3,"W")'>F16<OPTION value='=COUNTIF(H2:H3,"W")'>G16<OPTION value='=COUNTIF(I2:I3,"W")'>H16<OPTION value='=COUNTIF(J2:J3,"W")'>I16<OPTION value='=COUNTIF(K2:K3,"W")'>J16<OPTION value='=COUNTIF(L2:L3,"W")'>K16<OPTION value='=COUNTIF(M2:M3,"W")'>L16<OPTION value='=COUNTIF(N2:N3,"W")'>M16<OPTION value='=COUNTIF(O2:O3,"W")'>N16<OPTION value='=COUNTIF(P2:P3,"W")'>O16<OPTION value='=COUNTIF(Q2:Q3,"W")'>P16<OPTION value='=COUNTIF(R2:R3,"W")'>Q16<OPTION value='=COUNTIF(S2:S3,"W")'>R16</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value='=IF($B2<D$1,"W","O")' name=txbFb426622></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%">
</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>A</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>B</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>C</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>D</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>E</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>F</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>G</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>H</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>I</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>J</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>K</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>L</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>M</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>N</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>O</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>P</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>Q</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>R</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>S</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>T</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>U</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>V</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>W</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>X</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>Y</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>Z</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>AA</CENTER></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>1</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Start</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">End</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">15:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">16:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">17:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">18:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">19:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">20:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">21:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">22:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">23:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">00:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">01:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">02:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">03:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">04:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">05:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">06:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">06:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">07:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">08:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">09:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">10:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Break</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Total</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Weekly</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>2</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">employee 1</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">17:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">8:00</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">40:00</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>3</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">employee 2</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">21:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">6:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">8:00</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">40:00</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>4</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">employee 3</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">20:30</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">5:30</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">1:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">8:00</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">40:00</FONT></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>5</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-WEIGHT: bold; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">employee 4</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">17:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">2:00</TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">O</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">W</FONT></TD><TD style="BORDER-RIGHT: #ff0000 2pt solid; FONT-SIZE: 8pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formF
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,213,536
Messages
6,114,205
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top