shifts

  1. A

    VBA - get alphanumeric code using date in column header

    Hi again, i am trying to copy a alphanumeric "name" from column A to my source workbook. These names are the usernames of people responsible for particular shifts. <tbody> #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align...
  2. 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...
  3. 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...
  4. E

    Separating Hours Worked By Shift

    I have three shifts that I need to separate hours worked into. Attached is a picture of what I am trying to do it includes the start and end times of the shifts.
  5. C

    Sorting a column that shifts down

    I have two separate fields of Data in this work book. The top one sorts just fine as the first row of data never moves. However, the second field of data shifts down every time a new entry is made into field 1. the formula I have right now is this: With Worksheets("Sheet1") LastRow =...
  6. C

    Calculate if any part of a time range is within another time range.

    Hi, I have a time window for what is considered a night shift, e.g. 0000 - 0559. These times can change wither before or after midnight. I want to supply a start and end time of a numbers of shifts and see if any part of those shifts falls within the hours above. I had tried this formula...
  7. D

    Conditional Formating

    Hi, I am looking to highlight two shifts on a work rota using conditional formatting but am really struggling. The shifts I am looking to highlight are 2pm to 10pm and 3pm to 11pm. How can I achieve this please? Thanks, Dean
  8. M

    macro shift the row of the selected cell up or down

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /></colgroup><thead><tr...
  9. L

    SUMPRODUCT combining two and more criteria for check

    disregard pls..thx
  10. C

    VBA macro, if text+enter then date+shift row down

    Hi, I am useless and an amateur at VBA and therefore posting this thread :confused: I would like a VBA macro functioning as described below: Only when inserting text in cell C3 and hitting enter, then today's date appears in B3 and the whole row including all data shifts down. Also I would...
  11. W

    Countif with multiple criteria

    Hello! I'm running a file where I put down the number of hours an employee worked on a certain day - I then color-code it to differentiate between night and day shifts. I'm using the colorfunction for that. I then run a count to calculate how many men worked on day shift and night shift -...
  12. S

    Extract column data by date

    ON spread sheet 1 I have a row of dates lets say B1:AB1 In A2:A8 I have a list of names. In the cells B2:AB8 are letters representing shifts On Spreadsheet 2 I have the same list of names In B1 I want to enter a date the matches one of the dates on spreadsheet 1 in B2:B8 I want to see...
  13. ADAMC

    conditional formattings throws out cell text alignment

    Hi all, Not a major issue but can anyone tell me why if I apply conditional formatting my cell alignment shifts to the right from centre? B2 is a formula: =SUM(Demand!$O2:$Q2) B3 conditional format is =AND(C2 < B2 ,C2 <> " ") - GREEN Formatting is aligned centre but as soon my conditional...
  14. T

    Work schedule calculation

    Hi! Hopefully someone can push in the right direction with my excel problem. Attached is a sample of my spreadsheet. It is a work schedule for several persons on several different work shifts, all with different lengths. My goal is to add a overview for each person with the total number of hours...
  15. S

    Formulas for pulling data from volunteer shift log

    I am tracking volunteer shifts in a spreadsheet that looks like this: https://photos.google.com/share/AF1QipMOq5rwav97YO-4M2mUR4j7Hk-I47dtfqrPpdrHdy-ANzY7Fddw5VqUSRqKUrtZ-w?key=cXhJblNNd2dyN0g3OVZ3ZFBVeVpzbGdJdWxuUjN3 I want two forumulas: 1- A formula that identifies the most recent date on...
  16. D

    Conditions Based on system time.

    Hello, My goal is to have a condition based on time: if the system time is 7:00 AM to 3:15 PM "First" would display in the 4th row of column P. However if the time is 3:15:01 pm - 11:15 pm "Second" would be displayed, and "Third" would follow if the time was 11:15:01 pm - 6:59:59...
  17. C

    Calculate Number of Employees Who Were At Work Each Hour?

    I have been all over trying to figure this out. I attached a link at the bottom of this post to one discussion that was helpful but didn't solve my problem. I need to know how many employees I have working each hour of the day based on a 24/7 business with swing shifts and graveyard shifts...
  18. T

    Annual work rota on Excel

    Hi I have just completed a work schedule for 2018 January to December. I have used the count if formula to count the total Holidays, total shifts, and sickness for each month. I need help as I need to count shifts for 4 weekly pay period as suppose to monthly. not sure if this is...
  19. S

    Help with error if missing a scheduled position on a shift

    hello ive been trying for years to get an answer on this: This is what i would need help with. i have the following shifts on any GIVING DAY REQUIRED. Am cook, Pm cook, am1, am2, am3, pm4, pm 5 & pm6 i would like a formula that if any of these shifts are missing on any giving day a...
  20. W

    change in order

    Hi There This is probably a very simple thing, but I am no excel expert and am wondering if someone could suggest a formula. I have an employee schedule. Some employees have set rotations of shifts and others do not. I have assigned them all a number to start with based on the lines that they...

Some videos you may like

This Week's Hot Topics

Top