#1
|
|||
|
|||
Control Time Calculaiton depending on whether line is running or not.
I have a schedule that tracks when parts should be off the line. How can I add another function to my time to allow for gaps in time depending on whether a line is actually running or not. Line 3 will not run on 1st shift but will run on second shift. I have added a simplified spread sheet to provide a better idea of what I am doing. Last edited by rdperry11; 02-24-2015 at 09:52 PM. |
#2
|
|||
|
|||
When do the shifts start?
|
#3
|
|||
|
|||
Sorry didn't notice there was a reply...
the shifts are 7a-3p, 3p-11p, 11p-7a |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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) |
Thread Tools | |
Display Modes | |
|
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 |