Split time in to shifts

N

nitroxed

New Member
Joined
Oct 12, 2017
Messages
2
Hi

I have spent SO much time in Excel trying to get this to work but have failed miserably, when I think I'm there, I test it and it fails....

This is the scenario:

We pay staff weekly based on 4 different categories of shift as follows (all paid at different hourly rates) which they submit a timesheet for:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Shift[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[/TR]
[TR]
[TD]Mon-Fri Day[/TD]
[TD]06:00[/TD]
[TD]20:00[/TD]
[/TR]
[TR]
[TD]Mon-Fri Night[/TD]
[TD]20:00[/TD]
[TD]06:00[/TD]
[/TR]
[TR]
[TD]Saturday[/TD]
[TD]00:00[/TD]
[TD]23:59[/TD]
[/TR]
[TR]
[TD]Sunday[/TD]
[TD]00:00[/TD]
[TD]23:59[/TD]
[/TR]
</tbody>[/TABLE]

The complexity of trying to get a formula to calculate the number of hours in each category blows my mind ! For example, we might have an employee who started at 1900hrs on Friday, and finished at 0800hrs on Saturday morning. A total shift length of 13hrs. Splitting this as per the shift table above actually gives rise to the following hours and shifts:

Mon-Fri Day 1hr
Mon-Fri Night 4hrs
Saturday 8hrs

What I would like ideally is the ability to enter start times and end times in to a spreadsheet and based on this and the table above, split their time in to the respective shift categories.

Any help greatly appreciated !

Thanks
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Sort by date Sort by votes
[TABLE="width: 1396"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD="colspan: 7"]We pay staff weekly based on 4 different categories of shift as follows (all paid at different hourly rates) which they submit a timesheet for:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shift[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD="colspan: 2"]rate $ / hour[/TD]
[TD]sun[/TD]
[TD="align: right"]01/01/2017 00:00[/TD]
[TD="align: right"]00:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun00:00[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon-Fri Day[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]20:00[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 01:00[/TD]
[TD="align: right"]01:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun01:00[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon-Fri Night[/TD]
[TD="align: right"]20:00[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 02:00[/TD]
[TD="align: right"]02:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun02:00[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Saturday[/TD]
[TD="align: right"]00:00[/TD]
[TD="align: right"]23:59[/TD]
[TD="align: right"]17[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 03:00[/TD]
[TD="align: right"]03:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun03:00[/TD]
[TD="align: right"]75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sunday[/TD]
[TD="align: right"]00:00[/TD]
[TD="align: right"]23:59[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 04:00[/TD]
[TD="align: right"]04:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun04:00[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 05:00[/TD]
[TD="align: right"]05:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun05:00[/TD]
[TD="align: right"]125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]employee who started at 1900hrs on Friday, and finished at 0800hrs on Saturday morning.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 06:00[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun06:00[/TD]
[TD="align: right"]150[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]Sun[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 07:00[/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun07:00[/TD]
[TD="align: right"]175[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon-Fri Day 1hr[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 08:00[/TD]
[TD="align: right"]08:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun08:00[/TD]
[TD="align: right"]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mon-Fri Night 4hrs[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 09:00[/TD]
[TD="align: right"]09:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun09:00[/TD]
[TD="align: right"]225[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Saturday 8hrs[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 10:00[/TD]
[TD="align: right"]10:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun10:00[/TD]
[TD="align: right"]250[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 11:00[/TD]
[TD="align: right"]11:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun11:00[/TD]
[TD="align: right"]275[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 12:00[/TD]
[TD="align: right"]12:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun12:00[/TD]
[TD="align: right"]300[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 13:00[/TD]
[TD="align: right"]13:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun13:00[/TD]
[TD="align: right"]325[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 14:00[/TD]
[TD="align: right"]14:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun14:00[/TD]
[TD="align: right"]350[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 15:00[/TD]
[TD="align: right"]15:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun15:00[/TD]
[TD="align: right"]375[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]start[/TD]
[TD]fri[/TD]
[TD]19:00[/TD]
[TD]fri19:00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 16:00[/TD]
[TD="align: right"]16:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun16:00[/TD]
[TD="align: right"]400[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]finish[/TD]
[TD]sat[/TD]
[TD]08:00[/TD]
[TD]sat08:00[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 17:00[/TD]
[TD="align: right"]17:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun17:00[/TD]
[TD="align: right"]425[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]pay[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]204[/TD]
[TD]$[/TD]
[TD="align: right"]01/01/2017 18:00[/TD]
[TD="align: right"]18:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun18:00[/TD]
[TD="align: right"]450[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 19:00[/TD]
[TD="align: right"]19:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun19:00[/TD]
[TD="align: right"]475[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 20:00[/TD]
[TD="align: right"]20:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun20:00[/TD]
[TD="align: right"]500[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 21:00[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun21:00[/TD]
[TD="align: right"]525[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 22:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun22:00[/TD]
[TD="align: right"]550[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I made a table from sun to sun = 8 days[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/01/2017 23:00[/TD]
[TD="align: right"]23:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]Sun[/TD]
[TD]Sun23:00[/TD]
[TD="align: right"]575[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]and put in the $ rate for each hour[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]mon[/TD]
[TD="align: right"]02/01/2017 00:00[/TD]
[TD="align: right"]00:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon00:00[/TD]
[TD="align: right"]600[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 01:00[/TD]
[TD="align: right"]01:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon01:00[/TD]
[TD="align: right"]614[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]these were cumulatively summed[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 02:00[/TD]
[TD="align: right"]02:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon02:00[/TD]
[TD="align: right"]628[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]and a subtraction gives the pay[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 03:00[/TD]
[TD="align: right"]03:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon03:00[/TD]
[TD="align: right"]642[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 04:00[/TD]
[TD="align: right"]04:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon04:00[/TD]
[TD="align: right"]656[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]the 204 $ comes from[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 05:00[/TD]
[TD="align: right"]05:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon05:00[/TD]
[TD="align: right"]670[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 06:00[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon06:00[/TD]
[TD="align: right"]684[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]=OFFSET($L$2,MATCH(D20,$L$3:$L$999,0),1)-OFFSET($L$2,MATCH(D19,$L$3:$L$999,0),1)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 07:00[/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon07:00[/TD]
[TD="align: right"]696[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 08:00[/TD]
[TD="align: right"]08:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon08:00[/TD]
[TD="align: right"]708[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]the helper table can be hidden if desired[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 09:00[/TD]
[TD="align: right"]09:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon09:00[/TD]
[TD="align: right"]720[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 10:00[/TD]
[TD="align: right"]10:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon10:00[/TD]
[TD="align: right"]732[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 11:00[/TD]
[TD="align: right"]11:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon11:00[/TD]
[TD="align: right"]744[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 12:00[/TD]
[TD="align: right"]12:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon12:00[/TD]
[TD="align: right"]756[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 13:00[/TD]
[TD="align: right"]13:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon13:00[/TD]
[TD="align: right"]768[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 14:00[/TD]
[TD="align: right"]14:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon14:00[/TD]
[TD="align: right"]780[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 15:00[/TD]
[TD="align: right"]15:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon15:00[/TD]
[TD="align: right"]792[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 16:00[/TD]
[TD="align: right"]16:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon16:00[/TD]
[TD="align: right"]804[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 17:00[/TD]
[TD="align: right"]17:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon17:00[/TD]
[TD="align: right"]816[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 18:00[/TD]
[TD="align: right"]18:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon18:00[/TD]
[TD="align: right"]828[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 19:00[/TD]
[TD="align: right"]19:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon19:00[/TD]
[TD="align: right"]840[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 20:00[/TD]
[TD="align: right"]20:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon20:00[/TD]
[TD="align: right"]852[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 21:00[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon21:00[/TD]
[TD="align: right"]866[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 22:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon22:00[/TD]
[TD="align: right"]880[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]02/01/2017 23:00[/TD]
[TD="align: right"]23:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]Mon[/TD]
[TD]Mon23:00[/TD]
[TD="align: right"]894[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]tue[/TD]
[TD="align: right"]02/01/2017 23:59[/TD]
[TD="align: right"]00:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]Mon[/TD]
[TD]Tue00:00[/TD]
[TD="align: right"]908[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 01:00[/TD]
[TD="align: right"]01:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue01:00[/TD]
[TD="align: right"]922[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 02:00[/TD]
[TD="align: right"]02:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue02:00[/TD]
[TD="align: right"]936[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 03:00[/TD]
[TD="align: right"]03:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue03:00[/TD]
[TD="align: right"]950[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 04:00[/TD]
[TD="align: right"]04:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue04:00[/TD]
[TD="align: right"]964[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 05:00[/TD]
[TD="align: right"]05:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue05:00[/TD]
[TD="align: right"]978[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 06:00[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue06:00[/TD]
[TD="align: right"]992[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 07:00[/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue07:00[/TD]
[TD="align: right"]1004[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 08:00[/TD]
[TD="align: right"]08:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue08:00[/TD]
[TD="align: right"]1016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 09:00[/TD]
[TD="align: right"]09:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue09:00[/TD]
[TD="align: right"]1028[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 10:00[/TD]
[TD="align: right"]10:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue10:00[/TD]
[TD="align: right"]1040[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 11:00[/TD]
[TD="align: right"]11:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue11:00[/TD]
[TD="align: right"]1052[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 12:00[/TD]
[TD="align: right"]12:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue12:00[/TD]
[TD="align: right"]1064[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 13:00[/TD]
[TD="align: right"]13:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue13:00[/TD]
[TD="align: right"]1076[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 14:00[/TD]
[TD="align: right"]14:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue14:00[/TD]
[TD="align: right"]1088[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 15:00[/TD]
[TD="align: right"]15:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue15:00[/TD]
[TD="align: right"]1100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 16:00[/TD]
[TD="align: right"]16:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue16:00[/TD]
[TD="align: right"]1112[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 17:00[/TD]
[TD="align: right"]17:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue17:00[/TD]
[TD="align: right"]1124[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 18:00[/TD]
[TD="align: right"]18:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue18:00[/TD]
[TD="align: right"]1136[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 19:00[/TD]
[TD="align: right"]19:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue19:00[/TD]
[TD="align: right"]1148[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 20:00[/TD]
[TD="align: right"]20:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue20:00[/TD]
[TD="align: right"]1160[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 21:00[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue21:00[/TD]
[TD="align: right"]1174[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 22:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue22:00[/TD]
[TD="align: right"]1188[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/01/2017 23:00[/TD]
[TD="align: right"]23:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]Tue[/TD]
[TD]Tue23:00[/TD]
[TD="align: right"]1202[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]wed[/TD]
[TD="align: right"]03/01/2017 23:59[/TD]
[TD="align: right"]00:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]Tue[/TD]
[TD]Wed00:00[/TD]
[TD="align: right"]1216[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 01:00[/TD]
[TD="align: right"]01:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed01:00[/TD]
[TD="align: right"]1230[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 02:00[/TD]
[TD="align: right"]02:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed02:00[/TD]
[TD="align: right"]1244[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 03:00[/TD]
[TD="align: right"]03:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed03:00[/TD]
[TD="align: right"]1258[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 04:00[/TD]
[TD="align: right"]04:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed04:00[/TD]
[TD="align: right"]1272[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 05:00[/TD]
[TD="align: right"]05:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed05:00[/TD]
[TD="align: right"]1286[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 06:00[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed06:00[/TD]
[TD="align: right"]1300[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 07:00[/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed07:00[/TD]
[TD="align: right"]1312[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 08:00[/TD]
[TD="align: right"]08:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed08:00[/TD]
[TD="align: right"]1324[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 09:00[/TD]
[TD="align: right"]09:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed09:00[/TD]
[TD="align: right"]1336[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 10:00[/TD]
[TD="align: right"]10:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed10:00[/TD]
[TD="align: right"]1348[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 11:00[/TD]
[TD="align: right"]11:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed11:00[/TD]
[TD="align: right"]1360[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 12:00[/TD]
[TD="align: right"]12:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed12:00[/TD]
[TD="align: right"]1372[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 13:00[/TD]
[TD="align: right"]13:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed13:00[/TD]
[TD="align: right"]1384[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 14:00[/TD]
[TD="align: right"]14:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed14:00[/TD]
[TD="align: right"]1396[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 15:00[/TD]
[TD="align: right"]15:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed15:00[/TD]
[TD="align: right"]1408[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 16:00[/TD]
[TD="align: right"]16:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed16:00[/TD]
[TD="align: right"]1420[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 17:00[/TD]
[TD="align: right"]17:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed17:00[/TD]
[TD="align: right"]1432[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 18:00[/TD]
[TD="align: right"]18:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed18:00[/TD]
[TD="align: right"]1444[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 19:00[/TD]
[TD="align: right"]19:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed19:00[/TD]
[TD="align: right"]1456[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 20:00[/TD]
[TD="align: right"]20:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed20:00[/TD]
[TD="align: right"]1468[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 21:00[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed21:00[/TD]
[TD="align: right"]1482[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 22:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed22:00[/TD]
[TD="align: right"]1496[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]04/01/2017 23:00[/TD]
[TD="align: right"]23:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]Wed[/TD]
[TD]Wed23:00[/TD]
[TD="align: right"]1510[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]thu[/TD]
[TD="align: right"]04/01/2017 23:59[/TD]
[TD="align: right"]00:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]Wed[/TD]
[TD]Thu00:00[/TD]
[TD="align: right"]1524[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 01:00[/TD]
[TD="align: right"]01:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu01:00[/TD]
[TD="align: right"]1538[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 02:00[/TD]
[TD="align: right"]02:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu02:00[/TD]
[TD="align: right"]1552[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 03:00[/TD]
[TD="align: right"]03:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu03:00[/TD]
[TD="align: right"]1566[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 04:00[/TD]
[TD="align: right"]04:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu04:00[/TD]
[TD="align: right"]1580[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 05:00[/TD]
[TD="align: right"]05:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu05:00[/TD]
[TD="align: right"]1594[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 06:00[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu06:00[/TD]
[TD="align: right"]1608[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 07:00[/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu07:00[/TD]
[TD="align: right"]1620[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 08:00[/TD]
[TD="align: right"]08:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]109[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu08:00[/TD]
[TD="align: right"]1632[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 09:00[/TD]
[TD="align: right"]09:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu09:00[/TD]
[TD="align: right"]1644[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 10:00[/TD]
[TD="align: right"]10:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]111[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu10:00[/TD]
[TD="align: right"]1656[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 11:00[/TD]
[TD="align: right"]11:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu11:00[/TD]
[TD="align: right"]1668[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 12:00[/TD]
[TD="align: right"]12:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu12:00[/TD]
[TD="align: right"]1680[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 13:00[/TD]
[TD="align: right"]13:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu13:00[/TD]
[TD="align: right"]1692[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 14:00[/TD]
[TD="align: right"]14:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu14:00[/TD]
[TD="align: right"]1704[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 15:00[/TD]
[TD="align: right"]15:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu15:00[/TD]
[TD="align: right"]1716[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 16:00[/TD]
[TD="align: right"]16:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu16:00[/TD]
[TD="align: right"]1728[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 17:00[/TD]
[TD="align: right"]17:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]118[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu17:00[/TD]
[TD="align: right"]1740[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 18:00[/TD]
[TD="align: right"]18:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]119[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu18:00[/TD]
[TD="align: right"]1752[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 19:00[/TD]
[TD="align: right"]19:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu19:00[/TD]
[TD="align: right"]1764[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 20:00[/TD]
[TD="align: right"]20:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]121[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu20:00[/TD]
[TD="align: right"]1776[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 21:00[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]122[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu21:00[/TD]
[TD="align: right"]1790[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 22:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu22:00[/TD]
[TD="align: right"]1804[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]05/01/2017 23:00[/TD]
[TD="align: right"]23:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]124[/TD]
[TD="align: right"]Thu[/TD]
[TD]Thu23:00[/TD]
[TD="align: right"]1818[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]fri[/TD]
[TD="align: right"]05/01/2017 23:59[/TD]
[TD="align: right"]00:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]Thu[/TD]
[TD]Fri00:00[/TD]
[TD="align: right"]1832[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 01:00[/TD]
[TD="align: right"]01:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]127[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri01:00[/TD]
[TD="align: right"]1846[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 02:00[/TD]
[TD="align: right"]02:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri02:00[/TD]
[TD="align: right"]1860[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 03:00[/TD]
[TD="align: right"]03:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri03:00[/TD]
[TD="align: right"]1874[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 04:00[/TD]
[TD="align: right"]04:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]130[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri04:00[/TD]
[TD="align: right"]1888[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 05:00[/TD]
[TD="align: right"]05:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri05:00[/TD]
[TD="align: right"]1902[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 06:00[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri06:00[/TD]
[TD="align: right"]1916[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 07:00[/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri07:00[/TD]
[TD="align: right"]1928[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 08:00[/TD]
[TD="align: right"]08:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]134[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri08:00[/TD]
[TD="align: right"]1940[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 09:00[/TD]
[TD="align: right"]09:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]135[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri09:00[/TD]
[TD="align: right"]1952[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 10:00[/TD]
[TD="align: right"]10:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]136[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri10:00[/TD]
[TD="align: right"]1964[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 11:00[/TD]
[TD="align: right"]11:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]137[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri11:00[/TD]
[TD="align: right"]1976[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 12:00[/TD]
[TD="align: right"]12:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]138[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri12:00[/TD]
[TD="align: right"]1988[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 13:00[/TD]
[TD="align: right"]13:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]139[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri13:00[/TD]
[TD="align: right"]2000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 14:00[/TD]
[TD="align: right"]14:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri14:00[/TD]
[TD="align: right"]2012[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 15:00[/TD]
[TD="align: right"]15:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri15:00[/TD]
[TD="align: right"]2024[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 16:00[/TD]
[TD="align: right"]16:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]142[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri16:00[/TD]
[TD="align: right"]2036[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 17:00[/TD]
[TD="align: right"]17:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]143[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri17:00[/TD]
[TD="align: right"]2048[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 18:00[/TD]
[TD="align: right"]18:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]144[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri18:00[/TD]
[TD="align: right"]2060[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 19:00[/TD]
[TD="align: right"]19:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]145[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri19:00[/TD]
[TD="align: right"]2072[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 20:00[/TD]
[TD="align: right"]20:00[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]146[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri20:00[/TD]
[TD="align: right"]2084[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 21:00[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]147[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri21:00[/TD]
[TD="align: right"]2098[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 22:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]148[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri22:00[/TD]
[TD="align: right"]2112[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]06/01/2017 23:00[/TD]
[TD="align: right"]23:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]149[/TD]
[TD="align: right"]Fri[/TD]
[TD]Fri23:00[/TD]
[TD="align: right"]2126[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]sat[/TD]
[TD="align: right"]06/01/2017 23:59[/TD]
[TD="align: right"]00:00[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]Fri[/TD]
[TD]Sat00:00[/TD]
[TD="align: right"]2140[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 01:00[/TD]
[TD="align: right"]01:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]152[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat01:00[/TD]
[TD="align: right"]2157[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 02:00[/TD]
[TD="align: right"]02:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]153[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat02:00[/TD]
[TD="align: right"]2174[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 03:00[/TD]
[TD="align: right"]03:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]154[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat03:00[/TD]
[TD="align: right"]2191[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 04:00[/TD]
[TD="align: right"]04:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]155[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat04:00[/TD]
[TD="align: right"]2208[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 05:00[/TD]
[TD="align: right"]05:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]156[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat05:00[/TD]
[TD="align: right"]2225[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 06:00[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]157[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat06:00[/TD]
[TD="align: right"]2242[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 07:00[/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]158[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat07:00[/TD]
[TD="align: right"]2259[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 08:00[/TD]
[TD="align: right"]08:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]159[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat08:00[/TD]
[TD="align: right"]2276[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 09:00[/TD]
[TD="align: right"]09:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]160[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat09:00[/TD]
[TD="align: right"]2293[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 10:00[/TD]
[TD="align: right"]10:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]161[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat10:00[/TD]
[TD="align: right"]2310[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 11:00[/TD]
[TD="align: right"]11:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]162[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat11:00[/TD]
[TD="align: right"]2327[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 12:00[/TD]
[TD="align: right"]12:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat12:00[/TD]
[TD="align: right"]2344[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 13:00[/TD]
[TD="align: right"]13:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]164[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat13:00[/TD]
[TD="align: right"]2361[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 14:00[/TD]
[TD="align: right"]14:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat14:00[/TD]
[TD="align: right"]2378[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 15:00[/TD]
[TD="align: right"]15:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]166[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat15:00[/TD]
[TD="align: right"]2395[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 16:00[/TD]
[TD="align: right"]16:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]167[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat16:00[/TD]
[TD="align: right"]2412[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 17:00[/TD]
[TD="align: right"]17:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]168[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat17:00[/TD]
[TD="align: right"]2429[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 18:00[/TD]
[TD="align: right"]18:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]169[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat18:00[/TD]
[TD="align: right"]2446[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 19:00[/TD]
[TD="align: right"]19:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]170[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat19:00[/TD]
[TD="align: right"]2463[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 20:00[/TD]
[TD="align: right"]20:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]171[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat20:00[/TD]
[TD="align: right"]2480[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 21:00[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]172[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat21:00[/TD]
[TD="align: right"]2497[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 22:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]173[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat22:00[/TD]
[TD="align: right"]2514[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/01/2017 23:00[/TD]
[TD="align: right"]23:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]174[/TD]
[TD="align: right"]Sat[/TD]
[TD]Sat23:00[/TD]
[TD="align: right"]2531[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]satsun[/TD]
[TD="align: right"]07/01/2017 23:59[/TD]
[TD="align: right"]00:00[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]175[/TD]
[TD="align: right"]Sat[/TD]
[TD]SunSat00:00[/TD]
[TD="align: right"]2548[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 01:00[/TD]
[TD="align: right"]01:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]177[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat01:00[/TD]
[TD="align: right"]2573[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 02:00[/TD]
[TD="align: right"]02:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]178[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat02:00[/TD]
[TD="align: right"]2598[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 03:00[/TD]
[TD="align: right"]03:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]179[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat03:00[/TD]
[TD="align: right"]2623[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 04:00[/TD]
[TD="align: right"]04:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]180[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat04:00[/TD]
[TD="align: right"]2648[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 05:00[/TD]
[TD="align: right"]05:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]181[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat05:00[/TD]
[TD="align: right"]2673[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 06:00[/TD]
[TD="align: right"]06:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]182[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat06:00[/TD]
[TD="align: right"]2698[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 07:00[/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]183[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat07:00[/TD]
[TD="align: right"]2723[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 08:00[/TD]
[TD="align: right"]08:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]184[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat08:00[/TD]
[TD="align: right"]2748[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 09:00[/TD]
[TD="align: right"]09:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]185[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat09:00[/TD]
[TD="align: right"]2773[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 10:00[/TD]
[TD="align: right"]10:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]186[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat10:00[/TD]
[TD="align: right"]2798[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 11:00[/TD]
[TD="align: right"]11:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]187[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat11:00[/TD]
[TD="align: right"]2823[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 12:00[/TD]
[TD="align: right"]12:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]188[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat12:00[/TD]
[TD="align: right"]2848[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 13:00[/TD]
[TD="align: right"]13:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]189[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat13:00[/TD]
[TD="align: right"]2873[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 14:00[/TD]
[TD="align: right"]14:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]190[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat14:00[/TD]
[TD="align: right"]2898[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 15:00[/TD]
[TD="align: right"]15:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]191[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat15:00[/TD]
[TD="align: right"]2923[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 16:00[/TD]
[TD="align: right"]16:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]192[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat16:00[/TD]
[TD="align: right"]2948[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 17:00[/TD]
[TD="align: right"]17:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]193[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat17:00[/TD]
[TD="align: right"]2973[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 18:00[/TD]
[TD="align: right"]18:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]194[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat18:00[/TD]
[TD="align: right"]2998[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 19:00[/TD]
[TD="align: right"]19:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]195[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat19:00[/TD]
[TD="align: right"]3023[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 20:00[/TD]
[TD="align: right"]20:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]196[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat20:00[/TD]
[TD="align: right"]3048[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 21:00[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]197[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat21:00[/TD]
[TD="align: right"]3073[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 22:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]198[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat22:00[/TD]
[TD="align: right"]3098[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 23:00[/TD]
[TD="align: right"]23:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]199[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat23:00[/TD]
[TD="align: right"]3123[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2017 23:59[/TD]
[TD="align: right"]00:00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]Sun[/TD]
[TD]SunSat00:00[/TD]
[TD="align: right"]3148[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Thanks for your help on this, however, the monetary values of the respective rates is not particularly important, it is the calculation (or summing) of the hours by shift category that is. Any chance you could make the content of your reply a little clearer ? You mentioned the helper table, however I'm not certain what the numbers are in the far right hand side ? Thanks.
 
Upvote 0
in stead of a dollar rate I could have put in an hours "figure" ie 1,1.3,1.5,2.0

then you would multiply base salary by hours.

The last but one column eg sun00:00 is just a concatenation of the day of the week with the time of the day, the last bit is eg satsun00:00 is to allow for a saturday start and sunday finish.

The last column is a running total of pay, so you deduct start day time pay from end day time pay.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
VBA help - Locking & unlocking on certain times of day
2
Replies
17
Views
341
dmt32
D
C
  • Question Question
Ordinary Hours or Penalty Shift
Replies
0
Views
414
ChetanPuri
C
M
  • Question Question
Complexed Time Difference Formula
2
Replies
17
Views
2K
mahmed1
M
S
  • Solved
Calculate Revert Time
Replies
6
Views
668
felixstraube
F
S
  • Question Question
Calculate Turn Around Time 7 days working excluding Holiday and in Working Hours
Replies
3
Views
776
surevyas1984
S

Forum statistics

Threads
1,223,893
Messages
6,175,242
Members
452,623
Latest member
russelllowellpercy

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