Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2012, 05:23 AM
freeman freeman is offline Noob here - I need a shift calendar by days with count of shift. Windows 7 32bit Noob here - I need a shift calendar by days with count of shift. Office 2007
Novice
Noob here - I need a shift calendar by days with count of shift.
 
Join Date: Sep 2012
Posts: 8
freeman is on a distinguished road
Default Noob here - I need a shift calendar by days with count of shift.

Hello everyone, I am sorry for the noob question but maybe someone could do this in a minute rather than me in 8 hours.

I need to have a date and shift formula to appear when I place a start date and shift.



For example lets say my company is working 3 shifts 8hours each, 1st 2nd and 3rd.

We run various parts some take 9 shifts others take 1 shift and some could take 3 and or 4 shifts etc... varies from part to part day to day.

I would like to enter the day and shift starts, and the number of shifts it takes to finish. I would like the outcome to be the next start day and shift for the next part.

So if I start 9/7 on 3rd shift, and it takes 4 shifts to run, the next day we would start the next part would appear as 9/8 2nd

and if that 9/8 2nd shift part took 9 shifts to run (counting starting shift) the next part would start 9/11 2nd shift.

I hope this is enough information to help me. Thank you so much... I also have a more complicated request if you're up for it. I mean it is super hard.

Also we work 7 days a week. Except major holidays... but those should also be calculated in
Reply With Quote
  #2  
Old 09-07-2012, 06:50 AM
Gary Drumm Gary Drumm is offline Noob here - I need a shift calendar by days with count of shift. Windows XP Noob here - I need a shift calendar by days with count of shift. Office 2007
Advanced Beginner
 
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road
Default

You might Google "Production Planning Calculator for Excel" and see what comes up.
It sounds like a rate planner.
Reply With Quote
  #3  
Old 09-07-2012, 06:55 AM
freeman freeman is offline Noob here - I need a shift calendar by days with count of shift. Windows 7 32bit Noob here - I need a shift calendar by days with count of shift. Office 2007
Novice
Noob here - I need a shift calendar by days with count of shift.
 
Join Date: Sep 2012
Posts: 8
freeman is on a distinguished road
Default

Thank you, I am downloading now...

Quote:
Originally Posted by Gary Drumm View Post
You might Google "Production Planning Calculator for Excel" and see what comes up.
It sounds like a rate planner.
Reply With Quote
  #4  
Old 09-07-2012, 10:12 AM
freeman freeman is offline Noob here - I need a shift calendar by days with count of shift. Windows 7 32bit Noob here - I need a shift calendar by days with count of shift. Office 2007
Novice
Noob here - I need a shift calendar by days with count of shift.
 
Join Date: Sep 2012
Posts: 8
freeman is on a distinguished road
Default

No luck... sorry... if anyone could maybe help...
Reply With Quote
  #5  
Old 09-07-2012, 02:06 PM
freeman freeman is offline Noob here - I need a shift calendar by days with count of shift. Windows 7 32bit Noob here - I need a shift calendar by days with count of shift. Office 2007
Novice
Noob here - I need a shift calendar by days with count of shift.
 
Join Date: Sep 2012
Posts: 8
freeman is on a distinguished road
Default

This is what I have and I am stuck on the fact that it is calculating the day as 24 hours instead of as a shift of 8 hours. Could someone please take a look and adjust.

I need to enter the day, the time a shift starts, how many shifts it takes, then calculate the start and final day and shift.

Thanks
Attached Files
File Type: xlsx Calculate Days for Forge.xlsx (8.8 KB, 10 views)
Reply With Quote
  #6  
Old 09-10-2012, 05:28 AM
Gary Drumm Gary Drumm is offline Noob here - I need a shift calendar by days with count of shift. Windows XP Noob here - I need a shift calendar by days with count of shift. Office 2007
Advanced Beginner
 
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road
Default

Something like this?
Attached Files
File Type: xlsx Calculate Days for Production on Forge(1).xlsx (11.6 KB, 12 views)
Reply With Quote
  #7  
Old 09-10-2012, 05:55 AM
freeman freeman is offline Noob here - I need a shift calendar by days with count of shift. Windows 7 32bit Noob here - I need a shift calendar by days with count of shift. Office 2007
Novice
Noob here - I need a shift calendar by days with count of shift.
 
Join Date: Sep 2012
Posts: 8
freeman is on a distinguished road
Default

Quote:
Originally Posted by Gary Drumm View Post
Something like this?
Thanks, I was just tinkering and discovered, our third shift starts the day, so our day schedule is for example

What I need to do is place a start date the line will run, the shift it starts, and the number of shifts it takes to complete - not factoring in lunch (shifts are 8 hours) and should be calculated as such.

The end result will be the day and time (next shift in sequence) the part should be loaded on to the line.

I know this sounds like a production schedule, but it isn't... I don't need anything that complex.

Example... our schedule is done as 3rd shift as the start of the day, so if I start at 11pm (23:00) on day A 9/5/12 and end 9/7/12 at 11pm so the next run will be 9/8/12 7am (first shift) so I ran for 7 shifts.

9/5 - 3rd (11pm)
9/6 - 1st (7am) and 2nd (3pm)
9/6 - 3rd (11pm)
9/7 - 1st (7am) and 2nd (3pm)
9/7 - 3rd (11pm)
(7shifts - each shift is 8 hours)

8/1- 1st (7am) - this shift is the start of next part

I have attached the file itself. This is the formula I am using in cell C6 - =A2+B3+((A6)/24)


thanks
Attached Files
File Type: xlsx Calculate Days for Forge.xlsx (10.4 KB, 11 views)

Last edited by freeman; 09-10-2012 at 02:01 PM.
Reply With Quote
  #8  
Old 09-11-2012, 06:36 AM
freeman freeman is offline Noob here - I need a shift calendar by days with count of shift. Windows 7 32bit Noob here - I need a shift calendar by days with count of shift. Office 2007
Novice
Noob here - I need a shift calendar by days with count of shift.
 
Join Date: Sep 2012
Posts: 8
freeman is on a distinguished road
Default

No one can help....
Reply With Quote
  #9  
Old 09-12-2012, 08:45 AM
freeman freeman is offline Noob here - I need a shift calendar by days with count of shift. Windows 7 32bit Noob here - I need a shift calendar by days with count of shift. Office 2007
Novice
Noob here - I need a shift calendar by days with count of shift.
 
Join Date: Sep 2012
Posts: 8
freeman is on a distinguished road
Default

I would love it if someone could offer the code for offsetting a day by one hour.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Noob here - I need a shift calendar by days with count of shift. 5 days/week during planning & 7 days/week during implementation sanlen Project 1 06-25-2012 04:17 PM
Calendar work days in advance paol:o Outlook 4 05-27-2012 07:23 PM
Set calendar alarm x days before end date el_ja Outlook 2 01-19-2012 10:09 AM
Outlook Calendar continually resets days in Day View tecsi Outlook 0 08-11-2010 06:45 PM
Noob questions punktilend Word 0 07-24-2009 02:41 AM

Other Forums: Access Forums

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


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