Hi SHG, thanks for the reply.

I did try toying around with Project, but then ran into the issue of being confined to static dates. The added parameter is that a tech may not only work on one project for the entire day, they may travel between location and do 2-3 jobs per day, so it needed an inout based on time as well.

I did try this and it didn't look too friendly for our admin staff, so I went back to try my hand at Excel.

Richard.