workers

Hello, I have text cells in a column that comes from a checkbox in a survey. the checkbox has an option list that people can select as many of the options as they want Example of option list of checkbox <tbody> Advocacy organizations Business community - Small and Medium-sized Clergy...

I think i have a problem but not sure. I am going to put a macro on here for someone to help me with. the problem is: When i am using F8 to step thur the macro and i am watching as i step thur the sheet and that sheet is named workers or Visitors the macro does just like it does on all the other...

Access 2013 I have a form (F_WorkingHoursSub) with 3 fields (Workers, Contractors and Total) Sometimes I have the hours for Workers and Contractors, and other times I only have the Total hours. I would like the total field to show Workers + Contractors if this data is entered. But... If I only...

Hello all, I am new in the macro and VBA world, i work to perfect myself in this new Learning. I have a spreasheet to work on and i need a code that can do this ... If anyone can help me doing it please. I have a spreadsheet that as 3 type of workers ( 43, 48 and 65)(same column A.) I have...

Hi Folks I am looking for some help. So in "Case" tab I have a list of cases the company are dealing with. In column "I" within this tab contains the name of the worker who dealt with the case. In a separate tab ("Team Sheets") I have all the workers in the company listed based on which team...

Hi All I'm wondering if someone can help please? I will have to explain sheet as I'm on work PC so unable to upload example spreadsheet. I need a formula that will calculate/count how many holidays someone needs based on their shift pattern. Warehouse is open 7 days a week and workers are...

I am trying to ascertain the last date that a worker provided their services for us. I have created some unique lookup values which include the worker's name, the department they worked in and if the job was 'filled'. The data I have has every single shift that the worker has ever completed for...

hi, I have datetime in cells A1:D1 A1: 2018-12-03 06:00 (day work start); A2: 2018-12-03 10:00 (breakfast break start); A3: 2018-12-03 11:00 (breakfast break stop); A4: 2018-12-03 15:00 (day work stop); So normally this is 9hrs work day with 1hr break included. The workers are payed for 8hrs...

Hello All, Just starting out in Excel and am working on a real-world case. I work for a company with several production lines. Each line has a team leader, at least one controller, one maintenance officer, and several production line workers. These workers are classed as A, B, and C level...

Hi, I prepare excel tool for measure employees production efectivenees. Briefly, it measures production done and available work time for each employee. It works preety good but the issue is how to collect workers absence. I have about 80 people and looking for any way how could I easy add...

https://imgur.com/gallery/Cld4B As you can see in the picture I have three tables The one on the right and left are where I put the names of workers working in the morning shift and night shift and if some is working between in both shift I put him in both tables And the table in...

Hi All :) I have a cell (Y6) that returns a value: IF($K6="","",IF($K6>=61,DATA!$A$91,IF($K6>=51,DATA!$A$90,IF($K6>=1,DATA!$A$89,"")))) I have formatted the results in DATA!$A as I would like it to appear in the working sheet.: <colgroup><col width="682" style="width: 511pt...

I apologize for the vague title. I couldn't think of what to call my issue. LOL Anyways, what I am trying to do is take the total hours for the project (lower blue cell) and distribute the "total # workers" (yellow cells) so that it EXACTLY matches up (to the decimal) to the upper blue cell...

Hi, I will try to explain the best I can. I have built a form and a report for our Call Centre team. Each CC worker has random calls monitored by a Team Leader. A form is filled in and saved to a folder in the Team Leader Team folder. I have a report that all CC workers can use to view...