View Single Post
  #1   Report Post  
Qaspec
 
Posts: n/a
Default Work Hours Time Question

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.