Thanks for this. Have only just got around to applying this and works a treat. You are right really useful. Thanks again.

Yes sorry date format is dd/mm/yyyy. The duration is number of days. The hours are that person's std hours per day * number of days. In this...