Excel version of Project

[RichardMGreen]

Hi all

I want to set up a spreadsheet where I can list all the jobs that need to be done and an estimate pof how long each job is likely to take and the have it work out when the job can be started.
It'll be done in hours (but I need to take into account a 30 minute lunchbreak.
The standard will be an 8 hour day (not including lunch).
I want to be able to list the jobs on one sheet and have a gantt-style chart on a second with coloured lines or cells to show when a job will be started and finished.

I can list the jobs and the times without a problem.
The main problem will be working out when a job can be started depending on when the next free time slot will be.

Can anyone give me a starter for this?

As a nice-to-have more than anything, will it be possible to click on the job in the gantt-chart and have Excel to go the job sheet and highlight the job you've just clicked on?

 

[Weaver]

I found some useful links here:

http://www.google.co.uk/#sclient=ps...5058ac85bf93e8c2&biw=1073&bih=560&safe=active

 

[RichardMGreen]

Thanks for that.
Any ideas on how I'd do the first bit (working out the finishing times from the number of hours for a job)? I can work in half days if that helps?

 

[RichardMGreen]

Anyone? Please?