Hi,
Assuming:
A1: Start TimeStamp (date+time)
B1: task duration time
holidays: a range of holidays (this is optional)
C4: BegShift (9:00:00 in your case)
C5: EndShift (21:00:00 in your case)
The following gives the ending time of that task:
=WORKDAY(A1,ROUND(B1/(C5-C4),3)+N(MOD(A1,1)(C5-MOD(B1,C5-C4))),holidays)+(MOD(A
1,1)+MOD(B1,C5-C4)+IF(MOD(A1,1)C5-MOD(B1,C5-C4),C4-C5))
Regards,
Daniel M.
"Qaspec" wrote in message
...
That takes care of the 9 am to 9 pm issue but the workday only stipulation is
still mising. a deadline cannot fall on a weekend.
"LanceB" wrote:
=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.
|