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)