Quote Originally Posted by humdingaling View Post
does this work for you?
that seems to have worked thanks very much, would i be able to dump in data in the same format into the first 3 columns (staff, start and end) and the formulae will pick up the rest?