Automatic finish date & time with lunch break and bank holidays

D

deckerp

Active Member
Joined
Feb 12, 2010
Messages
319
Office Version
  1. 365
Hi,
I would like a solution for the automatic calculation of the end date and end time for project tasks. I have already spent hours on the issue, thanks for any help on this.


The parameters are:
A1 = Start time 08:00
B1 = End Time 17:00
A2 = break lunch 12:00
B2 = back from lunch 13:00

Task parameters

A5 = start date 01/03/10 (entered manually)
B5 = start time 10:00 (entered manually)
C5 = duration 02:00 (hrs entered manually)
D5 = "end date" >>> (to be calculated exluding breaks and holidays)
E5 = "end time" >>> (to be calculated exluding breaks and holidays)


the next line should be filled in automaitically according to the hours needed and the previous end date & time

A6 = "start date" >>> (after line 5: to be calculated exluding breaks and holidays)
B6 = "start time" (after line 5: to be calculated exluding breaks and holidays)
C6 = duration 14:00 (entered manually)
D6 = "end date" >>> (to be calculated exluding breaks and holidays)
E6 = "end time" >>> (to be calculated exluding breaks and holidays)

and so on for every new line down.
 
Last edited:
Sort by date Sort by votes
The first start date is put in manually.
The next start date one should be after the predecent task(s) are finished.
The same happens to the start time.
the duration is set manually for every task.


Akashwani said:
What are the dates of your Bank Holidays?
Are you working weekends?

In this example,
What would define the next Start Date?
What would define the Start Time?
What would define the Duration?



<table style="width: 343pt; border-collapse: collapse;" width="458" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width: 24pt;" width="32"><col style="width: 56pt;" width="75" span="2"><col style="width: 52pt;" width="69"><col style="width: 83pt;" width="111"><col style="width: 51pt;" width="68"><col style="width: 21pt;" width="28"></colgroup><tbody><tr style="height: 15.75pt;" height="21"><td style="border-style: solid none none solid; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: 1pt medium medium 1pt; background-color: transparent; width: 24pt; height: 15.75pt;" class="xl148" width="32" height="21">
</td><td style="border-style: solid none none; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt medium medium; background-color: transparent; width: 56pt;" class="xl142" width="75">A</td><td style="border-style: solid none none; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt medium medium; background-color: transparent; width: 56pt;" class="xl142" width="75">B</td><td style="border-style: solid none none; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt medium medium; background-color: transparent; width: 52pt;" class="xl142" width="69">C</td><td style="border-style: solid none none; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt medium medium; background-color: transparent; width: 83pt;" class="xl142" width="111">D</td><td style="border-style: solid none none; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt medium medium; background-color: transparent; width: 51pt;" class="xl142" width="68">E</td><td style="border-style: solid solid none none; border-color: windowtext windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt 1pt medium medium; background-color: transparent; width: 21pt;" class="xl143" width="28">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl149" align="right" height="20">1</td><td style="border-style: solid none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: 1pt medium 0.5pt 1pt; background-color: transparent;" class="xl163">Start Time</td><td style="border-style: solid none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: 1pt medium 0.5pt 1pt; background-color: transparent;" class="xl163">End Time</td><td style="border-style: solid; border-color: windowtext; border-width: 1pt 1pt 0.5pt; background-color: transparent;" class="xl172">Total</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15.75pt;" height="21"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15.75pt;" class="xl149" align="right" height="21">2</td><td style="border-style: none none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: medium medium 1pt 1pt; background-color: transparent;" class="xl164" align="right">08:00</td><td style="border-style: none none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: medium medium 1pt 1pt; background-color: transparent;" id="td_post_2213573" class="xl164" align="right">17:00</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 1pt 1pt; background-color: transparent;" class="xl166" align="right">09:00</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;" class="xl162">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;" class="xl162">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl149" align="right" height="20">3</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 1pt 0.5pt; background-color: transparent;" class="xl165">Start Lunch</td><td style="border-style: none none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: medium medium 0.5pt 0.5pt; background-color: transparent;" class="xl170">End Lunch</td><td style="border-style: none solid solid; border-color: rgb(192, 192, 192) windowtext windowtext; border-width: medium 1pt 0.5pt; background-color: transparent;" class="xl153">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15.75pt;" height="21"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15.75pt;" class="xl149" align="right" height="21">4</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 1pt 1pt; background-color: transparent;" class="xl166" align="right">12:00</td><td style="border-style: none none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: medium medium 1pt 0.5pt; background-color: transparent;" class="xl171" align="right">13:00</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 1pt 1pt; background-color: transparent;" class="xl166" align="right">01:00</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15.75pt;" height="21"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15.75pt;" class="xl149" align="right" height="21">5</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl149" align="right" height="20">6</td><td style="border-style: solid; border-color: windowtext; border-width: 1pt 0.5pt 0.5pt 1pt; background-color: transparent;" class="xl151">Start Date</td><td style="border-style: solid solid solid none; border-color: windowtext; border-width: 1pt 0.5pt 0.5pt medium; background-color: transparent;" class="xl159">Start Time</td><td style="border-style: solid solid solid none; border-color: windowtext; border-width: 1pt 0.5pt 0.5pt medium; background-color: transparent;" class="xl159">Duration</td><td style="border-style: solid solid solid none; border-color: windowtext; border-width: 1pt 0.5pt 0.5pt medium; background-color: transparent;" class="xl159">End Date</td><td style="border-style: solid solid solid none; border-color: windowtext; border-width: 1pt 1pt 0.5pt medium; background-color: transparent;" class="xl152">End Time</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl149" align="right" height="20">7</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt 1pt; background-color: transparent;" class="xl167" align="right">01/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl161" align="right">10:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl169" align="right">2:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl160" align="right">01/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 1pt 0.5pt medium; background-color: transparent;" class="xl168" align="right">12:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl149" align="right" height="20">8</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt 1pt; background-color: transparent;" class="xl154">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 1pt 0.5pt medium; background-color: transparent;" class="xl155">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl149" align="right" height="20">9</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt 1pt; background-color: transparent;" class="xl154">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 1pt 0.5pt medium; background-color: transparent;" class="xl155">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl149" align="right" height="20">10</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt 1pt; background-color: transparent;" class="xl154">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 1pt 0.5pt medium; background-color: transparent;" class="xl155">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl149" align="right" height="20">11</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt 1pt; background-color: transparent;" class="xl154">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 1pt 0.5pt medium; background-color: transparent;" class="xl155">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl149" align="right" height="20">12</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt 1pt; background-color: transparent;" class="xl154">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 1pt 0.5pt medium; background-color: transparent;" class="xl155">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15.75pt;" height="21"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15.75pt;" class="xl149" align="right" height="21">13</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 1pt 1pt; background-color: transparent;" class="xl156">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 1pt medium; background-color: transparent;" class="xl157">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 1pt medium; background-color: transparent;" class="xl157">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 1pt medium; background-color: transparent;" class="xl157">
</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 1pt 1pt medium; background-color: transparent;" class="xl158">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15.75pt;" height="21"><td style="border-style: none none solid solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext windowtext; border-width: medium medium 1pt 1pt; background-color: transparent; height: 15.75pt;" class="xl150" height="21">
</td><td style="border-style: none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium 1pt; background-color: transparent;" class="xl146">
</td><td style="border-style: none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium 1pt; background-color: transparent;" class="xl146">
</td><td style="border-style: none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium 1pt; background-color: transparent;" class="xl146">
</td><td style="border-style: none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium 1pt; background-color: transparent;" class="xl146">
</td><td style="border-style: none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium 1pt; background-color: transparent;" class="xl146">
</td><td style="border-style: none solid solid none; border-color: rgb(192, 192, 192) windowtext windowtext rgb(192, 192, 192); border-width: medium 1pt 1pt medium; background-color: transparent;" class="xl147">
</td></tr></tbody></table>


Ak
Click to expand...
 
Upvote 0

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Hi,

I really don't have any idea with this :(

Is this what you would expect your table to look like?
I've manually entered this!! So I apologise if it is incorrect...

<TABLE style="WIDTH: 326pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=435><COLGROUP><COL style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1170" width=32><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" span=2 width=75><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2486" width=68><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 1024" width=28><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 24pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl147 height=21 width=32> </TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" id=td_post_2213766 class=xl142 width=75>A</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl142 width=75>B</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl142 width=69>C</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 66pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl142 width=88>D</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl142 width=68>E</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 21pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl143 width=28> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl155>Start Time</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl155>End Time</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl162>Total</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=21 align=right u1:num="40179">2</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #c0c0c0" class=xl156 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #c0c0c0" id=td_post_2213573 class=xl156 align=right>17:00</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl158 align=right>09:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl154></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl154></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR>

<TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl157>Start Lunch</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #c0c0c0" class=xl160>End Lunch</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl151> </TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=21 align=right u1:num="40270">4</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl158 align=right>12:00</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #c0c0c0" class=xl161 align=right>13:00</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl158 align=right>01:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=21 align=right u1:num="40272">5</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40273">6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl149>Start Date</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl149>Start Time</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl149>Duration</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl149>End Date</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl149>End Time</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40299">7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>01/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>10:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl163 align=right>2:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>01/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>12:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40311">8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>01/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>13:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl163 align=right>16:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>01/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40321">9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>02/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>12:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>02/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40322">10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>03/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>04:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>02/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>12:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40332">11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>03/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>13:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl164 align=right>15:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>03/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40454">12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>04/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>11:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>04/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40483">13</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>03:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>11:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40537">14</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>11:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl164 align=right>01:30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>13:30</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40538">15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>13:30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl164 align=right>04:15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40544">16</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>06/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>00:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>06/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:45</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40655">17</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>06/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl164 align=right>06:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>06/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>16:45</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40658">18</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>06/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>16:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl163 align=right>35:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>06/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40664">19</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>07/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl159 align=right>34:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>07/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40696">20</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>08/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl159 align=right>26:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>08/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40707">21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>09/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl159 align=right>18:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>09/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40717">22</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>10/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>10:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>10/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40819">23</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>11/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl159 align=right>2:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>11/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>10:45</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40848">24</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>11/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>10:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl163>?</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>11/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl164>?</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl150 height=21 u1:num="40902"> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl145> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl145> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl145> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl145> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl145> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl146> </TD></TR></TBODY></TABLE>

Hopefully if this data is correct, someone will understand it and be able to create a formula for you, I'm out of my depth here :(

Ak
 
Upvote 0
Dear Akashwani
thanks for trying.

I have included a link to the file above.
you table below shows some erros.
when the duration takes longer than the actual finish time of the day (here always 17:00) than it must be carried forward to the next working day (exluding saturdays, sundays and holidays).

Also, when one tasks finishs exactly at 17h00, the next task cannot start at 17h00 that day because it is end of working hours, thus to be carried forward to the next working day 08h00.



Akashwani said:
Hi,

I really don't have any idea with this :(

Is this what you would expect your table to look like?
I've manually entered this!! So I apologise if it is incorrect...





<table style="width: 326pt; border-collapse: collapse;" width="435" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width: 24pt;" width="32"><col style="width: 56pt;" width="75" span="2"><col style="width: 52pt;" width="69"><col style="width: 66pt;" width="88"><col style="width: 51pt;" width="68"><col style="width: 21pt;" width="28"></colgroup><tbody><tr style="height: 15.75pt;" height="21"><td style="border-style: solid none none solid; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: 1pt medium medium 1pt; background-color: transparent; width: 24pt; height: 15.75pt;" class="xl147" width="32" height="21">
</td><td style="border-style: solid none none; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt medium medium; background-color: transparent; width: 56pt;" id="td_post_2213766" class="xl142" width="75">A</td><td style="border-style: solid none none; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt medium medium; background-color: transparent; width: 56pt;" class="xl142" width="75">B</td><td style="border-style: solid none none; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt medium medium; background-color: transparent; width: 52pt;" class="xl142" width="69">C</td><td style="border-style: solid none none; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt medium medium; background-color: transparent; width: 66pt;" class="xl142" width="88">D</td><td style="border-style: solid none none; border-color: windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt medium medium; background-color: transparent; width: 51pt;" class="xl142" width="68">E</td><td style="border-style: solid solid none none; border-color: windowtext windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: 1pt 1pt medium medium; background-color: transparent; width: 21pt;" class="xl143" width="28">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" align="right" height="20">1</td><td style="border-style: solid none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: 1pt medium 0.5pt 1pt; background-color: transparent;" class="xl155">Start Time</td><td style="border-style: solid none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: 1pt medium 0.5pt 1pt; background-color: transparent;" class="xl155">End Time</td><td style="border-style: solid; border-color: windowtext; border-width: 1pt 1pt 0.5pt; background-color: transparent;" class="xl162">Total</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15.75pt;" height="21"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15.75pt;" class="xl148" u1:num="40179" align="right" height="21">2</td><td style="border-style: none none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: medium medium 1pt 1pt; background-color: transparent;" class="xl156" align="right">08:00</td><td style="border-style: none none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: medium medium 1pt 1pt; background-color: transparent;" id="td_post_2213573" class="xl156" align="right">17:00</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 1pt 1pt; background-color: transparent;" class="xl158" align="right">09:00</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;" class="xl154">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;" class="xl154">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" align="right" height="20">3</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 1pt 0.5pt; background-color: transparent;" class="xl157">Start Lunch</td><td style="border-style: none none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: medium medium 0.5pt 0.5pt; background-color: transparent;" class="xl160">End Lunch</td><td style="border-style: none solid solid; border-color: rgb(192, 192, 192) windowtext windowtext; border-width: medium 1pt 0.5pt; background-color: transparent;" class="xl151">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15.75pt;" height="21"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15.75pt;" class="xl148" u1:num="40270" align="right" height="21">4</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 1pt 1pt; background-color: transparent;" class="xl158" align="right">12:00</td><td style="border-style: none none solid solid; border-color: windowtext rgb(192, 192, 192) windowtext windowtext; border-width: medium medium 1pt 0.5pt; background-color: transparent;" class="xl161" align="right">13:00</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 1pt 1pt; background-color: transparent;" class="xl158" align="right">01:00</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15.75pt;" height="21"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15.75pt;" class="xl148" u1:num="40272" align="right" height="21">5</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border: medium none rgb(192, 192, 192); background-color: transparent;">
</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40273" align="right" height="20">6</td><td style="border: 0.5pt solid windowtext; background-color: transparent;" class="xl149">Start Date</td><td style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; background-color: transparent;" class="xl149">Start Time</td><td style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; background-color: transparent;" class="xl149">Duration</td><td style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; background-color: transparent;" class="xl149">End Date</td><td style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; background-color: transparent;" class="xl149">End Time</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40299" align="right" height="20">7</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">01/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">10:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: yellow;" class="xl163" align="right">2:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">01/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">12:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40311" align="right" height="20">8</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">01/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">13:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: yellow;" class="xl163" align="right">16:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">01/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">17:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40321" align="right" height="20">9</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">02/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">12:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">02/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">17:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40322" align="right" height="20">10</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">03/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">04:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">02/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">12:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40332" align="right" height="20">11</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">03/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">13:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: yellow;" class="xl164" align="right">15:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">03/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">17:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40454" align="right" height="20">12</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">04/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">11:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">04/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">17:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40483" align="right" height="20">13</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">05/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">03:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">05/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">11:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40537" align="right" height="20">14</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">05/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">11:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: yellow;" class="xl164" align="right">01:30</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">05/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">13:30</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40538" align="right" height="20">15</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">05/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">13:30</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: yellow;" class="xl164" align="right">04:15</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">05/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">17:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40544" align="right" height="20">16</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">06/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">00:45</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">06/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:45</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40655" align="right" height="20">17</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">06/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:45</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: yellow;" class="xl164" align="right">06:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">06/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">16:45</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40658" align="right" height="20">18</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">06/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">16:45</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: yellow;" class="xl163" align="right">35:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">06/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">17:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40664" align="right" height="20">19</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">07/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl159" align="right">34:45</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">07/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">17:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40696" align="right" height="20">20</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">08/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl159" align="right">26:45</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">08/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">17:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40707" align="right" height="20">21</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">09/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl159" align="right">18:45</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">09/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">17:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40717" align="right" height="20">22</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">10/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">10:45</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">10/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">17:00</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40819" align="right" height="20">23</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">11/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">08:00</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl159" align="right">2:45</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">11/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">10:45</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15pt;" height="20"><td style="border-style: none none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium medium 1pt; background-color: transparent; height: 15pt;" class="xl148" u1:num="40848" align="right" height="20">24</td><td style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; background-color: transparent;" class="xl152" align="right">11/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl153" align="right">10:45</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: yellow;" class="xl163">?</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;" class="xl152" align="right">11/03/2010</td><td style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: yellow;" class="xl164">?</td><td style="border-style: none solid none none; border-color: rgb(192, 192, 192) windowtext rgb(192, 192, 192) rgb(192, 192, 192); border-width: medium 1pt medium medium; background-color: transparent;" class="xl144">
</td></tr><tr style="height: 15.75pt;" height="21"><td style="border-style: none none solid solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext windowtext; border-width: medium medium 1pt 1pt; background-color: transparent; height: 15.75pt;" class="xl150" u1:num="40902" height="21">
</td><td style="border-style: none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium 1pt; background-color: transparent;" class="xl145">
</td><td style="border-style: none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium 1pt; background-color: transparent;" class="xl145">
</td><td style="border-style: none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium 1pt; background-color: transparent;" class="xl145">
</td><td style="border-style: none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium 1pt; background-color: transparent;" class="xl145">
</td><td style="border-style: none none solid; border-color: rgb(192, 192, 192) rgb(192, 192, 192) windowtext; border-width: medium medium 1pt; background-color: transparent;" class="xl145">
</td><td style="border-style: none solid solid none; border-color: rgb(192, 192, 192) windowtext windowtext rgb(192, 192, 192); border-width: medium 1pt 1pt medium; background-color: transparent;" class="xl146">
</td></tr></tbody></table>

Hopefully if this data is correct, someone will understand it and be able to create a formula for you, I'm out of my depth here :(

Ak
Click to expand...
 
Upvote 0
Is this how it should look?

If not, post a sample of what you think the result should look like...

<TABLE style="WIDTH: 326pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=435><COLGROUP><COL style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1170" width=32><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" span=2 width=75><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2486" width=68><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 1024" width=28><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 24pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl147 height=21 width=32> </TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" id=td_post_2213766 class=xl142 width=75>A</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl142 width=75>B</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl142 width=69>C</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 66pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl142 width=88>D</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl142 width=68>E</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 21pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl143 width=28> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl155>Start Time</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl155>End Time</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl162>Total</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR>

<TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=21 align=right u1:num="40179">2</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #c0c0c0" class=xl156 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #c0c0c0" id=td_post_2213573 class=xl156 align=right>17:00</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl158 align=right>09:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl154></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl154></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR>

<TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl157>Start Lunch</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #c0c0c0" class=xl160>End Lunch</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl151> </TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=21 align=right u1:num="40270">4</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl158 align=right>12:00</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: #c0c0c0" class=xl161 align=right>13:00</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl158 align=right>01:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40272">5</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0"></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40273">6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl149>Start Date</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl149>Start Time</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl149>Duration</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl149>End Date</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl149>End Time</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40299">7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>01/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>10:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl163 align=right>2:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>01/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>12:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40311">8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>01/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>13:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl163 align=right>16:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>01/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40321">9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>02/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>12:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>02/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40322">10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>03/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>04:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>02/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>12:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40332">11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>03/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>13:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl164 align=right>15:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>03/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40454">12</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>04/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>11:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>04/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40483">13</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>03:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>11:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40537">14</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>11:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl164 align=right>01:30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>13:30</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40538">15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>13:30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl164 align=right>04:15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>05/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40544">16</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>08/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>00:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>08/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:45</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40655">17</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>08/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl164 align=right>06:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>08/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>16:45</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40658">18</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>08/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>16:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl163 align=right>35:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>08/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40664">19</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>09/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl159 align=right>34:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>09/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40696">20</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>10/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl159 align=right>26:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>10/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40707">21</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>11/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl159 align=right>18:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>11/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40717">22</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>12/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>10:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>12/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>17:00</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40819">23</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>15/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>08:00</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl159 align=right>2:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>15/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>10:45</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl148 height=20 align=right u1:num="40848">24</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>15/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl153 align=right>10:45</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl163>?</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl152 align=right>15/03/2010</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl164>?</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl144> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl150 height=21 u1:num="40902"> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl145> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl145> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl145> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl145> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl145> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl146> </TD></TR></TBODY></TABLE>

Ak
 
Upvote 0
Hello deckerp,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
This is a continuation of the question you asked in this thread, I think. It's normally better to keep everything in one thread but as you didn't start that thread and you've included more detail here, I'll continue here
<o:p></o:p>
<o:p></o:p>
You can use the formulas I posted there to get the end date and time but I have updated those to cater for holidays and a break as you requested (although that makes them fairly complex as I suggested it would) and also to show next day start if the previous task ends at the end of the workday (and also to show next task starting after the break if the previous task ends at the start time of the break)
<o:p></o:p>
<o:p></o:p>
I've used the setup you suggested but additionally the range H1:H100 should contain a list of holiday dates to be excluded

<o:p></o:p>
The working day is deemed to be the length of the workday (A1 to B1) minus the break (A2 to B2). A5 should be a working day and B5 should be within the working hours. Formulas will cater for hours and minutes, not seconds

<o:p></o:p>
In D5 copied down

=WORKDAY(A5,CEILING((B5+C5-A$1-(B5>=B$2)*(B$2-A$2))/(B$1-A$1+A$2-B$2),1)-1,H$1:H$100)

In E5 copied down

=MROUND(B5+C5-(NETWORKDAYS(A5,D5,H$1:H$100)-1)*(B$1-A$1+A$2-B$2)+(B5< A$2)*(B$2-A$2)-(B5+C5-(NETWORKDAYS(A5,D5,H$1:H$100)-1)*(B$1-A$1+A$2-B$2)+(B5< A$2)*(B$2-A$2)<=B$2)*(B$2-A$2),"0:01")
<?XML:NAMESPACE PREFIX = A$2)*(B$2-A$2)-(B5+C5-(NETWORKDAYS(A5,D5,H$1 /><A$2)*(B$2-A$2)-(B5+C5-(NETWORKDAYS(A5,D5,H$1:H$100)-1)*(B$1-A$1+A$2-B$2)+(B5<A$2)*(B$2-A$2)<=B$2)*(B$2-A$2),"0:01")< font>

In A6 copied down

=WORKDAY(D5,(E5=B$1)+0,H$1:H$100)

and in B6 copied down

=IF(E5=B$1,A$1,IF(E5=A$2,B$2,E5))
</A$2)*(B$2-A$2)-(B5+C5-(NETWORKDAYS(A5,D5,H$1:H$100)-1)*(B$1-A$1+A$2-B$2)+(B5<A$2)*(B$2-A$2)<=B$2)*(B$2-A$2),"0:01")<>
 
Last edited:
Upvote 0
dear barry houdini,

i ll try your formula and let you know if I managed.
thanks so much for your kind help...

with much appreciation,
peter
 
Upvote 0
what is in C5 ?


barry houdini said:
Hello deckerp,
<o:p></o:p>
<o:p></o:p>
This is a continuation of the question you asked in this thread, I think. It's normally better to keep everything in one thread but as you didn't start that thread and you've included more detail here, I'll continue here
<o:p></o:p>
<o:p></o:p>
You can use the formulas I posted there to get the end date and time but I have updated those to cater for holidays and a break as you requested (although that makes them fairly complex as I suggested it would) and also to show next day start if the previous task ends at the end of the workday (and also to show next task starting after the break if the previous task ends at the start time of the break)
<o:p></o:p>
<o:p></o:p>
I've used the setup you suggested but additionally the range H1:H100 should contain a list of holiday dates to be excluded

<o:p></o:p>
The working day is deemed to be the length of the workday (A1 to B1) minus the break (A2 to B2). A5 should be a working day and B5 should be within the working hours. Formulas will cater for hours and minutes, not seconds

<o:p></o:p>
In D5 copied down

=WORKDAY(A5,CEILING((B5+C5-A$1-(B5>=B$2)*(B$2-A$2))/(B$1-A$1+A$2-B$2),1)-1,H$1:H$100)

In E5 copied down

=MROUND(B5+C5-(NETWORKDAYS(A5,D5,H$1:H$100)-1)*(B$1-A$1+A$2-B$2)+(B5< A$2)*(B$2-A$2)-(B5+C5-(NETWORKDAYS(A5,D5,H$1:H$100)-1)*(B$1-A$1+A$2-B$2)+(B5< A$2)*(B$2-A$2)<=B$2)*(B$2-A$2),"0:01")
<a$2)*(b$2-a$2)-(b5+c5-(networkdays(a5,d5,h$1:h$100)-1)*(b$1-a$1+a$2-b$2)+(b5><a$2)*(b$2-a$2)><=B$2)*(B$2-A$2),"0:01")< font></a$2)*(b$2-a$2)></a$2)*(b$2-a$2)-(b5+c5-(networkdays(a5,d5,h$1:h$100)-1)*(b$1-a$1+a$2-b$2)+(b5>

In A6 copied down

=WORKDAY(D5,(E5=B$1)+0,H$1:H$100)

and in B6 copied down

=IF(E5=B$1,A$1,IF(E5=A$2,B$2,E5))
<a$2)*(b$2-a$2)><=B$2)*(B$2-A$2),"0:01")<></a$2)*(b$2-a$2)>
Click to expand...
 
Upvote 0
I'm using the setup you suggested in your first post (see below) so C5 is the duration. The only thing I added was a holiday range in H1:H100

deckerp said:
The parameters are:
A1 = Start time 08:00
B1 = End Time 17:00
A2 = break lunch 12:00
B2 = back from lunch 13:00

Task parameters

A5 = start date 01/03/10 (entered manually)
B5 = start time 10:00 (entered manually)
C5 = duration 02:00 (hrs entered manually)
D5 = "end date" >>> (to be calculated exluding breaks and holidays)
E5 = "end time" >>> (to be calculated exluding breaks and holidays)
Click to expand...
 
Upvote 0
Hello again,
sorry for the confusion and thanks for lightening up.

I am getting an error with this
=MROUND(B5+C5-(NETWORKDAYS(A5,D5,H$1:H$100)-1)*(B$1-A$1+A$2-B$2)+(B5< A$2)*(B$2-A$2)-(B5+C5-(NETWORKDAYS(A5,D5,H$1:H$100)-1)*(B$1-A$1+A$2-B$2)+(B5< A$2)*(B$2-A$2)<=B$2)*(B$2-A$2),"0:01")
<a$2)*(b$2-a$2)-(b5+c5-(networkdays(a5,d5,h$1:h$100)-1)*(b$1-a$1+a$2-b$2)+(b5><a$2)*(b$2-a$2)><=B$2)*(B$2-A$2),"0:01")< font></a$2)*(b$2-a$2)></a$2)*(b$2-a$2)-(b5+c5-(networkdays(a5,d5,h$1:h$100)-1)*(b$1-a$1+a$2-b$2)+(b5>
Click to expand...

second error :

=IF(E5=B$1,A$1,IF(E5=A$2,B$2,E5))
<a$2)*(b$2-a$2)><=B$2)*(B$2-A$2),"0:01")<></a$2)*(b$2-a$2)>
Click to expand...

Any clue?
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Production time calculation within the working day accounting for breaks
2
Replies
16
Views
639
felixstraube
F
P
  • Question
Calculate time between start and finish minus the lunch break
2
Replies
13
Views
709
paulalex93
P
B
  • Solved
Projecting End date by accounting for holidays
Replies
4
Views
261
BB77
B
S
  • Solved
Calculate Revert Time
Replies
6
Views
401
felixstraube
F
A
  • Question
Add a specified number of working hours to a date & time, given working day start, end and break times and holidays
Replies
2
Views
221
AquaBuoy
A

Forum statistics

Threads
1,214,574
Messages
6,120,327
Members
448,956
Latest member
Adamsxl

Share this page

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