Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 02-24-2015, 09:35 PM
rdperry11 rdperry11 is offline Control Time Calculaiton depending on whether line is running or not. Windows 7 64bit Control Time Calculaiton depending on whether line is running or not. Office 2010 64bit
Novice
Control Time Calculaiton depending on whether line is running or not.
 
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
 



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
Control Time Calculaiton depending on whether line is running or not. 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
Control Time Calculaiton depending on whether line is running or not. 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

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft