Any ideas on if my approach is completely wrong, or if there are different ways I should approach it. I realized that I am probably approaching this all wrong and there might be other, easier ways to do this. I also think using If functions is probably not very efficient. So in the template it would look as if employee 1 ended at 4:30pm. Also It didn't differentiate from starting and ending hours so if I put that employee 1 ends at 4pm, it will fill out the 1600-1630 slot. This only partially worked as it could fill out the starting hour and the finishing hour but it didn't fill everything in between. I am not very savvy with excel so initially I just started out with using a bunch of If functions and if the timing and role matched it would input the employee's identifier tag in the time slot. What I would want is for excel to automatically take my inputs from the second sheet and apply it to the template to create a 24 hour schedule which I can easily give to my colleagues. My plan is to have the schedule template in one sheet which has all the different roles and work hours ( example pic attached) and then on another sheet have a table of all the employees' names (as well as an identifier to fit in the template), the role they'll be doing and the hours they'll be doing ( example pic attached). My job has several roles and all of the employees take turns doing the roles. I want to make a schedule for my job and I want to use excel to automatically fill out the schedule to the template based on some inputs. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |