Best,
I have an employee roster where I want to have dates filled in for a specific shift based on another sheet. Now Vlookup shows the first best match, however, the idea is that based on today's date these dates are filled in. In short:
The particular person's schedule should be shown...
Hello everyone.
I would like to create a button which when pressed should Create 12 New Sheets, each named after a month (JANUARY, FEBRUARY, etc) and each sheet should have the same appearance modeled after this one...
Hello guys!
In an Excel spreadsheet, I have two sheets, 'Workers' and 'Shift'.
I need one worker from each sector based on the 'Workers' sheet to be scheduled per week (52 weeks) if there is more than one.
If there is only one consultant, he must be scheduled weekly, if not, I would like the...
I am using Office 365 / Microsoft Forms to collect information from users within my organization (i.e. sign in is required to fill up the form).
Let's say the goal is quality control, and a bunch of widgets are assigned to colleagues to test and rate. A specific widget (identified by...
I would like cell IJK3 highlight itself at 20:00 then IJK4 become highlighted at 20:20 and for IJK3 to go back to being not highlighted at 20:20. At 20:40 I would like IJK5 to become highlighted then IJK4 to go back to being not highlighted. At 21:00 I would like for IJK6 to be highlighted and...
I'm looking to have row A highlight certain cells when a duplicate value is added into row I. Attached is what it looks like now I have taken off the date, I'm looking to learn excel better so if someone could post a formula that would do so and explain the values in the formula and what they do...
Hello, I'm looking for a formula that would turn a cell a certain color (the intricate part is I need it to read a code from another formula where the name that will be placed which will be in a different spot everyday will look up a certain code like AA. If the name does not have an AA beside...
In excel I would like to enter a formula under the employee number column that when I enter an employee number it will auto populate the employee's name, position and skill code. All of these are on another sheet in the workbook Ie: employee number is column B, name is column C, position is...
Hi!
This is my first post here and I am sorry if the question has already been asked and answered. Couldn't find anything for this.
Anyways!
I can't figure out how to get the % total of hours worked. The formula for total is: =SUM(L85:R85) ,for example. How do I make that into percent if a the...
Hi All,
Majority of our staff work a rotation of 6 weeks on and 2 weeks off.
We have multiple teams, that work multiple different schedules (Mon - Friday vs 3 -2-2 vs Tue - Sat, etc).
This obviously does not change whether or not they are here.
I can build the schedules as recurring and...
Hi i am wondering if it is possible to calculate the hours worked in a day if the start time and end time are in the same cell in this format
Example
C D E
1
2 12th 13th 14th
3 Monday Tuesday Wednesday
4 9:00-6:00...
Hi,
I am trying to help my area identify staffing counts on a schedule created before I came over. I have included a very consolidated version of it as an example as the full version is roughly 900 rows (06/06/20 - today). Basically, each section is a 5-week rotation, and each of the 5-week...
Hello there! I have an NBA Fantasy spreadsheet which I use for scheduling and analysis.
There are 5 basic positions namely: PG (Point Guard), SG (Shooting Guard), SF (Small Forward), PF (Power Forward), C (Center). A player can have 1 or more designated positions. For example, Steph Curry is PG...
Hi,
I am using a simple google sheet that lets me schedule calls to clients after x number of days from a start date. Some dates fall on the weekends and I was wondering if there is a way for the date to adjust automatically to avoid a weekend. If the date falls on a Saturday, it would be...
I am creating a schedule within excel with days along the top, time down the left and activities populated in the table. The column headers/dates are not stored as dates, but as unique values based on our calender (e.g. Week 1 Mon, Week 1 Tue). I would like something that means if I type in...
Hello Everyone!
I am a stage manager for a live entertainment production. I have implemented a new scheduling system called Virtual Callboard and am hitting a few obstacles with trying to convert the old system to the new one.
When I create a draft schedule to send to managers to review before...
Ok just throwing it out there for all you experts as I am not one.
I want to be able to randomly generate a schedule for my employees.
Basics...Each employee works 4 days a week but not necessarily in a row and 1 of the 4 days must be a Sat or Sun but not both. Each day there are 2...
We have a 32-man golf trip that is split up into 2 teams of 16. We play 4 rounds. I am trying to come up with a schedule where everyone has a different partner all 4 rounds, and everyone will play against different people on the opposing team over the 4 rounds (8 in total), with no overlap or...
I work for a small company who manufactures kitchens in Oxfordshire. We work on the basis of being able to make 9 kitchen units per day, 4 days a week - so a kitchen that has a total of 27 units would take 3 days to complete.
As there are many external factors that can delay or bring...
I have a schedule in sheet1 and a schedule in sheet2. I want to "subtract" the table range in sheet2 with the table range in sheet1. Sheet2 is the "skeleton" of the schedule, and the determined values in specific cells. Sheet1 is the "skeleton table", just with cells added afterwards. So i want...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.