Hi.

I am about to prepare a Project Weekly Report in which I have distribute Total Hours of particular task into weekly hours in respective weeks. For example if a task is taking totally 50 hours between a particular start date and end date, how to I distribute this in weekly basis (Week 2 is having 20 hours, Week 3 is having 20 hours, Week 4 is having 10 hours.. Like that). Please help.

Thanks
Mathan

Without more information about how you would "automate" this decision-making model and a look at your workbook, I'd say it's a manual process, isn't it?