Coverting hours in Gantt Chart Excel

[olsen9]

I'm looking to create a gantt chart for a project timeline.
I need some help writing the code to handle.

The goal is to take start date and have the code calculate and end date of the task my hours of the project. Also based of a percentage of my day.

For example: If task A is going to take me 24 hours to complete. If the start date is 9/23/11 and I want to use 20% of my 40hr week to handle this project how long will it take me? So 20 % of 40 hrs is 8hrs per week. This would then have an end date 3 weeks from now. I would like the code to change the date if I was to input variables for % of time per week and/or hours.

If anyone can help, I would greatly appreciate it.

 

[Derek Brown]

Hello and welcome to The Board.

See if the following helps or gives you some ideas:
http://chandoo.org/wp/2009/06/16/gantt-charts-project-management/

 

[Jon Peltier]

I suggest designing a solution that uses worksheet formulas rather than VBA to make these calculations. The formulas are easier to debug, update automatically, and generally run faster than code.