Perhaps something along the lines of the attached file.

Attached Files

Calculating turnaround times in excel.xlsx (15.1 KB, 64 views)

thanks for that, it does indeed look good, just to confirm that it will include saturday and sundays and allow me to exclude only the dates that i want?

what i currently have is

=NETWORKDAYS(C7,C8,B2:B5)+(TEXT(C8,"HH:MM")-TEXT(C7,"HH:MM"))-1

however this just does monday/friday and excludes saturday and sundays anyway which i do not want it to do