### Title

Going To Another Field If Blank

### Post

I have 15 fields for alculating times, each building on the previous and that works good. But, all of the fields may not be used, sometimes maybe on the first 4 or 6 fields. How would I make the calculation stop if the previous field was empty and go to a specified field?

An example would be the first 5 are used and have times in them, the 5th field is blank so the DEP field needs to calculate the time from field 5.

The calculation that I have written works for the current field, but not on the follwing fields.

Thanks for any help and/or comments.

Craig

Wanted to clarify the above.

Currently the Time field looks at the Timepoint field and determins a time based on the previous time and a set time between these two points.

As long as there is something in the Timepoint field, the calculations will continue down for each Timepoint.

What I'm trying to do:

If Timepoint 6 in the top example is blank, the Time field should jump to the Next Depart Time. There a calculation will add predertimed minutes to the last Timepoint Time (Timepoint 5 in this example). If Timepoint 6 is not empty, continue with the calculation.

As in the second example, Timepoint 8 is empty, so the Time field from 7 should jump to the Next Depart Time and and to that calculation.

Basically, if the next field is empty go and do the calcualtion in the Next Depart field. If the next field is not empty, continue with that calculation. And so on.

I hope this Clarifies what I am trying to do.

Thanks,

Craig