inserting a formula in PIVOT table field.

sony18

New Member
Joined
Aug 27, 2008
Messages
25
<TABLE style="WIDTH: 244pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=325 border=0><COLGROUP><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 72pt; mso-width-source: userset; mso-width-alt: 3510" width=96><COL style="WIDTH: 113pt; mso-width-source: userset; mso-width-alt: 5522" width=151><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: black; BORDER-LEFT: #d4d0c8; WIDTH: 59pt; COLOR: white; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=78 height=20>Date
</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: black; BORDER-LEFT: #d4d0c8; WIDTH: 72pt; COLOR: white; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=96>Hours spent</TD><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: black; BORDER-LEFT: #d4d0c8; WIDTH: 113pt; COLOR: white; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=151>Time2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20>6/25/2008x </TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">(blank)</TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/25/2008 2:40:03 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/25/2008 2:43:53 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20>6/26/2008x </TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">(blank)</TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 8:45:36 AM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 8:47:32 AM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 11:26:20 AM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 11:39:12 AM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 11:39:14 AM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 12:58:40 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 1:31:40 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 2:26:00 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 2:35:44 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 3:02:05 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 3:25:16 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/26/2008 5:38:42 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20>6/27/2008x </TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">(blank)</TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 8:38:24 AM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 8:40:06 AM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 9:22:26 AM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 9:31:08 AM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 12:58:18 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 1:37:38 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 1:37:42 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 3:29:59 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 3:43:18 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 4:05:27 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 4:10:31 PM</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #fcd5b4 0.5pt solid; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; HEIGHT: 15pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none" height=20></TD><TD style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: gray; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none"></TD><TD class=xl64 style="BORDER-RIGHT: #fcd5b4 0.5pt solid; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #fde9d9; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: Calibri; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #FDE9D9 none">6/27/2008 5:27:37 PM</TD></TR></TBODY></TABLE>

Above is the part of PIVOT table data I have.
Column "TIME2" is the swipe timings during that particular day.
I need to find the difference of swipe timings(First swipe time and Last swipe time during that day) in "HOURS SPENT" coumn for the whole day.
For example
Date="6/26/2008x"
Hours spent =Last (6/26/2008 5:38:42 PM) - First (6/26/2008 8:45:36 AM) = "8:53:06" in "H:MM:SS" format.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sure,

I think what you'll need to do is go back to the original source data and create a new column - Week. You can use the "weeknum()" function:

=weeknum(A2) (assuming your dates are in column A)

You can then use this as the row field in the pivot table
 
Upvote 0
That is not working here. Here is the data. I need total hours spent by each employee.
For example consider employee no. 19024
I should get the total hours spent( sum(4:22:39, 9:05:22, 8:59:55, 8:08:52)= 32:52:17).

Effective hours is not a part of Pivot table and it is calculated(max of time2-max of time1)

<TABLE style="WIDTH: 356pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=472 border=0><COLGROUP><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" width=64><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3584" width=98><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" span=2 width=102><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #dbe5f1; BORDER-LEFT: #d4d0c8; WIDTH: 80pt; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" width=106 height=17></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #dbe5f1; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" width=64></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #dbe5f1; BORDER-LEFT: #d4d0c8; WIDTH: 74pt; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" width=98>Values</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #dbe5f1; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" width=102></TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=102></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #dbe5f1; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #95b3d7 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none" height=17>Emp. No.</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #dbe5f1; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #95b3d7 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none">Day</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #dbe5f1; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #95b3d7 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none">Min of Time1</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #dbe5f1; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #95b3d7 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #DBE5F1 none">Max of Time2</TD><TD class=xl65 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">effective hours</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" align=right height=17>19024</TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/25/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>13:13:37</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>17:36:16</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>4:22:39</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17></TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/26/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8:33:48</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>17:39:10</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>9:05:22</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17></TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/27/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8:34:40</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>17:34:35</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8:59:55</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #95b3d7 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17></TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/28/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8:21:57</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>16:30:49</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8:08:52</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17>19024 Total</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #4f81bd 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none"></TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #4f81bd 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" align=right>13:13:37</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #4f81bd 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" align=right>16:30:49</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>3:17:12</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" align=right height=17>81027</TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/25/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>13:33:13</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>20:08:34</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>6:35:21</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17></TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/26/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>10:47:11</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>20:52:33</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>10:05:22</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17></TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/27/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>10:51:04</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>21:44:09</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>10:53:05</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #95b3d7 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17></TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/28/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>11:27:26</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>20:11:36</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8:44:10</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17>81027 Total</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #4f81bd 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none"></TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #4f81bd 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" align=right>13:33:13</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #4f81bd 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" align=right>20:11:36</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>6:38:23</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" align=right height=17>90891</TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/25/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>12:44:56</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>20:19:46</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>7:34:50</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17></TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/26/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>11:18:28</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>20:17:57</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8:59:29</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #d4d0c8; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17></TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/27/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8:44:30</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>19:00:57</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>10:16:27</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #95b3d7 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17></TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8/28/2008</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>8:42:07</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>18:42:35</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>10:00:28</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" height=17>90891 Total</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #4f81bd 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none"></TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #4f81bd 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" align=right>12:44:56</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #4f81bd 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: #d4d0c8; COLOR: black; BORDER-BOTTOM: #4f81bd 0.5pt solid; FONT-FAMILY: 'MS Sans Serif'; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none" align=right>18:42:35</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>5:57:39</TD></TR></TBODY></TABLE>
 
Upvote 0
Updating bottom rows

<TABLE style="WIDTH: 384pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=512 border=0><COLGROUP><COL style="WIDTH: 48pt" span=8 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=64 height=20>Hi
s
</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>a</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>c</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>a</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>a</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>dc</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>a</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=64>c</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>d</TD><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #b8cce4">a</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">b</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">c</TD><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #b8cce4">a</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">cc</TD><TD class=xl63 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #b8cce4">a</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">b</TD></TR></TBODY></TABLE>

Can any one explain how we can update the 2nd row if it match with the first row like above.

Thanks
 
Upvote 0

Forum statistics

Threads
1,224,163
Messages
6,176,811
Members
452,744
Latest member
Alleo

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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