I missed one part of the problem:
If the finish time is after 1 pm, we need to add an hour (to account for the
lunch hour in the working day)
=IF(A1-INT(A1)+(A2-8*INT(A2/8))/2413/24,A1-INT(A1)+(A2-8*INT(A2/8))/24+1,A1-INT(A1)+(A2-8*INT(A2/8))/24)
--
- K Dales


"K Dales" wrote:

Assume starting date/time (e.g. now) is in cell A1, number of hours to work
is in A2:

Completion date formula:
=WORKDAY(A1,INT(A2/8))
Completion time (if you want it):
=A1-INT(A1)+(A2-8*INT(A2/8))/24
explanation: A1-INT(A1) gives the time (decimal) portion of a date/time value.
INT(A2/8) gives the integer number of days in the work hours
A2 - (integer days) gives the number of extra hours to work
Divide that by 24 to turn it into a decimal amount equivalent to 1 hour in
Excel's equivalent date/time value (1 = 1 day, so hours/24 = fractional day)
--
- K Dales


"Eric" wrote:

Does anyone know how to project the due date according to a required number
of working hours? such as

If today is 24 Oct, 2005 (Monday) at 9:00am, my project required 100 hours
to be finished, then how to create a formula and to project the due date in
excel sheet?

Working hour: 9am - 1pm and 2pm - 5pm (total 8 working hour per day)

Thank for any suggestion
Eric