shift

Hi I have a range of date cells which cover several years and am currently using the following formula to calculate the number of unique days in a particular year, the dates are in the 01/01/2018 format, in this case 1992...

Hi Everyone, I have a formula that I'd like to write but i either get #value ! or 0 for the answer but 0 is not the correct answer. This data is on a separate spread sheet. <tbody> A B C D 1 Date Shift Reason Time 2 08/26/18 2 Washing 1:00 3 08/26/18 2 Washing 1:00 4 08/26/18 2...

I'm having a hard time getting my head around something. Ultimately, I am wanting to feed a range to an array, (for jobs), compare shift capacity to job requirements, and if the job qty is smaller than the shift capacity, add the job to the current shift, and move on to next job. When a job is...

Hi All, Would someone be able to help me in designing a timesheet in excel, I do not know how to do the formulas for all the rules below. I guess to have seperate columns that splits the hours worked into the following categories and seperate columns for the rules? I appreciate this is a lot...

I am working a a data entry user form that needs to calculate the Days shift Data and the night shift data to create an average. I have 20 averages that needs to be calculated and i have a button set up to execute the averaging function. Currently the code i am using for the averaging is as...

I would like to shift the numbers in column B down where there is an empty cell with the result being column C. If possible I would then like to put results of C in an array formula in column D {=A1:A10*C1:C10)} maintaining the corresponding empty cells. Formulas would therefore begin in C1 and...

Hello experts, I am hoping that this is not too big an ask? I have a workbook called weekend planning, I was wondering if it would be possible that when I add a date into the cells highlighted then it will cross reference with my engineering rota workbook and workout who is on shift for that...

Hi all, Can someone please help... If possible, I would like to avoid using extra cells to convert a Shift Time displayed in a single A1 cell for a Roster. Is there a way to split & convert the shift time 0630-1500 ED1 and ignoring 'ED1' letters at the end. It will help me to use this...

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

Hello everybody. I have a variable range defined as set = range1 in which there are empty cells. I need, for each row in the range, to shift all not empty cells toward the left. The operation has not to impact the columns on the right of the range, because they contains other data. For...

Hey everyone I want to create a workbook that keeps track of certifications of employees across different shifts. My goal is to have a master sheet that i update and have excel create tables in new tabs for each shift. I need the table to update when i change something in the master sheet...

Hi I've been looking around to see if this is possible. I have a userform for 3 different shift a day using page option. Is it possible when each shift opens the user form that the previous shift's checks and comments are there to be reviewed and when saving i don't save 2 or 3 copies of the...

Hello, First post on here but have used this site countless times as a reference. I am creating a heat chart for staffing purposes to show how many people are on shift for a specific day/time. The first sheet has schedule info (Name, Start Time, End Time, and 1/0 for each day of the week...

Dear Excel experts, I am required to make payroll payment to few (10-15) employees working in Security industry (Shift workers). The pays are determined by the timings of the shift i.e different rates of pay for Day shift (06:00 to 18:00), night shift (06:00 to 18:00), Saturday (24 hrs) and...

Need some help please; I'm working on a cost comparison and need some help with a sum that involve shift length, different rates depending on the time of day and the start time of the shift. E.g. - If an eployee starts at 04:00 set in column C, I would like the sum to pay the correct...

Please consider this snippit of code: For p = 5 To 14 ctime = ws_sbase.Range("B" & p) 'shift start time dtime = dpgo 'preferred groom time (start time - 1 hr) If...

Using Excel 2000 Hi, I have got data in column D:G, and need shift data results in columns J:M, Example data...

Hello All, I am still learning a lot of basics with excel, so excuse my ignorance if something similar has already been posted! I'm trying! I need to take a schedule entered into one sheet (Sheet 1) and have its information entered in another sheet (Sheet 2) in a different format, so that I...

Hello Everyone, Good Evening. I have the following table. <colgroup><col><col span="7"></colgroup><tbody> Shift Monday Tuesday Wednesday Thursday Friday Saturday Sunday 14-May-18 15-May-18 16-May-18 17-May-18 18-May-18 19-May-18 20-May-18 23:30 - 9:30 1 1 1 1 1 0 0 1:00 - 11:00 2 2 2 3...

Hi - This is my first time posting so bear with me. I work for a manufacturing company and we micronize raw materials into fine particle sizes and pack them into different size packages. The workers manually track the start and end times for each unit (bag/box) produced on their shift on a piece...