1. 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...
  2. 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.
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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?
  10. 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...
  11. 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...
  12. 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...
  13. 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 =...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. R

    how to shift the cells to left to fill blank cells

    Hi, I would like to fill the blank cells by shifting cells to right. I found the solution "Make sure you only have a single cell selected. Press F5 Click the "Special..." button Select "Blanks" and click OK Right click and select "Delete..." Select the "Shift cells left" option and press OK...
  19. S

    Linking vs Connection

    Hi all Just a bit of a general info required really. At work I have read only access to 2 work books. Both of these are staff rotas. There are a myirad of shifts, shift lengths, shift times etc etc… Both these workbooks are just filled in manually with no useful information when...
  20. E

    Calculate Night shift between 2 times

    Hello, I'm having trouble with a formula considering the work as night shift. The formula works fine untill it reaches the AM values. I'll post a picture: the formulas I have in there are: C6 =(($F6>$G6)*MEDIAN(0,$G6-$H$5,MEDIAN($H$5,$F$5))+MAX(0,MIN($F$5,$G6+($F6>$G6))-MAX(1/4,$F6))) D6...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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