Sum total hours "when in operation" between 9:00pm and 8:00 am

I

ItExec

New Member
Joined
Oct 25, 2014
Messages
2
Basically, I am able to calculate the total hours in operations. Now, I need to sum the hours in Operations that fall between 9:00pm and 8:00 am.[TABLE="width: 980"]
<colgroup><col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181; mso-outline-level: 1;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181; mso-outline-level: 1;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181; mso-outline-level: 1;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181; mso-outline-level: 1;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181; mso-outline-level: 1;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181; mso-outline-level: 1;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254; mso-outline-level: 1;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254; mso-outline-level: 1;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181; mso-outline-level: 1;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181; mso-outline-level: 1;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181; mso-outline-level: 1;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181; mso-outline-level: 1;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254; mso-outline-level: 1;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254; mso-outline-level: 1;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <tbody>[TR]
[TD="class: xl84, width: 174, bgcolor: transparent, colspan: 2"]Monday[/TD]
[TD="class: xl84, width: 174, bgcolor: transparent, colspan: 2"]Tuesday[/TD]
[TD="class: xl84, width: 174, bgcolor: transparent, colspan: 2"]Wednesday[/TD]
[TD="class: xl84, width: 178, bgcolor: transparent, colspan: 2"]Thursday[/TD]
[TD="class: xl84, width: 174, bgcolor: transparent, colspan: 2"]Friday[/TD]
[TD="class: xl84, width: 174, bgcolor: transparent, colspan: 2"]Saturday[/TD]
[TD="class: xl84, width: 178, bgcolor: transparent, colspan: 2"]Sunday[/TD]
[TD="class: xl83, width: 82, bgcolor: transparent"] TOTAL[/TD]
[/TR]
[TR]
[TD="class: xl75, bgcolor: transparent"]Open [/TD]
[TD="class: xl75, bgcolor: transparent"]Close[/TD]
[TD="class: xl75, bgcolor: transparent"]Open [/TD]
[TD="class: xl75, bgcolor: transparent"]Close[/TD]
[TD="class: xl75, bgcolor: transparent"]Open [/TD]
[TD="class: xl75, bgcolor: transparent"]Close[/TD]
[TD="class: xl75, bgcolor: transparent"]Open [/TD]
[TD="class: xl75, bgcolor: transparent"]Close[/TD]
[TD="class: xl75, bgcolor: transparent"]Open [/TD]
[TD="class: xl75, bgcolor: transparent"]Close[/TD]
[TD="class: xl75, bgcolor: transparent"]Open [/TD]
[TD="class: xl75, bgcolor: transparent"]Close[/TD]
[TD="class: xl75, bgcolor: transparent"]Open [/TD]
[TD="class: xl75, bgcolor: transparent"]Close[/TD]
[TD="class: xl82, bgcolor: transparent"]HRS OPS[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]194:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]129:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]88:0[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]144:0[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]145:0[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl76, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]145:0[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]2:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]128:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]138:0[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]149:0[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]163:0[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]171:0[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]106:0[/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]127:0[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]9:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]10:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]169:0[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl79, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl78, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]140:30[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]8:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]108:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]5:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]98:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]5:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]79:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]194:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]138:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]5:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:30:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:30:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:30:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:30:00 PM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]5:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:30:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]190:30[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]161:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]8:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]167:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]8:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]186:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]184:30[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:30:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]184:30[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]134:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]138:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]188:0[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]193:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]138:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]3:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]3:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]3:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]3:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]3:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]3:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]3:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]73:0[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]138:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]8:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]189:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]8:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]10:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]136:0[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]138:0[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]137:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]10:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]8:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]10:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]136:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]143:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]138:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]193:0[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]144:0[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]128:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]182:0[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]168:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]188:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]2:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]84:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent"]1:00:00am[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent"]1:00:00am[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:30:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]158:30[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]1:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]171:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]182:0[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl71, bgcolor: transparent"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl71, bgcolor: transparent"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl71, bgcolor: transparent"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl71, bgcolor: transparent"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]8:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]189:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]12:00:00 AM[/TD]
[TD="class: xl80, bgcolor: transparent"]111:0[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]11:00:00 PM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]12:00:00 AM[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]6:00:00 AM[/TD]
[TD="class: xl71, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl80, bgcolor: transparent"]193:0[/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl73, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl73, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl73, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl73, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl73, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]7:00:00 AM[/TD]
[TD="class: xl73, bgcolor: transparent"]1:00:00 AM[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]8:00:00 AM[/TD]
[TD="class: xl73, bgcolor: transparent"]11:00:00 PM[/TD]
[TD="class: xl81, bgcolor: transparent"]167:0 [/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
Hi and welcome to the MrExcel message Board.

We can help with the Excel part but you will need to tell us how to solve the problem. For instance, if we look at the first line of your data, how would we determine how many hours are between 9:00pm and 8:00 am for Monday?
 
Upvote 0
Total Hours of Operations per location per week - then how many operate between 9:00 pm - 8:00 am

Hi,

I have this table that I put together for to calculate the numbers of hours that each one of my locations is open. First column is the location, then the day of the week with Open and Close hour, there are several that are open 24 hours a day, thus have the Open hour as 12:00 AM and Close hour as 12:00 am.

Now I want to tally the hours of operations for the week for each location. Then, I want to sum up the hours for the locations that are open between 9:00pm - 8:00 am. This is my ultimate goal, to know how many locations open during 9:00pm - 8:00 am so that I can analyze their sales during those hours.

[TABLE="width: 1430"]
<tbody>[TR]
[TD]Location[/TD]
[TD]Monday[/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[TD]Thursday[/TD]
[TD]Friday[/TD]
[TD]Friday[/TD]
[TD]Saturday[/TD]
[TD]Saturday[/TD]
[TD]Sunday[/TD]
[TD]Sunday[/TD]
[TD]TOTAL[/TD]
[/TR]
[TR]
[TD]Open[/TD]
[TD]Close[/TD]
[TD]Open[/TD]
[TD]Close[/TD]
[TD]Open[/TD]
[TD]Close[/TD]
[TD]Open[/TD]
[TD]Close[/TD]
[TD]Open[/TD]
[TD]Close[/TD]
[TD]Open[/TD]
[TD]Close[/TD]
[TD]Open[/TD]
[TD]Close[/TD]
[TD]HRS OPS[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]7:00:00 AM[/TD]
[TD="align: right"]11:00:00 PM[/TD]
[TD]194:0[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]2:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]7:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD]81:0[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]2:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]2:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]2:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]2:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]2:00:00 AM[/TD]
[TD]88:0[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]6:00:00 AM[/TD]
[TD]12:00:00 AM[/TD]
[TD]6:00:00 AM[/TD]
[TD]12:00:00 AM[/TD]
[TD]6:00:00 AM[/TD]
[TD]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD]6:00:00 AM[/TD]
[TD]12:00:00 AM[/TD]
[TD]96:0[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD]168:0[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD]168:0[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]7:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD]97:0[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD]168:0[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]7:00:00 AM[/TD]
[TD]12:00:00 AM[/TD]
[TD]313:0[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]6:00:00 AM[/TD]
[TD]12:00:00 AM[/TD]
[TD]6:00:00 AM[/TD]
[TD]12:00:00 AM[/TD]
[TD]6:00:00 AM[/TD]
[TD]12:00:00 AM[/TD]
[TD]6:00:00 AM[/TD]
[TD]2:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD]80:0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]6:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD]78:0[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[TD]168:0[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Re: Total Hours of Operations per location per week - then how many operate between 9:00 pm - 8:00 am

Hi ITExec
I think its an interesting puzzle. I had a go at this before but then realised it was taking me longer than I thought to work it all out. I defininitely found some useful excel functions by googling about. I'll have a another go and let you know what formula I come up with ---- no promises that I can get it working though :)
Cheers
M
 
Upvote 0
[Table="width:, class:grid"][tr][td]Row\Col[/td][td]
A​
[/td][td]
B​
[/td][td]
C​
[/td][td]
D​
[/td][td]
E​
[/td][td]
F​
[/td][td]
G​
[/td][td]
H​
[/td][td]
I​
[/td][td]
J​
[/td][td]
K​
[/td][td]
L​
[/td][td]
M​
[/td][td]
N​
[/td][td]
O​
[/td][td]
P​
[/td][td]
Q​
[/td][/tr]
[tr][td]
1​
[/td][td]
Location​
[/td][td]
Mon​
[/td][td]
Mon​
[/td][td]
Tue​
[/td][td]
Tue​
[/td][td]
Wed​
[/td][td]
Wed​
[/td][td]
Thu​
[/td][td]
Thu​
[/td][td]
Fri​
[/td][td]
Fri​
[/td][td]
Sat​
[/td][td]
Sat​
[/td][td]
Sun​
[/td][td]
Sum​
[/td][td]
Total​
[/td][td]
TOTAL​
[/td][/tr]

[tr][td]
2​
[/td][td][/td][td]
Open​
[/td][td]
Close​
[/td][td]
Open​
[/td][td]
Close​
[/td][td]
Open​
[/td][td]
Close​
[/td][td]
Open​
[/td][td]
Close​
[/td][td]
Open​
[/td][td]
Close​
[/td][td]
Open​
[/td][td]
Close​
[/td][td]
Open​
[/td][td]
Close​
[/td][td]
Hours​
[/td][td]
9P-8A​
[/td][/tr]

[tr][td]
3​
[/td][td]
1​
[/td][td]
6:00​
[/td][td]
23:00​
[/td][td]
6:00​
[/td][td]
23:00​
[/td][td]
6:00​
[/td][td]
23:00​
[/td][td]
6:00​
[/td][td]
23:00​
[/td][td]
0:00​
[/td][td]
24:00​
[/td][td]
0:00​
[/td][td]
24:00​
[/td][td]
7:00​
[/td][td]
23:00​
[/td][td]
132:00​
[/td][td]
16:00​
[/td][/tr]

[tr][td]
4​
[/td][td]
2​
[/td][td]
6:00​
[/td][td]
24:00​
[/td][td]
6:00​
[/td][td]
24:00​
[/td][td]
6:00​
[/td][td]
24:00​
[/td][td]
6:00​
[/td][td]
26:00​
[/td][td]
0:00​
[/td][td]
24:00​
[/td][td]
0:00​
[/td][td]
24:00​
[/td][td]
7:00​
[/td][td]
24:00​
[/td][td]
139:00​
[/td][td]
23:00​
[/td][/tr]
[/table]

The open and closing times are formatted as [h]:mm. I changed a closing time of 0:00 to 24:00, and a 2 AM closing to 26:00.

The formula in P2 is

=SUMPRODUCT(($B$2:$O$2="Close") * $B3:$O3 - ($B$2:$O$2="Open") * $B3:$O3)

The formula in Q2, which MUST be confirmed with Ctrl+Shif+Enter instead of just Enter, is

=SUMPRODUCT(
($B$2:$O$2="Close") * IF($B3:$O3 - "21:00" < 0, 0, $B3:$O3 - "21:00") -
($B$2:$O$2="Open") * IF($B3:$O3 - "21:00" < 0, 0, IF($B3:$O3 - "21:00" - "08:00" > 0, "08:00", $B3:$O3 - "21:00")))
 
Upvote 0
To avoid too much complication, I chose to solve this "kindergarten" style....

I would write a VBA subroutine, create an array of 24 elements. Each element represents one hour of time. Then I would populate the hours the shop is open with say the word "Open", then write blanks to the elements that are outside the 9pm , then total how many element still hold "Open". Repeat for all the other days of the week and shops and total it all up at the end. This is just another way to think about it I guess!!
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question Question
Calculate and Identify Ordinary Hours, Double time or 1.5 Time
Replies
0
Views
242
ChetanPuri
C
M
  • Solved
Returning results based on multiple criteria
Replies
5
Views
479
DanteAmor
DanteAmor
U
  • Question Question
VLOOKUP that will SUM data based on Date Range
2
Replies
18
Views
964
UnitedCloud01
U
K
  • Question Question
Help with difference between 2 dates including am/pm and check multiple entries to see if they occur at the same date and am/pm
Replies
1
Views
499
XLfriend777
XLfriend777
R
  • Solved
vlookup, INDEX, or SUMPRODUCT???
2
Replies
10
Views
824
KRice
K

Forum statistics

Threads
1,223,228
Messages
6,170,876
Members
452,363
Latest member
merico17

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