worked

I'm looking for formula in "Consecutive Days Worked" column that will count consecutive days worked(1=worked 0=not worked). Challenge is employee cant work more than 13 consecutive days, so count needs to start over when it hits a 0, and be tied to current date. Thank you for your time...

Trying to count employee's consecutive days worked (no more than 13, 14th has to be a rest day). Problem is.. count should restart after an absence. 8/1 8/2 8/3 8/4 8/6 8/7 8/8 Consecutive Days Worked In In In In In In In 1 1 1 0 1 1 1 1 1 0 1 0 1 1 0 0 0 0 0 0 0 1...

Hi I know this has been covered a few times and people have posted replies, from which I copied and amended some code which first worked and now does not for some reason. Can anyone help? I have 4 column dependency lists with info in G4, H4, I4 and I4, If any changes are made to G4 I want all...

Any help in this would be greatly appreciated, I am setting up an Overtime Equalization Spread sheet that tracks numerous pieces of data throughout the fiscal year. I. E. If employee worked overtime , if they refused overtime, what shift I was for ( Day Afternoon or Nights) and the reason...

I have a Read-only file and I want to un-Read it so that I can make changes and save them then revert it to Read-only. I have tried the ff codes - but none of them worked.. many thanks ThisWorkbook.ChangeFileAccess xlReadWrite SetAttr ActiveWorkbook, vbReadOnly ActiveWorkbook.ChangeFileAccess...

Hi all, What I am trying to do is count the number of the days worked in the last 14 days. I'm hoping that someone can help me solve how, to sum up, the number of days worked based on the date of another cell. I have got the date cells to highlight in Red if in the last 14 days, but I can't...

Hi all, What I am trying to do is count the number of the days worked in the last 14 days. I'm hoping that someone can help me solve how, to sum up, the number of days worked based on the date of another cell. I have got the date cells to highlight in Red if in the last 14 days, but I can't...

I have a spreadsheet that I’m using to calculate hours worked. column headings are ”Clock In”, “Meal Hour 1”, “Meal Hour 2”, “Meal Hour 3”, ”Meal Hour 4“ & “Clock Out”. After the clock out time there are Stright Time Hours Worked, Time & 1/2 Hours Worked, and Doubletime Hours worked. I want to...

My spreadsheet has 'Hours Worked' under column F and 'Pay Code' under column G. What I want to do is whenever there are '601', '603', '17' under column G 'Pay Code', I want to cut/paste values from column F 'Hours Worked' to column K. Below is my code which is partially working (it does moved...

Hello all, I am trying to find a formula to add up how many hours an employee worked in each work week. There is lots of data on my sheet, but below are the columns that I believe will be pulled from. I'm fine with adding a helper column (shown in my example as the "total hours per week"...

Hi, I update a roster for the entire month in the attached format and intend to capture shift details. Row 1 indicates the holidays marked as 'H' and row 4 captures the individuals working in the night shift. For costing purposes I want to count how many times BB has worked the night...

Struggling to make this work for me, probable cause - complete novice. I'm changing roles and now need to be looking into creating rotas, I've created my template for it, but I need to take out 15 minutes (0.25) out of each shift over 5 hours for breaks. I cheated a little and did the...

Hello, I need some help as I never had any training on excel and I'm lost! I need to retrieve airwaybills with hyperlinks. To do so I have tried a =HYPERLINK(VLOOKUP(F2,exacta!A:N,14,0)) however when I click on the link I get an error message (Cannot open the specified file). I've tried some...

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

I have a column in an Excel spreadsheet that lists the date and time in military time. An employee works 7:00am to 3:30pm. I want to sort the time worked each day (7:00 to 3:30) for the employee each day and exclude the time worked, 3:31pm to 6:59am. Can this be done without doing it manually...

I am having trouble finding an efficient way to manage this. What I am looking to do is find a way to calculate the total number of hours worked by employees for each hour during the day. There is an example of how the schedule exports to excel in a table below. I want to find out how many...

I have played around with a few formulas, but have been fairly unsuccessful to get a formula to calculate fiscal year on multiple dates. Does anyone here have one that has worked well? Thanks.

I would like to highlight any contractors who do not have a finish time each day. I have a column for start time, finish time and one to calculate the hours worked. (3 adjacent colums going left to right) Ideally as soon as a start time is entered it would highlight the 3 cells for the employee...

Good Morning, I've got a database where I run a Select Query every morning that requires me to enter in today's date. It worked fine last week and last month, but as of today I get the following error: "This expression is typed incorrectly, or it is too complex to be evaluated. For example...

if column 1 has the names column 2 has the departments (either a or b) remaining column has the hours worked weekly how do you identify those with multiple entries (i.e worked in the 2 departments for a total number of hours overall in a week) ?