|
|
|
|
#1
02-24-2015, 11:18 AM
|
|||
|
|||
On your sheet, you say "the completion time for customer 222 should be 6:30 PM". If the shift starts at 3 pm and they can make 20/shift, wouldn't the order for 222, 10 parts, finish at 7 pm?
Do you want to account for lunch breaks? Do the shifts only run zero or 8 hours? 
|
|
#2
02-24-2015, 09:35 PM
|
|||
|
|||
|
Yes, you are right it would be 7pm. Shifts could run from 0, up to 8 hours. (usually lines run 2hrs, 4hrs, or 8hrs)
When I did it in my head I was thinking start time at 6:30am and added the hours from there. 6:30 is just when I update the schedule. I won't be accounting for breaks or for lunch. The average time for parts to come off the line will be figured as an average for the whole shift. I will make the corrections to the spread sheet now. (I re-uploaded the spread sheet as Account for shifts 2)
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help - Run-time error 91 - VBA for inserting and formatting text depending on style | mtrborges | Word VBA | 2 | 02-08-2015 11:35 PM |
 How to create a table with a number of line depending a number entered by user
|
Cellendhyll | Word Tables | 3 | 07-10-2014 05:49 AM |
| Newbie has question about running animation for the first time | xsnerg | PowerPoint | 0 | 02-26-2013 11:56 AM |
|
Highlight one line at a time
|
billy589 | PowerPoint | 1 | 10-04-2010 02:33 PM |
| Set text in edit control on inspector window indicating time Outlook 2007 | saniltalathi | Outlook | 0 | 02-20-2009 08:43 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode