Daily task - tracking totals

[tsxlee]

Hello,



I have a daily calendar that I use to help me keep track of my daily tasks at work. What I would like to do is create a macro that will calculate the amount of time spent on each task over the course of the week.


For example, on day 1 Task A can be found on B4 and C4 indicates 2 hours spent, then on B28 and C28 indicates another 2 hours.. Equaling 4 total hours.
On Day 2, it's found on F11 and G11 indicates 0.25, then on F22 and G22 indicates 2 hours.. Equaling 2.25 hours


I'd like the Task A total of Day 1 and Day 2 (4+2.5=6.5) to appear under the heading Total Hours in column B40.


Any ideas on how I can get this started<!--[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-CA</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:0cm; mso-para-margin-bottom:.0001pt; 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]-->[FONT=&quot]?[/FONT]

<table border="0" cellpadding="0" cellspacing="0" width="460"><col style="mso-width-source:userset;mso-width-alt:2267;width:47pt" width="62"> <col style="mso-width-source:userset;mso-width-alt:3254;width:67pt" width="89"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1097;width:23pt" width="30"> <col style="mso-width-source:userset;mso-width-alt:2267;width:47pt" width="62"> <col style="mso-width-source:userset;mso-width-alt:3254;width:67pt" width="89"> <col style="width:48pt" width="64"> <tbody><tr style="height:15.75pt" height="21"> <td colspan="2" class="xl74" style="height:15.75pt; width:114pt" height="21" width="151">Daily Calendar</td> <td class="xl63" style="width:48pt" width="64">Day 1</td> <td class="xl70" style="width:23pt" width="30">
</td> <td colspan="2" class="xl74" style="width:114pt" width="151">Daily Calendar</td> <td class="xl63" style="width:48pt" width="64">Day 2</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl64" style="height:14.25pt" height="19">Time</td> <td class="xl64">Appointment</td> <td class="xl66">Hours</td> <td class="xl71">
</td> <td class="xl64">Time</td> <td class="xl64">Appointment</td> <td class="xl66">Hours</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">8:00am</td> <td>Task A</td> <td class="xl67">2</td> <td class="xl67">
</td> <td>8:00am</td> <td>Task B</td> <td class="xl67">1.75</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">8:15am</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">8:15am</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">8:30am</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>8:30am</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">8:45am</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">8:45am</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">9:00am</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>9:00am</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">9:15am</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">9:15am</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">9:30am</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>9:30am</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">9:45am</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">9:45am</td> <td class="xl65">Task A</td> <td class="xl68">0.25</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">10:00am</td> <td>Task B</td> <td class="xl67">2</td> <td class="xl67">
</td> <td>10:00am</td> <td>Task B</td> <td class="xl67">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">10:15am</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">10:15am</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">10:30am</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>10:30am</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">10:45am</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">10:45am</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">11:00am</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>11:00am</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">11:15am</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">11:15am</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">11:30am</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>11:30am</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">11:45am</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">11:45am</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">12:00pm</td> <td>Lunch</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>12:00pm</td> <td>Lunch</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">12:15pm</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">12:15pm</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">12:30pm</td> <td>Task A</td> <td class="xl67">1.5</td> <td class="xl67">
</td> <td>12:30pm</td> <td>Task A</td> <td class="xl67">2</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">12:45pm</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">12:45pm</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1:00pm</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>1:00pm</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">1:15pm</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">1:15pm</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">1:30pm</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>1:30pm</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">1:45pm</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">1:45pm</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">2:00pm</td> <td>Task B</td> <td class="xl67">2</td> <td class="xl67">
</td> <td>2:00pm</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">2:15pm</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">2:15pm</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">2:30pm</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>2:30pm</td> <td>Task B</td> <td class="xl67">1.5</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">2:45pm</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">2:45pm</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">3:00pm</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>3:00pm</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">3:15pm</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">3:15pm</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">3:30pm</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>3:30pm</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">3:45pm</td> <td class="xl65"> </td> <td class="xl68"> </td> <td class="xl67">
</td> <td class="xl65">3:45pm</td> <td class="xl65"> </td> <td class="xl68"> </td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">4:00pm</td> <td>
</td> <td class="xl67">
</td> <td class="xl67">
</td> <td>4:00pm</td> <td>
</td> <td class="xl67">
</td> </tr> <tr style="height:13.5pt" height="18"> <td style="height:13.5pt" height="18">
</td> <td class="xl72">Total</td> <td class="xl73">7.5</td> <td class="xl67">
</td> <td>
</td> <td class="xl72">Total</td> <td class="xl73">7.5</td> </tr> <tr style="height:13.5pt" height="18"> <td style="height:13.5pt" height="18">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">
</td> <td class="xl69">Total Hours</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Task A</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" height="17">Task B</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> </tbody></table>



-- removed inline image ---