•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating a work schedule visualiser
Our take
Creating a work schedule visualizer can significantly enhance your productivity by providing a clear overview of shift timings. By inputting dynamic work shifts such as 10:00-14:00 or 12:00-18:00 into column A of your spreadsheet, you can utilize conditional formatting to visually map out the entire day. This approach allows you to see shifts filled in across hourly columns, from 08:00 to the end of the day. Let’s explore how to set this up effectively in Excel version 2602, ensuring a user-friendly and intuitive experience.
Hello!
I'd like to take a list of dynamic work shift times, 10:00-14:00, 12:00-18:00, etc, and paste them into column A of a sheet which will visually 'map out' the whole day with conditional formatting. The sheet columns would run from the beginning of the day, say 08:00, hourly, until the end of the day. A shift time of 08:00-12:00 pasted into column A would therefore fill in the cells from column 08:00 to column 12:00.
I'm certain this is possible but my research has turned up nothing but incorrect AI slop.
Excel version 2602
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Wanting to build a check total sheet that references a dynamic calendarI am going to try and Make this as clear as possible but it might be a bit confusing. I am creating a Dynamic Calendar (which it is created and works it seems) to track my work schedule. I work a two week on two week off schedule and I change out on Thursdays. I got it formatted to shade my schedule where I’m at work(not important) and shaded to add extra weeks. I want to create a second sheet that tracks the weeks of work (actually pay periods but both.) Listed as Back, Full and Front Back- is the first week I’m at work Full- well that’s a full week Front- last week or the front half I want column A to be the work week but started on a Monday and the pay period would be the following Friday in column B. Column C would list the type of week and D would be the amount associated with the type of week. My calendar is a grid 3x4 months. from empty first Jan square is B5 and all the way to X37 there is columns and rows spacing each month out In AA4 is the year AA5 is rotation start date AA6&AA7 is days on and off. I have tried using AI I have tried getting it to reference and when I get close the column for Week type does not fill correctly or won’t add an extra week when adding to that boxes or it adds every week possible in the year. I hope that was clear I been messing with it like a day before asking AI. And nothing I do gets it. Either it fills all weeks at full or no full weeks. submitted by /u/Cronenberg_Jerry [link] [comments]
- Creating an auto-populating visual calendar for multiple departments to view?I coordinate student schedules across multiple hospital units. I log the shifts in an hours log spreadsheet (date, start time, end time, unit, student name, etc.). Every month, I need to send each unit a schedule showing who is coming in and when so they can review and plan coverage. Right now, this part is very manual, and does not lend to tracking any data like how many students on each units, hours, etc., which we need as a department. We have over 100 students each month, so as much automizing as possible would be helpful as its a big process. Ideally, I’d like something that: Pulls directly from the hours log (no retyping or copy/paste) Is easy to read at a glance for unit managers Can handle many units, many months, and many students Lets me filter by unit + month I'm not really an excel genius, and I've been using copilot to help me with some of this and formulations, but It's not providing me with accurate formulas for the actual calendar conversion. If there are any resources on what formulas to use, what platforms that I could maybe look into for how to do this, or just honestly any advice at all. We've gotten the data tracking mostly drafted up and it's able to pull from pivot tables and show the analytics, but the calendar is my biggest hurdle at the moment. submitted by /u/JuggernautFlashy6489 [link] [comments]
- Creating an Auto Scheduler for my Work’s DepartmentI realize I may go down a rabbit hole and this could potentially take me months or maybe even longer, but that’s fine I just need starting points for my research. My experience: Not a lot. Limited to extremely basic functions (e.g. SUM, IF, AND, OR), conditional formatting, data validation. Willing to delve into VBN but I know that requires basic knowledge of programming. Goal: There’s ~40 people in my department and we have an excel sheet that tracks all the daily tasks that need to be completed. There’s myself and a manager that makes the schedule for our respective sides of the week and it takes us 2-3 hours each week to assign each task one by one until the schedule is filled out. I would like to automate this in some kind of way. Ideas: - Assign a theoretical/average time to complete a task. - Set each task as either an AM or PM shift specific task, and other tasks that can be completed by either shift. - Assign people to a specific shift, and how many hours their shift is and on what days. - If people have planned PTO, being able to update the available analysts that Excel will take into account. - Excel does the work of auto-populating tasks with a person for each task accounting everything above and not assigning tasks that would cumulatively exceed the number of hours they’re at work, as well as averaging the workload between each person. - Dynamic and editable after cells are auto-populated. Truthfully this is not required, but a quality of life. People call out, emergency situations might come up that might require attention over daily tasks, etc. My thought is I can copy the results and paste it into a separate sheet that can be editable as the week goes on. Again I’m sure I have no idea how much work I’m asking for and it may be way above my capabilities, but as you roast me in the comments at least leave something that I can use to help me get started. Appreciate yall. submitted by /u/GoldJomell [link] [comments]
- Time In Lieu SpreadsheetHey All, I have used Google Sheets forever but my new job uses Office and I am struggling with some of Excel's functions. I'm trying to create a spreadsheet that tracks my time off in lieu (TOIL) so I know where I'm at. I've created the bare bones of the spreadsheet ash shown in the image but I need help cleaning it up. Ideally I would like to have all of the time columns (B:H) only have hh:mm format and then all of the 0:00:00 values that haven't been used not to be shown. In cell L1 I would like it to show the most current level of TOIL, again in hh:mm format. Is this possible or am I asking too much of Excel? Thanks in advance. https://preview.redd.it/c8u5ha2cxszg1.png?width=1001&format=png&auto=webp&s=3985daa3d11541abed488f377c62e375f6ab1224 submitted by /u/Silky_45 [link] [comments]
Tagged with
#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#rows.com#real-time data collaboration#financial modeling with spreadsheets#real-time collaboration#Excel#work schedule#conditional formatting#shift times#visualiser#time mapping#dynamic#daily schedule#time slots#day planning#shift duration#hourly#work hours