shift

First of all like to say Hello to everyone i am a new here so please be patient with me LOL and at 67 takes a little longer for things to sink in ;) i have just done a sign in sheet for work staff and i have a command button that puts in the date and time of start of shift and the same for...

I have a shift schedule with symbol and legend with duration value of each shift symbol. I want to summarize the value corresponding to the symbols for each employee. Now I use: =COUNTIF($D5:$AH5;$A$13)*($N$13*24)+COUNTIF(D5:AH5;$A$14)*($N$14*24)+COUNTIF(D5:AH5;$A$15)*($N$15*24) where D5:AH5 is...

Hi everyone. I'm having a hard time trying to sort out an Excel VBA. I need to search column D and if there is not an @ symbol anywhere in the cell, shift the rest of the row to the right 1 cell and empty the cell without the @ symbol. I'm looking to see if the cell has an email address, if it...

I run a report giving me the shift patterns of colleagues. I need to break down what shift pattern they are on so forexample we have the following. So in the 1st columns I have in A 1and then in B & C I have those starting 1 then 2 in B and in C will bethose starting on 2 then 1 and then the 3...

Hi All New to the forum but hopeful someone can help. This is a wok project I have been tasked with but it has me beat. We process payroll weekly but during overtime season it becomes a bit of a pain as our T&A system doesn't deduct a break when employees have done the required amount of...

Hi i'm trying to figure out how to write a formula that would look at a shift start time and based on that time would output the correct shift premium to the cell. So I have 3 scenarios a start time from 05:00 to 13:59 no premium. 14:00 to 21:59 .75 cents per hour and lastly 22:00 to 04:59...

Dear All Could you please advise a VBA code or Excel advanced functions to automatically shift entire rows from one area to another. What I mean by area - is that I have 3 areas with 3 different color depending on certain cells values or status of the row. So once a certain cell is updated...

Good morning all I use a spreadsheet to do my shift updates at work but I am finding the other shifts are entering false hours to make things look good. So what I would like to do is pull the hours from the start time and finish times the issue I am having is some production runs finish a...

Hi, I have a row of shift patterns in cells in cells d33:k33, expresses like this - "0900 - 1700" i also have a secondtable that lists the shift pattern in column 1 and the number of hours forthat shift in column 2 (so for "0900 - 1700" you get 8, and for "0900 - 1300" you get 4... I want to...

Hello all, I am new to this forum, but not new to excel/VBA. I have a problem that I can't seem to work out in my own head, and I believe it's a very simple one which makes it all the more frustrating to me. I have developed rotating shift schedules for my workplace for 6 different...

I am trying to calculate percentiles using an if clause. For exI. want to calculate the 5th percentile weight for all of the women age 19. I am not sure how to write this formula out, also not sure what ctrl shift enter does for arrays? any help appreciated

Hello - looking for some help / advice on the following. I have added an iferror to my index match to return results of 0 as blank; however, when I control shift copy it picks up all cells with the formula regardless if the cell contains a number or blank. I would like a way to only then copy...

Hi All Need some help please. We are working on 28 day roster. With some off days in between. Then the cycle starts again. It looks like this <tbody> Th Fr Sa Su Mo Tu We Th Fr Sa Su Mo Tu We Th Fr Sa Su Mo Tu We Th Fr Sa Su Mo Tu We T N N N X D D D X X X N N X X D D D D X N N X X X X X X...

Hi all, First time posting. So I am creating a manpower document for our firehouse. The simple explanation of it is, one master sheet that has everyone's names in column A ad monthly dates in rowA A . At the intersections are drop down menus with specific values to designate on shift, off...

I have a spreadsheet where workers can calculate downtime simply by entering the start of the downtime and the end of the downtime. This works great until it occurs before midnight and then ends after midnight. How should the formula go to account for the day? I have a start shift and end shift...

Hello all, I am in the process of rewriting several macros authored by several previous authors. The first of three is launched from a button on an Access form. After the first has run, users are asked to paste data into the .xlsx workbook created by the first macro before running the second...

G'day! I've designed an automation system which purely runs in vBA to 21 roll formers in our factory (mainly) thanks to each of you for helping along the way! However - I've hit which I believe to be a snag. I run an ENDLESS loop - infinite loop. Checking if (batch complete) - "1" is found...

Hello. I have been going thru the payroll videos and I was trying to see if there is a video on shift premiums? Unless I missed it, maybe? I want to find a formula where a special shift premium is added to the employees pay from 7:00 pm to 1:00 am. The employee may actually start their shift...

Hello, I need help with the following please. In row 1 I have a row of currency values, A1 thru A1000. In row 2 I need a formula for each cell B1 thru B? that multiplies its corresponding number in row 1 by a factor (B4), but also looks at A3 to tell it how many cells to the right to shift...

Column A will have time like 09:00 (09:00 is save in text format) Formula in Column B to show Shift one, Shift two or Shift three depending on time shown in column A I tried =if(A1=09:00,"Shift One",if(A1=20:00,"Shift two","Shift Three")) but this formula isn't working. <tbody> Formula to...