Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-24-2015, 02:20 AM
rdperry11 rdperry11 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2015
Location: Ohio, USA
Posts: 6
rdperry11 is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Account for shifts 2.xlsx (11.1 KB, 5 views)

Last edited by rdperry11; 02-24-2015 at 09:52 PM.
Reply With Quote
  #2  
Old 02-24-2015, 07:02 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

When do the shifts start?
Reply With Quote
  #3  
Old 02-24-2015, 09:20 AM
rdperry11 rdperry11 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2015
Location: Ohio, USA
Posts: 6
rdperry11 is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
When do the shifts start?
Sorry didn't notice there was a reply...
the shifts are 7a-3p, 3p-11p, 11p-7a
Reply With Quote
  #4  
Old 02-24-2015, 11:18 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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?
Reply With Quote
  #5  
Old 02-24-2015, 09:35 PM
rdperry11 rdperry11 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2015
Location: Ohio, USA
Posts: 6
rdperry11 is on a distinguished road
Default

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)
Reply With Quote
Reply

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


All times are GMT -7. The time now is 02:05 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft