Going To Another Field If Blank
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.