Hi,
Maybe I am missing something StartTime + DownTime + RunTime should equal
TotalTime. Maybe a simple one, not crossing dates will help me understand.

Run Time 3 hrs, DownTime 1 hour, total elapsed time 4 hours.
Start at Noon (12 pm)
Work 1 hour ( it is 1 pm now) - 1
Down for 1 hour (it is now 2 pm) -1
Work for 2 hours (it is now 4 pm) -2
Total = 4
Am I missing something here?

Thanks,


"Paulymon" wrote:

Thanks for your response.

What I'm having a problem with is what happens when the start time + the
order run time lands in the middle of the down time. It would have to be
adjusted for the part that it overlaps the beginning of down time and then
add that amount to the end of the scheduled down time. I'm pretty sure I can
figure it out but if there were a function similar to the networkdays that
would exclude times instead of dates that woluld be ideal

"David" wrote:

Hi,
The set up on this is important, but try this:

RunTime StartDate/Time DownTime FinishDate/Time
1.16666 4/18/05 6:00 AM 1/0/00 4:00 AM 4/19/05 2:00 PM
=28/24 =4/24 =+B2+A2+C2
Format is date and Time Format is date and Time
ColA ColB ColC ColD
28 hrs/24 4hrs/24

Thanks,


"Paulymon" wrote:

Is there a function similar to Networkday for time? That would exclude a
time range from calculations?

I need to compute the start and end time of an order. I know how long the
job will take and the initial start time but the availability of the press is
not 24/7 so I have a couple of problems.

Let's say the job goes to press at 6am Monday and is scheduled for 28 hours
of production. If the press ran 24/7 then the end time/date would be Tuesday
at 10am. Unfortunately the press is down from 4pm to 8pm on Monday and so
will not be done until Tuesday at 2pm. I'm generating data for multiple
orders over several days and the press availability time may shift from day
to day. So the end time of a job cannot land during one of the down periods
or take account the downtime periods when figuring the end time of an order.

Any help would be appreciated--even if it's just pointing me in the right
direction.