=IF((A1+(8/24))-INT(A1+(8/24))0.875,A1+(8/24)+0.5,A1+(8/24))

"Qaspec" wrote:

I have a date and time in cell a1-a100 i need a formula in b2 that will
provide me with the date and time it will be 8 hours later(deadline). the
deadline only counts for work hours between 9am and 9pm during workdays
mon-fri only. thanks.