units

Hi, My head has been pickled trying to figure this out, here's the problem (it's also on google sheets): I am trying to show a live production rate which is based on time and units completed. Start time in the morning is 8am I have a cell which shows the live time beside it Below this I need...

I would like to be able to format a time value so that it is displayed in the smallest units that are less than "1" of the next larger unit. That is, use seconds up to 1 minute, then minutes up to 1 hour, hours up to 1 day, etc. I would also like to be able to specify the number of decimal...

Hello, I have multiple excel sheets from each sales person which has the below data. Each sheet is broken down into 2 different sections one for sales which has the sales info and the 2nd for leads info. I have 1 macro which combines multiple excel sheets into 1 excel sheet but it pastes in...

Hello, Hope someone can help with this. I have a worksheet with a list of products, dates, delivery locations and amount being delivered (units). The products can be duplicated, as can the dates, but the delivery locations will be different if this is the case. <tbody> Product Date Delivery...

I have a report that I built in Primavera grouping by a code in column A. Column B has values from 7 categories for every code. My code value starts in column A Row 3 and my 7 categories start in column B Row 3. I have multiple columns to the right, but column B is my solid range of data. What I...

Let say I would like the first three tic 5 units aoart and the next 3 10 units apart. Is this possibly done ? Really appreciate the help.

Ob excel chart lets say i want the first three intervals five units apart namingly 5,10,15 then i want the next three intervals 10 units apart like 25,35,45 would this be possible? Thanks alot for he help.

Let say I would like the first three tic 5 units aoart and the next 3 10 units apart. Is this possibly done ? Really appreciate the help.

Hi, I have written an excel macro, see below... it works fine for one single cell, but I need it to work down a column range of say 80 to 100 cells and can"t figure out how to make it go down the column. I have tried a loop, but all I was able to do was to compare M7 with the rest of the...

Hi, I have written an excel macro, see below... it works fine for one single cell, but I need it to work down a column range of say 80 to 100 cells and can"t figure out how to make it go down the column. I have tried a loop, but all I was able to do was to compare M7 with the rest of the...

Hi, Maybe this isn't an excel question, but perhaps you can help? How do we determine the angle between 2 plots (of a line), where the x-axis and y-axis has completely different Units and Scale? The arctan function requires a unitless argument to get a real angle, but if you take rise/run on a...

Hi there, Hoping someone can help me. I need to split usage of units in different columns (without using VBA): For example- Total Usage: 29 (B3) Column C: The first 1 to 12 unit are free Column D: Units 13-25 are charge 1 Column E: Units 26+ are charge 2 I want to the split the usage...

Im trying to figure out a formula for a weeks of supply report. data i have. Last weeks sales units Last 13 weeks sales units Sales units year to Date Shipment Average units last 13 weeks Total units shipped last 13 weeks On hand units Work in progress units anyone have any recommendations

Hi, I'm using the dictionary in VBA to summarize based on the units held in one column, but I would also like the code to summarize by amount, which is in another column, can I do this in the same sub and output both the results by name for units and amount. I have pasted the example how the...

I have a row that lists numbers between 2019 and 2045. I am starting a project on a specific year and ending on a specific year. As an example, if I start the project in 2020 and I am going to install 100 units a year for 4 years. I want the cell below it to reflect the total number of units...

I'm trying to track total units completed hour by hour. What I want to be able to do is have a single button that adds to the number of units complete based on what time it is. So, if it is between 3pm-4pm then pushing the button will add one to cell that is designated Hour 3-4, and so on so...

I am working on building a formula that calculates a bonus based on multiple criteria: number of units, total volume and fixed cost per unit. I can easily create one based on the volume and fixed cost per unit, but adding the units portion is giving me difficulty. Below is the chart in which the...

Can someone help me with a formula to convert units to minutes for my time card? 10 Units= 60 minutes. lets say if there are 12 units how do I convert this to the exact minutes?

Hi I have 3 measures. They all work fine on their own. But now I would like to have it evaluate when all 3 conditions are met. I cant seem to get it to work. MUGS UNITS SOLD:=CALCULATE([SALES TOTAL UNITS SOLD],('tblInvSkuMaster'[<wbr>brand_code]="CANA10")) MUGS TRANS# DISTINCT...

Hi, Hope you are all well. I usually have to amalgamate quarterly data into year data. Rows 3 to 14 are the raw data entry points. I want to end up with Row 18 to Row 24 For example: USA Exports Commodity "A" to Canada in Q1:20 units, Q2:30 units, Q3:40 units, q4:50 units. I want to end up...