8 hour day
 

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?

8 hour day
 

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)




"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?

8 hour day
 

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?

8 hour day
 

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?