Question Schedules

[HDEvKev]

I am trying to figure out how to display and maintain a schedule.
Here's the situation: I have 6 machines that run jobs Monday thru Friday but I will focus on doing one machine to avoid confusion.
Let's start with this. The machine will be running 23 hours a day Monday thru Thursday and 18 hours on Friday and is shut down on Saturday and Sunday. Monday morning at 5am (start of the work week) Job A starts. The job will run for 30 hours. Then Job B will run for 160 hours. I need to know when Job B will start and end. Although it would be nice to know the time of day, just knowing the date would be good enough.
As I said I have 6 machines and each one is running anywhere from 7 to 10 jobs. My end result could be nothing more than a report, but a datasheet form would be ideal. On Mondays, new jobs are added and schedule is updated based on actual productivity from the prior week.
I am a novice, but a quick learner so be kind and patient. Thanks for help.

 

[JHB]

Which data do you already have/ do you record in the database?
Show table structure/ relationships/ some sample data!
The time you mention, I suppose is it estimated time, but what if a machine break down, what happen then?
You need to explain more about your business role and the data!

 

[HDEvKev]

Currently we are doing this with an excel spreadsheet, but all the data is being entered with no calculations by the production manager. I have been manually transferring the data into a db table which lists the jobs sorted by start date. The Start date is a short date field and the estimated run time is Long Int. field. Although I have created this 10 year work in progress database/program. I recently took over the purchasing of raw material for these jobs and have to schedule when I want the material arrive. We don't play it super tight so it doesn't have to be exact to the day.
When we have breakdowns or maintenance the production manager reschedules all the jobs. The machines are all the same so the jobs can be moved to different machines with little limitations.

 

[JHB]

I've made a small sample for you, open the only form in it and change the data and time + time to run.