Hi All,

I'm trying to work out a formula that shows how long a person has been waiting for an appointment. Essentially I'd like column c to be a "live counter" based upon today's date, ignoring any appointments that are not attended in columns e/h/k and only 'stopping' once a person has an attended appointment be it their 1st/2nd/3rd appointment that is attended. I'm close(ish), but I just don't seem to be able to quite get it sorted.

Any help would be gratefully appreciated. I hope I've explained myself but if not please do ask

Demo waiting times.xlsx

Rich