Duration of a shift and planned downtime

[former_member326625]

Hi All,

I checked the current postings, but couldn't find anything related to what I am looking for, while one or two related to time intervals and schedules was almost close...

I am a project manager working on an xMII implementation that currently is not running ERP.

The factory has a regular 8 hour shift schedule, a 6 hr weekend shift schedule, a 8 hr weekend shift schedule, a 6 hour holiday shift shift, and a 8 hr holiday shift. For the 6 hr shifts the planned downtime is 40 min. For the 8 hr holiday and weekend shifts the planned downtime is 65 min and the reg 8 hr shift has 75 min of planned downtime.

My understanding is that xMII first looks at the schedule and then the interval.

Does anyone have any idea around how the intervals could be set-up, linked to a schedule so that the code can see that the shift is 8 hrs in duration but because it is a holiday schedule 65 min of planned downtime should be subtracted instead of the usual 75 min?

Thanks in advance for any thoughts...

Susan

[jcgood25]

Hi Susan,

Your understanding that 'xMII first looks at the schedule and then the interval' is accurate, but the standard time engine capabilities for Time Periods and Schedules doesn't really address your particular needs.

It is a little unclear where and how you want to apply the 75 or 65 minutes of downtime subtraction, but if you default this to 75 and then only adjust it to 65 when you are in a 'holiday' schedule you could probably accomplish your desired outcome.

A database table that contains the holiday start and end datetime shift ranges could be queried in relation to the current time for the notion of in/out of holiday mode. So if you default it to 75 and then if the query indicates a 'holiday mode' change it to 65 for the necessary subtraction.

Regards,

Jeremy Good