Calculating and setting repeatitive values on Excel Spread Sheet

[lancesunny]

Hi Guys,

I need help regarding calculating and setting values of hours for the dates as shown in figure. in the Excel spread sheet. For example
A B C D E F G H I J K L M N
[TABLE="width: 1112"]
<tbody>[TR]
[TD]1[/TD]
[TD]Extract[/TD]
[TD]Est. Time[/TD]
[TD]Start Date[/TD]
[TD]Weeks[/TD]
[TD="align: right"]8/18/2014[/TD]
[TD="align: right"]8/25/2014[/TD]
[TD="align: right"]9/1/2014[/TD]
[TD="align: right"]9/8/2014[/TD]
[TD="align: right"]9/15/2014[/TD]
[TD="align: right"]9/22/2014[/TD]
[TD="align: right"]9/29/2014[/TD]
[TD="align: right"]10/6/2014[/TD]
[TD="align: right"]10/13/2014[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Mapping[/TD]
[TD][/TD]
[TD="align: right"]8/18/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1st Round[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]10/13/2014[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2nd Round[/TD]
[TD="align: right"]33.2[/TD]
[TD="align: right"]10/27/2014[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.60[/TD]
[TD="align: right"]16.6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Here we calculate and set values for dates 8/18 8/25 9/1 9/8 9/15 9/22 9/29 10/6 10/13 = Est Time / Weeks = 76/8 = 9.55 so set the hours = 9.55 for next following 8 dates based on Given no. of weeks as counter.

Can you guys please help me in order to solve this?

Thanks for Help in advance.

Thanks,
-San