difference

hello i have one column that list a date with a time and another column with a date. i need a formula to tell me the difference in months between the two columns. i am essentially trying to see how long the person owned the client at the time of the response date. so in this example below the...

Hi all, Here is a sample of a spreadsheet (horse racing). A B C D E F G <tbody> 13:35 Lismore 2 2 Flag Raiser 73.60 1 13:35 Lismore 2 1 Game Set Match 64.46 2 13:50 Goulburn 2 1...

Hi All, i am trying to work out the difference of sales between current week and the week prior. my formula so far is: =COUNTIFS(Historical!C:C,B2,Historical!$A:$A,A2,Historical!$I:$I,WEEKNUM(TODAY())-1) im struggling to work out how to compare it to the current week. any help will be...

Hello, Please see the table below: <tbody> Store Name Sales 2018 Rank Store Name Sales 2019 Rank Store A 700 1 Store B 400 1 Store B 500 2 Store A 350 2 </tbody> I am looking to do two things: 1. I need to find the difference in sales for...

I've been searching the net, but am having a hard time finding an answer. I'd like to understand this before continuing my work. I read that the difference between Sheets(" and WorkSheets(" is that in older versions of excel, there are different types of sheets, and that for today's standards...

Please help. I have to calculate the machine downtime between start date and end date between 9:00-18:00, assuming that there is no holiday and includes weekdays. What I did: 1. Calculated the time difference between START DATE/TIME (Column A) and END DATE/TIME (COLUMN B) which results to TIME...

Hello, I am pulling 2 different dates via VLOOKUP into cells in a spread sheet and then wanting the difference by day returned. The problem in the dates being pulled have time in the also so when I want the different to be zero it returns .29 or something like that...

I have a 3 series stacked bar chart and the fourth series is a data label. The data label is a date value that selects values from the date column. The Primary axis is categorized based on 2 values. The secondary axis is Month. The data labels are displayed accurately as per the month except the...

So I have a column of formulas. I clicked and dragged to autofill the formulas and at some random point, it stopped working. Can anyone see a difference? =IF(A123=0,0,VLOOKUP(EQUIPMENT!A123,EQUIPMENT!$L$3:$P$2888,5)*B123) This is the last one that worked...

Lets say i have these PovotTable fields. FieldRow, FieldData1 and FieldData2. I put FieldRow in the Row area of the PivotTable, and so data fields will be summarized for each item of FieldRow. I put FieldData1 and FieldData2 in the Data area, and set them to aggregate by Average. I would like...

Hi all Through column B I have a simple list of numbers which represent pounds and ounces B5 = 144.2 (so this represents 144 pounds and 2 ounces) B6 = 138.9 (so this represents 138 pounds and 9 ounces) what formula could I use so that C1 shows the difference between B5 and B6 (and shown in...

I do a Financial Spreadsheet for my boss. Lets say A1 is our revenue. B1 is staff cost. C1 is a percentage of cost to revenue. D1 is the difference of C1 to our Goal of 22.5% Is there a way C1 can turn Red if the Percentage exceeds our Goal of 22.5? Is there a way D1 can be Red if the...

What is the difference between .clear and .clearcontents? They sound like they do the same thing.

Hi all - I am trying to include a year over year $ difference in my pivot table but all the examples I see have the dates in a row field vs column. I want to just have one column after 2019 #s that calculates the difference from prior year. If I drag the amount field again in the values...

I have a table with some timestamps and some values. I need to group the data based on the time difference between datapoints - for example if the time difference between two points is greater than 3 days, put data in a new group. I have tried using a pivot table for this but can only group by...

Hello, Beginner at VBA here. Was wondering if someone could simply explain to me what the differnece is between: If ActiveCell = " " Then ActiveCell = 0 Else ActiveCell.Offset(1,0).Select V.S. If ActiveCell = '' Or ActiveCell = " " Then ActiveCell = 0 Else ActiveCell.Offset(1,0).Select...

Hi There I have two columns stating time Column A, Planed Time Column B Actual Arrived time. For Example, planned time: 08:35, Arrived time 08:36 = (Difference) 00:01 But when it a negative time ie earlier than planned time it will not work this out. Also I notice the actual arrival Time has...

Hi All, I'm trying to calculate the difference between two dates. Formula I'm using is IF(MONTH(D2)=MONTH(D3),((YEAR(<wbr style="color: rgb(51, 51, 51);">D3)-YEAR(D2))*12)-12+(12-<wbr style="color: rgb(51, 51, 51);">MONTH(D2))+MONTH(D3)-1+(<wbr style="color: rgb(51, 51...

Hello, I have a very very big problem with my last Pivot table. I have to calculate difference between Parent total and intermediate value, but not in percentage terms. I need to find difference in numeral. In my table is a leading product code. I have many product codes each of which...

<tbody> A B Formula in N Result of formula 05/28/2019 05:15 05/28/2019 05:00 =IF(A3="","",TEXT(TIMEVALUE(TEXT(A3,"HH:mm"))-TIMEVALUE(TEXT(B3,"HH:mm")),"hh:mm")) 00:15 </tbody> This has to be simple, and don't know why I'm unable to think of how to do this, but I need some help...