Grrr.
Normally, I overcomplicate things. This time, I undercomplicated the problem. Once I saw what was causing the problem, it was easy enough to fix. (I was not checking that the vehicle departing was the same as the one that arrived - if vehicle A arrived at 0700, and left at 0800, it was counted. If another subsequently arrived and left at 1100, I had not checked that it was the same vehicle that had arrived at 0700). I deleted two of the Named ranges, as they are notrequired. So, with a red face, I have now cross-checked my formula as well as I can. I am now confident that we're there. It might be an idea to keep the cross-checking formulae as an ongoing QA measure.
Bookmarks