The only things that seem to relate to time in hours is the value 0.041666
which is 1 hour, and 0.33333 which is 8 hours. Without knowing what's in the
range 'WORK STEPS'!D$2:E$39, and what's in A21, D20, I doubt that anyone's
going to be willing or able to help. Maybe just a smidgin more information.
--
p45cal


"Scott W" wrote:

I am using a spreed sheet that runs a time line as to how long something will
take to be produced. On a separate work sheet I have numbered the different
step and assigned how much time it takes to go through each step. All someone
needs to do is enter in all of the steps that a part will go through and it
calculates how long it will take. My problem is that the formulas are based
on a 16 hour work day and not 24 hours. How can I change this?

Here is the formula

=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),IF(WEEKDAY(D20,1)=6,(ROUNDDOWN(D20,0)+2.3333 33+VLOOKUP(A21,'WORK
STEPS'!D$2:E$39,2,TRUE)),(ROUNDDOWN(D20,0)+0.33333 3+VLOOKUP(A21,'WORK
STEPS'!D$2:E$39,2,TRUE))),D20+VLOOKUP(A21,'WORK STEPS'!D$2:E$39,2,TRUE)))


Thank You

Scott