I am using a spreedsheet that automadicly calculates the time it takes to
complete several task. On a separate work sheet I have entered in the step
along with the amount of time to perform each step to come up with the total
time. If we start at 7:00pm on 7/10/07 it list when the parts will be at the
next step and then the subsequent steps. So if we go through 7 steps we will
finish at 2:30pm the next day. My problem is that the formula was oringinally
written for a 16 hour work day so after mid-night it will not start tracking
time until 8:00am.

Attached is the formula:=IF(A21="","",IF(AND((MOD(D20,1)+(VLOOKUP( A21,'WORK
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)))


Can someone help me change this to 24 hours?


Thanks


Scott