First off sorry for not being able to insert as an excel table I couldn't figure out how to input such a large table..
I’m having issues coming up with a formula that will get theresults I need. Below is an image of the data on my sheet.
What is displayed in column A is the days of the...
I want to add a control so depsite the user holding down the shift ket, macros still run (assuming macros are enabled of course)!
This article indeed does this:
However it mentions this code needs to be added in the Ribbon module:
I get extensive daily reports in the form of workbooks with multiple sheets. I have a master workbook with multiple sheets as well. We operate by shift numbers.
In the master workbook, I have shift numbers in columns. For example, row 8 is shift 5, row 9 is shift 6, row 10 is shift...
My data comes to me in the following way
123456G 1 1 1 1 1 1 1 1 1
234567B 1 1 1 1 1 1 1 1 1
345678R 1 1 1 1 1 1 1 1 1
456789B 1 1 1 1 1 1 1 1 1
The number with the letter is the first cell and is part number and shift built
The other numbers are measurements of part...
I have a person that gave me their spreadsheet which they use for manufacturing production. At the start of a shift, the shift supervisor presses a "Start of Shift" button. They asked me to place an autosave macro in there so it backs up throughout the day. I put the following macro in:
I'm after a formula that can calculate - If shift 1 equal zero it will return shift 2 and verse versa
<colgroup><col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;"> <col width="130" style="width: 98pt; mso-width-source: userset; mso-width-alt...
I'm have some problems with data validation. What im trying to do is stop people over planning a line past the planned finish time.
In column g you put in an amount that generates a finished time in column k
I've tried to put the following validation in column g so that it stops...
I have the total number of employees allocated to each shift, what is the best way to formulate to show the count of each employee in an interval for each day of the month.
M-F 8am -5pm-: 20 employees
M-Sat 6am -3 pm, with wednesday off: 10 employees
How do I formulate this show I can...
I've run into a snag in my Excel VBA project.
In my userform (userform1), I am using a combination of 4 combo boxes (uf1cb_hrstart, uf1cb_minstart, uf1cb_hrend, and uf1cb_minend) to allow the user to select hr and minute values for both start and end times.
Upon userform1 initialization these...
My question is that I have numerous workbooks that an employee keeps record of and keeps data in Cell P1. (Different workbook for every day). I need to retrieve Cell P1 to compile the information into one ongoing running sheet.
Shift 1 Dept A in its own workbook...
Good afternoon all,
I am trying to find a way to calculate our devices downtime during our Performance Measures hours for each month.
As of now i add each device,from each shift, each day for the entire month. Example:
Performance Measure hours are Monday-Friday 5am to 9pm. We have three shifts...
I try to find formula in column C to calculate time based on shift patterns that could be different. Sometimes shifts can be 8 hours per day, or it can be day off in the middle of the week, because of bank holiday.
Please see below data.
in column C are results.
C2= 13.5 hours...
I am setting up a work schedule and I am trying to create a formula that will check to make sure that each day at least has a day (D) and a grave (G) shift assigned to an employee. If it does not have one of the two shifts, I would like for the missing shift to appear only in row 4. I think I...
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:
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...