In the absence of an answer to my question, try:
=IF(MOD(A1+INT(A2/8)+MOD(A2,8)/24,1)<=B1,A1+INT(A2/8)+MOD(A2,8)/24,A1+INT(A2/8)+1+MOD(A2,8)/24-8/24)

if A1 is the start date and time, B1 is the duration in hours, and A2 is the
time of day for the end of the working shift.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
What time are your start and finish hours?
--
David Biddulph

"Patty B" <Patty wrote in message
...
I have a manufacturing job that will take 10 hours. We work one 8-hour
shift. If i start the job on Monday, May 19, 2008 at 8am I need to
calculate
what day and time it will finish, which is Tuesday at 10am. (8 hours on
Monday and 2 hours on Tuesday). I then need to add the number of hours
for
the next job to complete the schedule the week. Any suggestions?