inserting a formula in PIVOT table field.

S

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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
sony18 said:
<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.
Click to expand...


I need the "Hours spent" details in a new column or in the table mentioned above.
 
Upvote 0
My advice would be to rearrange your pivot table, so you have the date as the column field, and add 2 data fields for "min of Time2" and "max of time2". You can then add a calculated column with max-min to get your hours spent (note you'll have to add this outside the pivot table - I don't think you can add calculated columns in a pivot)
 
Upvote 0
charlie1105 said:
My advice would be to rearrange your pivot table, so you have the date as the column field, and add 2 data fields for "min of Time2" and "max of time2". You can then add a calculated column with max-min to get your hours spent (note you'll have to add this outside the pivot table - I don't think you can add calculated columns in a pivot)
Click to expand...

Could you please explain with an example.
 
Upvote 0
Ok

Highlight your data, and create a new pivot table.

Drag "date" into the row area (sorry I said column earlier, that was an error)
Drag Time 2 into the data area, then right click on the data title, select "Field settings" and change the "Summarise by" to "Max"
Drag time2 into the data area again, and change this to "Min"

(Right click on the "data", go to "Order" and select "move to column")

You should now have something that looks like

Date.....Max of time2.......min of time2
25/8/08....XXXXXXXX.........XXXXXXXX
26/5/08....XXXXXXXX.........XXXXXXXX
etc.

Then in column D you can add a calculated column "=B5-C5" and drag down to get the total for each day
 
Upvote 0
charlie1105 said:
Ok

Highlight your data, and create a new pivot table.

Drag "date" into the row area (sorry I said column earlier, that was an error)
Drag Time 2 into the data area, then right click on the data title, select "Field settings" and change the "Summarise by" to "Max"
Drag time2 into the data area again, and change this to "Min"

(Right click on the "data", go to "Order" and select "move to column")

You should now have something that looks like

Date.....Max of time2.......min of time2
25/8/08....XXXXXXXX.........XXXXXXXX
26/5/08....XXXXXXXX.........XXXXXXXX
etc.

Then in column D you can add a calculated column "=B5-C5" and drag down to get the total for each day
Click to expand...


It is not working for me.
I am getting the sum of all times for Max of time2 and Min of time2, and not the needed ones.
 
Upvote 0
charlie1105 said:
Ok

Highlight your data, and create a new pivot table.

Drag "date" into the row area (sorry I said column earlier, that was an error)
Drag Time 2 into the data area, then right click on the data title, select "Field settings" and change the "Summarise by" to "Max"
Drag time2 into the data area again, and change this to "Min"

(Right click on the "data", go to "Order" and select "move to column")

You should now have something that looks like

Date.....Max of time2.......min of time2
25/8/08....XXXXXXXX.........XXXXXXXX
26/5/08....XXXXXXXX.........XXXXXXXX
etc.

Then in column D you can add a calculated column "=B5-C5" and drag down to get the total for each day
Click to expand...


It is not working for me.
I am getting the sum of all times for Max of time2 and Min of time2, and not the desired max and minimum values
 
Upvote 0
No worries, glad I could help

Spend some time playing with pivot tables, they're very useful when you get the hang of them :)
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
596
smozgur
smozgur
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
R
  • Question Question
Random
Replies
1
Views
580
Fluff
Fluff

Forum statistics

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

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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