+ Reply to Thread
Results 1 to 10 of 10

Closed

  1. 06-16-2023, 02:35 AM #1
    SusyTheCat
    SusyTheCat is offline
    Registered User
    Join Date
    06-16-2023
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 365
    Posts
    5

    Thumbs up Closed

    Closed - Closed - Closed
    Last edited by SusyTheCat; 06-20-2023 at 11:29 PM.
    Reply With QuoteRegister To Reply
  2. 06-16-2023, 02:39 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Help with Automating staff schedule in excel

    Welcome to the forum.

    What does this mean in practice?

    Employees have adequate amount of off time between shifts.
    Excel will not understand the term 'adequate' - it will need rules.

    Currently 12 employees with one being part time.
    Define 'part time' for Excel.
    Last edited by AliGW; 06-16-2023 at 02:41 AM.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 06-16-2023, 02:40 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Help with Automating staff schedule in excel

    Another question: on which day does this shift start?

    AliGW on MS365 Beta Channel (Windows 11) 64 bit

    Y
    Z
    AA
    AB
    5
    Friday
    6
    07-Jul
    7
    2145 hrs
    615 hrs
    Sheet: Sheet2
    Reply With QuoteRegister To Reply
  4. 06-16-2023, 03:10 AM #4
    SusyTheCat
    SusyTheCat is offline
    Registered User
    Join Date
    06-16-2023
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 365
    Posts
    5

    Re: Help with Automating staff schedule in excel

    Closed closed closed removed
    Last edited by SusyTheCat; 06-20-2023 at 11:30 PM.
    Reply With QuoteRegister To Reply
  5. 06-16-2023, 03:15 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Help with Automating staff schedule in excel

    Thanks.

    You need to decide on PRECISE rules (if this, then that, or if that, then the other, etc.), as Excel needs it spelling out. Anything even slightly vague cannot be programmed, as Excel has no AI. Your descriptions at the moment are both open to interpretation.

    I suspect this will require VBA - are you OK with that?

    Finally, there is no Excel version 2023: please update your profile to the version you have (Excel 2019, Excel 2021 or Excel 365).

    Thank you.
    Reply With QuoteRegister To Reply
  6. 06-16-2023, 03:35 AM #6
    SusyTheCat
    SusyTheCat is offline
    Registered User
    Join Date
    06-16-2023
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 365
    Posts
    5

    Re: Help with Automating staff schedule in excel

    Closed closed closed removed
    Last edited by SusyTheCat; 06-20-2023 at 11:30 PM.
    Reply With QuoteRegister To Reply
  7. 06-16-2023, 03:38 AM #7
    SusyTheCat
    SusyTheCat is offline
    Registered User
    Join Date
    06-16-2023
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 365
    Posts
    5

    Re: Help with Automating staff schedule in excel

    Also, two days off during the week for each employee. (The exception with part time). I'm new to VBA.
    Reply With QuoteRegister To Reply
  8. 06-16-2023, 03:39 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Help with Automating staff schedule in excel

    OK - I am going to modify the title to flag this to VBA experts as well. It's above my pay grade, though, so good luck!
    Reply With QuoteRegister To Reply
  9. 06-16-2023, 03:44 AM #9
    SusyTheCat
    SusyTheCat is offline
    Registered User
    Join Date
    06-16-2023
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 365
    Posts
    5

    Re: Help with Automating staff schedule in excel (365 functions or VBA?)

    No problem! I appreciate your time. Don't want to force anyone to a difficult task but I'm thankful for the community volunteering!
    Reply With QuoteRegister To Reply
  10. 06-16-2023, 03:47 AM #10
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Help with Automating staff schedule in excel (365 functions or VBA?)

    It is a tricky one, but someone may have an idea. Bear in mind contributors are all over the world, so give it at least 24 hours!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Staff Schedule Broken down into Daily
    By northernwarrior in forum Excel General
    Replies: 2
    Last Post: 09-19-2020, 07:32 PM
  2. [SOLVED] Need help with formula for Automating the Staff Roster
    By L3o in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2017, 08:52 PM
  3. Use excel forum to create roster/staff schedule
    By Throughstream in forum Excel General
    Replies: 1
    Last Post: 02-27-2017, 09:05 PM
  4. Creating a Staff schedule
    By Kotov-Syndrome in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 06-14-2015, 05:07 PM
  5. [SOLVED] Weekly Staff Schedule
    By nancyching1711 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2012, 11:14 AM
  6. Weekly Staff Schedule
    By nancyching1711 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2012, 03:30 PM
  7. [SOLVED] staff schedule in excel
    By Lonny in forum Excel General
    Replies: 1
    Last Post: 05-15-2005, 01:06 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1