8 hour day

[Patty B]

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?

 

[Chip Pearson]

See the first formula at http://www.cpearson.com/Excel/DateTimeWS.htm . It
is a beast, but it works.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[David Biddulph]

What time are your start and finish hours?

 

[David Biddulph]

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.