1. PhBarreto

    How to create work shifts based on these conditions?

    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...
  2. 4

    VBA - Dynamic Cell Shifting

    Hello, all! I've been searching all over the web to find an answer to this, but I can't seem to find anything. I hope I'm able to explain properly what I'm encountering: I created a budgeting tool for my coworker. It consists of four sections: AR, POs, Overhead, and AP. There are 10 columns of...
  3. Kzantip974

    Scheduling - Create planning based on employee productivity

    Hi community, I hope you are doing well. I am working on a cool project to build cost-efficiency through better scheduling based on our staff productivity. CONTEXT - We are a pizza delivery company, employing drivers to deliver pizzas. - We proceed to schedule driver planning on a weekly basis...
  4. G

    VBA Select Range and Move based on conditions

    Hi All, I am looking for some help on VBA to Select Range and Move based on conditions. I would like to move all the contents between "Project A" and "Project B" one column to the right. Same with all contents between Project B and end of table which will also move 1 column to the right. This...
  5. J

    how to fix an excel 2016 sheet with bad navigation

    CTRL + Shift + up and CTRL + Shift + dn only moves one row. I am using sticky keys & Win 10 on an Asus ROG gamer.
  6. B

    Update excel value based on day of the week

    Hi, I'm creating a spreadsheet with a list of all my employees, however rather than updating their availability daily, is there a code so that their shift is updated depending on the business day within every 2 weeks? Ex: Employee A is off on the 1st and 2nd Wednesday every 2 weeks, so when...
  7. C

    Assigning work to people by day

    Good afternoon, I download a spreadsheet once a month that contains workorders for a given department. The workorders are divided up by responsibility and by the activity code. We then assign the correct employee and shift to the workorder (manually right now). In Power query I have the table...
  8. D

    Conditional Format based on time difference

    <tbody> Employee ID Name Start Finish 161 Paul 10/08/2019 23:00:00 11/08/2019 06:00:00 100 Fred 10/08/2019 23:00:00 11/08/2019 06:00:00 224 Jane 11/08/2019 10:00:00 11/08/2019 18:00:00 100 John 11/08/2019 15:00:00 12/08/2019 03:00:00 161 Paul 11/08/2019 16:00:00 12/08/2019 02:00:00...
  9. K

    How to add AM/PM to a cell

    I have an excel spreadsheet which I am trying to improve. One of the columns is based on whether a shift was a morning shift (AM) or an afternoon shift (PM). currently it is using a data validation and I have to pick from a drop down list. Is there a formula that automatically inputs either AM...
  10. D

    Possibility of calling external Fingerprint program

    Hi, I'm working with several freelancers to develop a simple excel based inventory system with fingerprint authentication. The general workflow of this app is : 1. Assuming there are 3 shifts per day, A, B, C 2. Employee A inputs data for Shift A in Sheet A 3. When changing shifts from Shift A...
  11. A

    Conditional formatting based on the table value

    Can i have a table of conditional formatting color buttons that change as the color of the cell of other table changes Example : I have two tables (1). shift table and (2) status table 1. Shift table is the monday-friday table with 3 shifts of 8 hours each and each shift is divided into 4...
  12. K

    Help with data extraction

    So basically we have set up electronic cover sheets and the formula I am looking for is when i am putting names of the bank staff covering the shift i want the corresponding ward to appear above the bank person's name. Anyone help?
  13. M

    Conditional Formatting On Multiple Ranges

    Hi, Can you please help me with conditional formatting (highlight both cells) as with the below example to highlight the name "Mary" in the "NAME and "Qty" Columns on ranges A3:B7, C3:D7, E3:F7. I'm new here and its my first ever post,Thank You in advance. <tbody> SHIFT 1 SHIFT 2 SHIFT 3...
  14. N

    Is this beyond Excel's capabilities?

    Hi all! I have come here several times in the past to find excellent help with my spreadsheets but I am thinking that I may be looking for something beyond the scope of Excel. I have been asked to take over my department scheduling and I am looking for a solution that will replace the current...
  15. D

    Shift name based on timestamp

    Hello I am trying to get a shift name based on a timestamp in a different cell. For example if my timestamp says "6/19/2019 13:41:37" I want the word "First" to show up in the next column to identify the shift name. I have searched and searched for an answer to this and cant seem to find it...
  16. D

    MIN Formula

    So i need to extract time from a 2 cells, clash against a date and return a sum so Column D = Name D2 = John Smith Column E = Shift Total Hours E2 = 08:00 Column F= Shift Date F2 = 06/01/2019 F3 = 07/01/2019 Column I = Name I2 = John Smith Column J = Absence Start J2=01/01/2019 08:00 Column K =...
  17. K

    How to make shift for the decimals

    if I have two columns, let me assume its name as X and Y. The X column has decimals in every cell value. --> I want to make the X values as integer numbers by adding the decimal part to the next cell value until the end of the column. --> sure the decimal part present a percentage from the...
  18. M

    Calculating exact shift times and rates per shift.

    Hello, I am trying to find a couple formulas to extract the amount of hours worked on each shift. Time is entered beginning and end of a shift and may include a portion of all 3 shifts. 1st shift is 6am - 2pm, 2nd shift is 2pm - 10pm, 3rd shift is 10pm - 6am. Example if I punch in at 5:45pm and...
  19. M

    Complex Staffing Formula

    I'm putting together a spreadsheet that determines how much staffing we need to bring in. Row 5 contains permanent data showing how many people are needed to run a certain line. Row 7 and below show how many hours the line will be running each shift. I'm using the following formula to determine...
  20. D

    Calculate Units Picked 17:00 - 04:00am (Shift)

    Hi, I have created a Data Model from a block of data. The warehouse guys work from 17:00 to 04:00 daily, what's the best approach to obtain the units picked but displayed in one pivot table? I can achieve this over 2 pivot tables using filters but ideally I want this in one table. Each shift...

We've detected that you are using an adblocker.

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
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 "".
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.
Go back