Automatic finish date & time with lunch break and bank holidays

deckerp

Active Member
Joined
Feb 12, 2010
Messages
301
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:

deckerp

Active Member
Joined
Feb 12, 2010
Messages
301
Office Version
  1. 365
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.


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
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Akashwani

Well-known Member
Joined
Mar 14, 2009
Messages
2,911
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
 

deckerp

Active Member
Joined
Feb 12, 2010
Messages
301
Office Version
  1. 365
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.



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
 

Akashwani

Well-known Member
Joined
Mar 14, 2009
Messages
2,911

ADVERTISEMENT

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
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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:

deckerp

Active Member
Joined
Feb 12, 2010
Messages
301
Office Version
  1. 365

ADVERTISEMENT

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
 

deckerp

Active Member
Joined
Feb 12, 2010
Messages
301
Office Version
  1. 365
what is in C5 ?


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)>
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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

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)
 

deckerp

Active Member
Joined
Feb 12, 2010
Messages
301
Office Version
  1. 365
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>

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)>

Any clue?
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,129,263
Messages
5,635,145
Members
416,844
Latest member
ryanangus496

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
Top