Referencing start and finish timings in a table

jo54321

New Member
Joined
Nov 27, 2008
Messages
37
Can anyone help please? :confused:
I have a spreadsheet of a shift table set out at 15 minute intervals, it records how many staff are required at any time of the day.
Each shift is individual to its own start and finish time and some contain mid shift breaks.
I can manually check and record the start and finish times but this is time consuming can anyone help with possible formulae / functions that will:

1. Automatically record the start time and finish times at the end of each row.
2. Automatically record any shift breaks start and finish times at the end of the row. (Beaks are 0's)
3. Automatically record the length of each shift. (not including breaks) in hours and minutes preferabley as quarters of a 100 (5.25) than quarters of a minute (5.15)

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} </style> <![endif]--> <table class="MsoNormalTable" style="width:414.15pt;margin-left:4.65pt;border-collapse:collapse;mso-yfti-tbllook: 1184;mso-padding-alt:0cm 5.4pt 0cm 5.4pt" border="0" cellpadding="0" cellspacing="0" width="552"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:11.3pt"> <td style="width:32.2pt;border:solid windowtext 1.0pt;mso-border-alt: solid windowtext .5pt;background:#BFBFBF;mso-background-themecolor:background1; mso-background-themeshade:191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" width="43">
[FONT=&quot]1[/FONT]
</td> <td style="width:32.95pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;background:#BFBFBF;mso-background-themecolor:background1; mso-background-themeshade:191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" nowrap="nowrap" width="44">
[FONT=&quot]A[/FONT]
</td> <td style="width:33.75pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;background:#BFBFBF;mso-background-themecolor:background1; mso-background-themeshade:191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" nowrap="nowrap" width="45">
[FONT=&quot]B[/FONT]
</td> <td style="width:33.75pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;background:#BFBFBF;mso-background-themecolor:background1; mso-background-themeshade:191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" nowrap="nowrap" width="45">
[FONT=&quot]C[/FONT]
</td> <td style="width:33.75pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;background:#BFBFBF;mso-background-themecolor:background1; mso-background-themeshade:191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" nowrap="nowrap" width="45">
[FONT=&quot]D[/FONT]
</td> <td style="width:33.75pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;background:#BFBFBF;mso-background-themecolor:background1; mso-background-themeshade:191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" nowrap="nowrap" width="45">
[FONT=&quot]E[/FONT]
</td> <td style="width:33.75pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;background:#BFBFBF;mso-background-themecolor:background1; mso-background-themeshade:191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" nowrap="nowrap" width="45">
[FONT=&quot]F[/FONT]
</td> <td style="width:36.05pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" width="48">
[FONT=&quot]G[/FONT]
</td> <td style="width:36.05pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" width="48">
[FONT=&quot]H[/FONT]
</td> <td style="width:36.05pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" width="48">
[FONT=&quot]I[/FONT]
</td> <td style="width:36.05pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" width="48">
[FONT=&quot]J[/FONT]
</td> <td style="width:36.05pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;background:#BFBFBF;mso-background-themecolor:background1; mso-background-themeshade:191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" valign="top" width="48">
[FONT=&quot]k[/FONT]
</td> </tr> <tr style="mso-yfti-irow:1;height:11.3pt"> <td style="width:32.2pt;border:solid windowtext 1.0pt;border-top: none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" width="43">
[FONT=&quot]2[/FONT]
</td> <td style="width:32.95pt;border:none;mso-border-top-alt:solid windowtext .5pt; mso-border-left-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt; height:11.3pt" nowrap="nowrap" width="44">
[FONT=&quot]Time[/FONT]
</td> <td rowspan="2" style="width:33.75pt;border-top:none; border-left:solid windowtext 1.0pt;border-bottom:none;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt; mso-border-left-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FFFFCC;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" nowrap="nowrap" width="45">
[FONT=&quot]06:45[/FONT]
</td> <td rowspan="2" style="width:33.75pt;border:none;border-right: solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-top-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: #FFFFCC;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" nowrap="nowrap" width="45">
[FONT=&quot]07:00[/FONT]
</td> <td rowspan="2" style="width:33.75pt;border:none;border-right: solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-top-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: #FFFFCC;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" nowrap="nowrap" width="45">
[FONT=&quot]07:15[/FONT]
</td> <td rowspan="2" style="width:33.75pt;border:none;border-right: solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-top-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: #FFFFCC;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" nowrap="nowrap" width="45">
[FONT=&quot]07:30[/FONT]
</td> <td rowspan="2" style="width:33.75pt;border:none;border-right: solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;background: #FFFFCC;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" nowrap="nowrap" width="45">
[FONT=&quot]07:45[/FONT]
</td> <td colspan="2" style="width:72.1pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" width="96">
[FONT=&quot]Shift[/FONT]
</td> <td colspan="2" style="width:72.1pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" width="96">
[FONT=&quot]Break[/FONT]
</td> <td rowspan="2" style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FFC000;padding:0cm 5.4pt 0cm 5.4pt;height:11.3pt" width="48">
[FONT=&quot]Shift[/FONT]
[FONT=&quot]Length[/FONT]
</td> </tr> <tr style="mso-yfti-irow:2;height:11.5pt"> <td style="width:32.2pt;border:solid windowtext 1.0pt;border-top: none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:11.5pt" width="43">
[FONT=&quot]3[/FONT]
</td> <td style="width:32.95pt;border:none;mso-border-left-alt: solid windowtext .5pt;background:#FABF8F;mso-background-themecolor:accent6; mso-background-themetint:153;padding:0cm 5.4pt 0cm 5.4pt;height:11.5pt" nowrap="nowrap" width="44">
[FONT=&quot]Shift[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:11.5pt" width="48">
[FONT=&quot]Start[/FONT]
</td> <td style="width:36.05pt;border:solid windowtext 1.0pt;border-left: none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext 1.0pt;background:yellow;padding:0cm 5.4pt 0cm 5.4pt; height:11.5pt" width="48">
[FONT=&quot]Finish[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:11.5pt" width="48">
[FONT=&quot]Start[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:11.5pt" width="48">
[FONT=&quot]Finish[/FONT]
</td> </tr> <tr style="mso-yfti-irow:3;height:18.75pt"> <td style="width:32.2pt;border:solid windowtext 1.0pt;border-top: none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="43">
[FONT=&quot]4[/FONT]
</td> <td style="width:32.95pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-top-alt: 1.0pt;mso-border-left-alt:.5pt;mso-border-bottom-alt:.5pt;mso-border-right-alt: 1.0pt;mso-border-color-alt:windowtext;mso-border-style-alt:solid;background: #FABF8F;mso-background-themecolor:accent6;mso-background-themetint:153; padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="44">
[FONT=&quot]A[/FONT]
</td> <td style="width:33.75pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-top-alt: 1.0pt;mso-border-left-alt:.5pt;mso-border-bottom-alt:.5pt;mso-border-right-alt: 1.0pt;mso-border-color-alt:windowtext;mso-border-style-alt:solid;background: #F79646;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]1[/FONT]
</td> <td style="width:33.75pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: #F79646;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]1[/FONT]
</td> <td style="width:33.75pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: #F79646;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]1[/FONT]
</td> <td style="width:33.75pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: #F79646;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]1[/FONT]
</td> <td style="width:33.75pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt;background: #F79646;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]06:45[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]07:45[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FFC000;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="48">
[FONT=&quot]1.00[/FONT]
</td> </tr> <tr style="mso-yfti-irow:4;height:18.75pt"> <td style="width:32.2pt;border:solid windowtext 1.0pt;border-top: none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="43">
[FONT=&quot]5[/FONT]
</td> <td style="width:32.95pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FABF8F;mso-background-themecolor:accent6;mso-background-themetint: 153;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="44">
[FONT=&quot]B[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#4BACC6;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]1[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#4BACC6;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]1[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#4BACC6;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#4BACC6;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#4BACC6;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]1[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]06:45[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]08:00[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]07:15[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]07:45[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FFC000;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="48">
[FONT=&quot]0.75[/FONT]
</td> </tr> <tr style="mso-yfti-irow:5;height:18.75pt"> <td style="width:32.2pt;border:solid windowtext 1.0pt;border-top: none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="43">
[FONT=&quot]6[/FONT]
</td> <td style="width:32.95pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FABF8F;mso-background-themecolor:accent6;mso-background-themetint: 153;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="44">
[FONT=&quot]C[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#8064A2;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#8064A2;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#8064A2;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#8064A2;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#8064A2;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FFC000;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="48">
[FONT=&quot] [/FONT]
</td> </tr> <tr style="mso-yfti-irow:6;height:18.75pt"> <td style="width:32.2pt;border:solid windowtext 1.0pt;border-top: none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="43">
[FONT=&quot]7[/FONT]
</td> <td style="width:32.95pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FABF8F;mso-background-themecolor:accent6;mso-background-themetint: 153;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="44">
[FONT=&quot]D[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#B2A1C7;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]1[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#B2A1C7;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]1[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#B2A1C7;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#B2A1C7;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]1[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#B2A1C7;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]1[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]06:45[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]07:45[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]07:15[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]07:30[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FFC000;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="48">
[FONT=&quot]1.00[/FONT]
</td> </tr> <tr style="mso-yfti-irow:7;height:18.75pt"> <td style="width:32.2pt;border:solid windowtext 1.0pt;border-top: none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="43">
[FONT=&quot]8[/FONT]
</td> <td style="width:32.95pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FABF8F;mso-background-themecolor:accent6;mso-background-themetint: 153;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="44">
[FONT=&quot]E[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#C2D69A;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#C2D69A;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#C2D69A;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#C2D69A;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#C2D69A;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FFC000;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="48">
[FONT=&quot] [/FONT]
</td> </tr> <tr style="mso-yfti-irow:8;height:18.75pt"> <td style="width:32.2pt;border:solid windowtext 1.0pt;border-top: none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="43">
[FONT=&quot]9[/FONT]
</td> <td style="width:32.95pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FABF8F;mso-background-themecolor:accent6;mso-background-themetint: 153;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="44">
[FONT=&quot]F[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#D99795;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#D99795;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]2[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#D99795;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]2[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#D99795;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]2[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#D99795;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="45">
[FONT=&quot]2[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]07:00[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
[FONT=&quot]08:00[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FFC000;padding:0cm 5.4pt 0cm 5.4pt;height:18.75pt" width="48">
[FONT=&quot]1.00[/FONT]
</td> </tr> <tr style="mso-yfti-irow:9;mso-yfti-lastrow:yes;height:19.5pt"> <td style="width:32.2pt;border:solid windowtext 1.0pt;border-top: none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade: 191;padding:0cm 5.4pt 0cm 5.4pt;height:19.5pt" width="43">
[FONT=&quot]10[/FONT]
</td> <td style="width:32.95pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;background:#FABF8F;mso-background-themecolor: accent6;mso-background-themetint:153;padding:0cm 5.4pt 0cm 5.4pt;height:19.5pt" nowrap="nowrap" width="44">
[FONT=&quot]G[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt; height:19.5pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;height:19.5pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;height:19.5pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;height:19.5pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:33.75pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;height:19.5pt" nowrap="nowrap" width="45">
[FONT=&quot]0[/FONT]
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:19.5pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:yellow;padding:0cm 5.4pt 0cm 5.4pt;height:19.5pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:19.5pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#FBD4B4;mso-background-themecolor:accent6;mso-background-themetint: 102;padding:0cm 5.4pt 0cm 5.4pt;height:19.5pt" nowrap="nowrap" width="48">
</td> <td style="width:36.05pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#FFC000;padding:0cm 5.4pt 0cm 5.4pt;height:19.5pt" width="48">
[FONT=&quot] [/FONT]
</td> </tr> </tbody></table>




<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} </style> <![endif]-->
 

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.
Is the shift going to be for 1 h only?
Woudl that be only one break per shift/hour?
What "1" and "2" mean?
There is a 0 in row 9 why this is not counted as a break?
 
Upvote 0
sorry if i've not made it clear,
The table was only a little section of the spreadsheet as an example, it is linked to another sheet that has profiled tasks.
this could be a group of 30 people, but not all 30 are required at the same time.
Each row is a different shift that could be upto 12 hours long, and may contain upto 3 breaks depending on the shift length.
the time scale is 06:00 to 21:00 per day

The numbers relate to how many people are required on each shift at that given time, for example 1 person is on the A shift 2 people are on the F shift.
the 0 relates to no staff or work for that shift at the given time.
(it doesn't have to be a 0 it could be a letter if required)

If you have 2 2 2 2 0 0 0 0 2 2 the 0 would represent the break in that shift,
If you have all 0's nobody is on ththat shift.

I am basically after a way of automatically recording the time a shift starts.
In cell G8 start time 0700 is found by referencing where the 0 ends and the 2 starts in row 8 with the time in the relevant cell in row 1.
The same for the finish time where numbers end and 0 begins
 
Upvote 0
To find the start shift(I have extedent the range up to column AF

=IF(ISNUMBER(INDEX($B$2:$AF$2,MATCH(1,INDEX(ISNUMBER($B4:$AF4)*($B4:$AF4>0),0),0))),INDEX($B$2:$AF$2,MATCH(1,INDEX(ISNUMBER($B4:$AF4)*($B4:$AF4>0),0),0)),"")

to find the end if the shift:
I'm confused as row A and D says 7:45 despite 0 for row A.

I'm working on the breaks- but can you call the cells B1, B2 and B3?
 
Upvote 0
sorry, finishing time is my error, shift D should end at 0800 as with B & F.
you can call the breaks whatever helps
Thanx for yourr help so far.
J
 
Upvote 0
My shift finish is at 14.00
You need to add column "peple on shift" (column C):

54067619.jpg


Formulas:
(array ,confirm CTRL+SHIFT+ENTER)
AH4:=IF(ISNUMBER(INDEX($D$2:$AG$2,MATCH(1,INDEX(ISNUMBER($D4:$AG4)*($D4:$AG4>0),0),0))),INDEX($D$2:$AG$2,MATCH(1,INDEX(ISNUMBER($D4:$AI4)*($D4:$AG4>0),0),0)),"")

copy down

(Array)
AI4:
=IF(C4=0,"",INDEX($D$2:AG4,1,MAX(IF(D4:AG4=$C4,COLUMN(A4:AD4)))+1))
copy down

AJ4:=IF(C4=0,"",IF(COUNTIF(E4:AH4,AJ$2)=0,"",INDEX($D$2:AG4,1,MIN(IF(D4:AG4=AJ$2,COLUMN(A4:AD4))))))
AK4:=IF(D4=0,"",IF(COUNTIF(E4:AH4,AK$2)=0,"",INDEX($D$2:AH4,1,MAX(IF(E4:AH4=AK$2,COLUMN(B4:AE4)))+1)))
AL4:=IF(E4=0,"",IF(COUNTIF(G4:AJ4,AL$2)=0,"",INDEX($D$2:AI4,1,MIN(IF(F4:AI4=AL$2,COLUMN(C4:AF4))))))
AM4:=IF(F4=0,"",IF(COUNTIF(G4:AJ4,AM$2)=0,"",INDEX($D$2:AJ4,1,MAX(IF(G4:AJ4=AM$2,COLUMN(D4:AG4)))+1)))
AN4:=IF(G4=0,"",IF(COUNTIF(I4:AL4,AN$2)=0,"",INDEX($D$2:AK4,1,MIN(IF(H4:AK4=AN$2,COLUMN(E4:AH4))))))
AO4:=IF(H4=0,"",IF(COUNTIF(I4:AL4,AO$2)=0,"",INDEX($D$2:AL4,1,MAX(IF(I4:AL4=AO$2,COLUMN(F4:AI4)))+1)))

Copy all down.
The lastbit is to recalcualte the shift lenght but this is very simple so I leave that for you.
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,289
Members
452,902
Latest member
Knuddeluff

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