p45cal,

Your formula works great thanks again. Got one more question if you do not
mind. With this spreedsheet I am not only tracking how much time is required
to complete all of the steps and when they should be finished with one step
and on to the next, but I am also tracking when the process was started and
when the parts are due.

Customer
File # P11672
Due Date: 7/18/07
Released: 7/12/07 8:17 AM
Workdays: #VALUE!

My problem is I get an Value error.

In the released colum I am using =Now() and in the work days I am using
=NETWORKDAYS(C5,D10,NETWORKDAYS!C1:C10)
C5 is the due date, D10 is the first process step and NETWORKDAYS is another
work sheet that has all of the holidays.

Hope this enough information

Regards

Scott


"p45cal" wrote:

I made a mistake when I said that the formula you gave me ended the week Sat
1am and started on Mon 8am. On testing on my PC with XL2003 the week ends Fri
1am and starts Sun 8am. Do you run this on Excel on a Mac?

The following formula uses Sat 1am as the end of the working week and Mon
8am as the start. If it uses the wrong days for the weekend on your system,
you may have to change the =7 back to =6.

It seems to work well on cursory testing, BUT YOU WILL HAVE TO CHECK IT OUT
THOROUGHLY YOURSELF. This belongs in cell D21:

=IF(A21="","",IF(AND((MOD(D20,1)+(VLOOKUP(A21,'WOR K
STEPS'!D$2:E$39,2,TRUE))0.041666),MOD(D20,1)<0.33 3333,WEEKDAY(D20,1)=7),ROUNDDOWN(D20,0)+2.333333+V LOOKUP(A21,'WORK
STEPS'!D$2:E$39,2,TRUE),D20+VLOOKUP(A21,'WORK STEPS'!D$2:E$39,2,TRUE)))

and can be filled down and/or up the column.

ps. You gave very little information out, I had to work out or make
assumptions for myself about where things were, what kind of data it was.
Normally, on viewing posts with such sparse information I would have passed
onto another question, but unusually, I had time to kill. If you can't be
bothered to supply full details, why should others be bothered to look at
your problem? Help others to help you. OK, lecture over, hope this fits the
bill.

--
p45cal


"Scott W" wrote:

I do need to go 24 hours per day but only until Saturday 1:00Am and start
again on Monday at 8:00AM. I really appreciate your help.

Thanks

Scott

"p45cal" wrote:

Right, the formula you gave allows steps to go on until 1am; if they would go
beyond 1am then that step starts at 8am next morning instead. A 17 hour day.
The formula you gave also takes into account weekends, with the last job
having to be finished before Saturday 1am, Monday 8am being the next start
time.

Do you still want weekends taken into acount? If so, is the end of the week
still 1am Saturday, and start of the week 8am Monday? Or is production now
truly 24/7?

--
p45cal