+ Reply to Thread
Results 1 to 9 of 9

macro to assign break and lunch schedules based on an 8hr shift

  1. #1
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 365 (Newest version)
    Posts
    246

    macro to assign break and lunch schedules based on an 8hr shift

    Does anyone know a macro that can automatically assign a break and lunch schedule to an 8hr shift?

    I have 29 employees working one shift which is from 10am to 7pm..I want a macro that can look at that shift and assign 2 15min break and 1 45min lunch however I want no more than 4 employees having the same breaks and lunch.

    Is that possible?

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: macro to assign break and lunch schedules based on an 8hr shift

    Yes, but you need to provide example sheets of what your data looks like and what you want it to look like after the code runs. "a macro that can look at that shift" is too vague for anyone to give you concrete help.
    I'm interested in starting a career working with VBA, if anyone knows of any opportunities!

  3. #3
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 365 (Newest version)
    Posts
    246

    Re: macro to assign break and lunch schedules based on an 8hr shift

    Thanks much, I've attached the sample file....

    If you need any more details please let me know...your help will be greatly appreciated.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: macro to assign break and lunch schedules based on an 8hr shift

    What is the allowed range for each break/lunch? Within that range, can the break start at any given minute? or should they start at quarter hour increments? Or...?

    It would be helpful if you said something like: "First break can start at 11:30, 11:45, or 12:00", or "First break can happen at any time between 12:00 and 1:00" etc. etc.

  5. #5
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 365 (Newest version)
    Posts
    246

    Re: macro to assign break and lunch schedules based on an 8hr shift

    1st break should start at an hour and 45 minutes of the shift. it can start between between 11:45 and 12:45.

  6. #6
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 365 (Newest version)
    Posts
    246

    Re: macro to assign break and lunch schedules based on an 8hr shift

    First break can start at 11:45

  7. #7
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 365 (Newest version)
    Posts
    246

    Re: macro to assign break and lunch schedules based on an 8hr shift

    Anyone have any ideas about a macro....it will be greatly appreciated.

  8. #8
    Registered User
    Join Date
    01-20-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    2

    Re: macro to assign break and lunch schedules based on an 8hr shift

    I need similar help ,

    Can anyone help on this..

    Thanks in advamce...

  9. #9
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,108

    Re: macro to assign break and lunch schedules based on an 8hr shift

    Quote Originally Posted by imrajesh23 View Post
    I need similar help
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    This is an old thread. You will have better luck starting a new thread. Attach a copy of your file.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Lunch & Break Timetable
    By ayrshiredj in forum Excel General
    Replies: 1
    Last Post: 06-08-2014, 12:19 AM
  2. lunch break times
    By exodus27 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-11-2014, 06:48 PM
  3. Can't pull someone's lunch and break at a given time
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2013, 09:01 AM
  4. How to subtract 30min lunch for night shift.
    By jz75455 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-14-2013, 06:29 PM
  5. Need help with VBA, summarizing break schedules
    By jamazi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 05:04 PM
  6. reducing the 30 minute lunch break from a shift
    By mvgajr in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 05-25-2012, 10:29 AM
  7. Subtracting lunch breaks from different shift times
    By badger in forum Excel General
    Replies: 6
    Last Post: 08-31-2011, 12:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1