Section 5 Setting up a Calendar

Manufacturing Corner on

Saturday, November 26, 2022

 So far we have assumed that the work centre works 24 hours a day without a break, as would a continuous process such as

an oil refinery or a paper mill. However, if it is not a continuous process we need to define the working periods during which the

work centre is available. Here is an example of a calendar in hours, and decimals of an hour

(later we will examine dates and times):

establishes the beginning of the calendar at zero hour, midnight

work from 8:00 am to 10:00 am

a 15 min break, resume work at 10:15 am and work till 1:00 pm

30 min for lunch, then work till 3:30 pm

a 15 min break in the afternoon, then work till 6:00 pm

an hour for dinner, then work till 10:00 pm

We are counting hours into the schedule beginning at midnight.

Each line is a working period, the breaks lie in between.

In this example we begin at 8:00 AM, end at 10:00 PM, work for 12 hours, and have 2 hours of breaks.

Take a look at the formulas, they are very simple.

Now consider this problem:

If you start a 7 hour job at 8:30 AM, at what time will you stop?

You could do this:

With a bit of trial and error you can work out that the answer is at hour 16.5 or 4:30 pm

However, a more comprehensive calculation is set out on the next worksheet.

Labels: Scheduling Excel Basic

Thanks for reading Section 5 Setting up a Calendar. Please share...!