pieces

Hi! I have the old problem of getting Excel to understand time as duration, not time of day. Basically, I want to calculate how many pieces a worker does at the end of day, knowing: pieces/hour and time worked (like 1h30min) I think I got it to understand time, but can't get it to do the...

I have two pieces of code. They are both subroutines. They have the exact same coding up to a certain point but the 2nd one is giving me a "type mismatch" error. I don't see why it's reacting differently to the EXACT same coding!! Sub DeleteSeqCol(HeaderCount%, HeaderNames As Variant)...

Hi all, New Member here. I hope you guys can help me. Ive asked this on another forum and didnt get a useable answer. https://www.excelforum.com/excel-programming-vba-macros/1254244-distributing-numbers-into-sets-that-maximize-their-total.html#post5016154 Im hoping someone here can help. I...

How to cut list into pieces that are marked by / ? so that 1/2/3/4 would become 1/ 2/ 3/ 4/ By doing a macro? so that it would cut after / and paste into new row? and repeat until the last / ? Thankyou :rolleyes:

Hi I have a question for all that can possibly assist me.... I have a worksheet that returns, or displays unique matching values (on some, or all target columns in a range. Basically: It looks up, or searches the typed-in input value and it compares it against all existing values in another...

Hello everyone, I am trying to get a formula that will pull a price based on two pieces of criteria, one being the product and the other quantity. For example, I have a part number of 880 (A15) and a quantity of 15(G15), I need the price returned (S15) based on these two pieces of criteria from...

Apologize in advance if my request seems confusing. I need a formula that indicates the "end date" of when I run out of the content pieces on column F. This is based on the "start date" and the fact that these pieces are distributed only on Monday and Tuesday. I would appreciate it if...

Hi, I am working on a sheet, where there are "n" number of pieces. Each piece has 4 values that need to be entered and then two values are calculated. I need to have those 4 value cells and the calculations repeat based on the "n" number of pieces, or the number of times repeated that I enter...

Hi Everyone, I'm new at this. Can someone help me in creating a code to Auto Sort the Data based on the Column F as soon as I type new info. Thanks in advance for any help, Jose. <tbody> Weigh Station Operators Shift Days Worked Pieces Processed Total Hrs Worked Pieces Per Hour DA...

Here is my situation I have productivity sheet that employees fill out through out the night. At the end of the night the sheet gives them the total hours they worked and gives them the total files they completed. These two pieces of data are then typed into a table connected to a separate...

I'm not sure if this can be done or not. I have dug through the threads and google looking for code. I have multiple rate sheets that are named by client. On the sheets are the equipment we are going to use along with the rates we are going to charge. I don't want to just copy and paste the...

I'm hoping someone can post the formula I would input into a cell to calculate true position from 2 pieces of data. Thanks in advance.

I need a formula that will calculate the total length of tubingl of different diameters, knowing the specific length of many different pieces and their different diameters. Column A contains the length of varying numbers of pieces of tubing. Columns B, C and D each contain a different number...