The following would lookup holidays, but be warned the DLookup will slow the function down
Public Function AddHours(datStartDate As Date, intHours As Integer) As Date
Const intDayStart = 8
Const intDayEnd = 17
Do While intHours > 0
datStartDate = DateAdd("h", 1, datStartDate)
If...