Making a Job Flow/Schedule for Employees

Hi all I looking to make a Excel spreadsheet that will take job planning a little easier. Its kinda hard to explain exactly what I'm looking for or trying to do but I will try my best. Say one day I get a job I know its going to take a certain amount of hours. Lets say 27 hours so excel would ask the Job number and approximately how long it will take to complete the job. Then before you finish the 27 hours you get another job. So you go to your spreadsheet it asks you for your job number and how long it will take to complete the job. It will take that job and add it at the end of the 27 hours but in a different color or something to help deviate the jobs. So eventually you could have several weeks planned and if someone comes and asks you hey when will this be done you can look at the chart and say oh well right here. Now that seems fairly simple but I also need to be able to change the hours in case it takes longer or I finish early and be able to add more important jobs in between other jobs. If anyone has any information on how I could figure this out I would be greatly appreciated. Thank you.

Hi flareindustries

I have had a play with this and got so far.

The idea is that you set up wour working pattern, get a job list, and the macro spreads it in to a diary. You did not specify, so I assumed a half-day diary. I have not dealt with how this should be laid out (? keep going right until you run out of columns, or have months below each other, or some other layout?)

If you decide that an urgent job needs to be slotted in, just re-do your list and re-run it (you will, of course lose any history, unless you have taken a copy). Likewise if you are running ahead/behind schedule - amend and re-run.

Note that the American dates may cause you a problem, as the macro looks for the "Start date" and my be confused ny the different formats.
Let me kow how you get on.

Regards
Alastair