difference

What is the difference between an ACCDB database and a ADODB database. I use Access 2016. My current database is ACCDB. How can I convert it t ADODB.

I need to find out the result of difference between multiple calendar data. For example I need to calculate in years, mont and days the sum of column C A1 B2 C3 01.08.1997 10.08.1999 2 years and 9 days...

Hi everyone, We have the below table with around 3000+ rows and we would like to create a VBA script that will find the difference of the oldest and latest date in "TIMESTAMP_LONG" column for every unique entry in "INSTANCE_ID" Please help. Thanks in advance Regards Raghav <tbody>...

Hi, First time here. I have a query with dates and if functions. Not sure if this is possible but need some guidance to see if this is actually possible with so many conditions; <tbody> If the date in G is sooner than J than this field should be the difference of the 2 dates in days * D...

If I have 3/6/2012 11:00:00 AM in one cell and 3/7/2012 14:30:00 AM in the other and I need to figure out the number of hours that elapsed, what would be the formula used to get there? It would need to be displayed as "27.5" hours. I know if you simply subtract the two cells, it will give...

Good Morning, I was looking for some help on getting the difference between subtotals on two different pivot tables. The problem is that the rows on the pivot tables will not line up with each other so i need it to pull based on facility name and subtotal. So basically I am creating a table...

Hi everyone, hopefully sile question but I've noticed when i get hepl some times i get this "Eviron("USERPROFILE")" and sometimes "Environ$("UserProfile")" is there a difference? why the "$" and the capitals? just wondering if one is better Thanks Tony

Hi Under Data Validation, I have these 2 options: Whole number and Integer. What is the difference? I tried them both but same results. Thank you so much.

Hi, I am analyzing someone else's code. One thing I notice is that they alternate between run("some_macro") and call some_macro Why is there a difference in the way the macro is called & does this make any difference? I personally don't like changing the way it is called, I would prefer...

Hi, (I'm using Excel 2010) I have a column of figures that are being constantly updated from a source that the spreadsheet is connected to. (In Column C) In column D I want to display the difference when the figure changes compared to what it was previously, every time that it changes. ie...

Hi, everyone. Can anybody help me with the formula for counting frequency of dates based on difference between 2 dates? Here's an example of what I am trying to do: ColA ColB Freq of <3 days Freq of >5 days Row1 09/30/18 10/20/18 Row2 09/30/18...

I need a cell in my spreadsheet to show a "difference" value when the value in a reference cell (G25) exceeds 8. I have put the following formula in the reference cell =MIN(8,SUM(G25)) and the following formula in the "difference" cell =IF(SUM(G25)>8,SUM(G25-8)). The formulas work when there is...

I have two columns that needs balancing, I have list of numbers, and need to find the difference between the rows using the list of numbers. Please see example below: <tbody> A B 10 8 34 30 50 35 </tbody> <tbody> 4 -2 4 -2 5 </tbody>

I'm trying to compare the difference of two cells, and highlight both cells when the difference is more than 50%. I have a field in both the columns and row areas, so it's proving difficult to create the conditional format and then recreate for entire pivot table. Any ideas?

Hi All Wondering if anyone can help me here. I need to highlight cells where the number is lower than say cell A2 but only if there difference is more than 1%. Any ideas? For example: <tbody> 53 52.6 55 50 47 69 </tbody> Only the cell in purple would be highlighted. 52.6 would not...

Hello, What exactly is the difference between doing something like "<>hello" and "<hello>". I hate using sum product because I always forget how to use it, so I am using a =sumifs like this.......... =sumifs(A1:A100,B1:100,"<>*033000*"). I figured out that is the way it works...

Hello, I have to review a reconciliation file similar to the one below. The problem is that in column 5 (Comment) there could be cells that include a number of items, which makes it impossible for me to filter/analyse the data, (i.e. comments for item #3 ). Whenever a comment contains several...

I'm wondering if anyone has VBA to compare data within two worksheets and then output the row with the difference to a new sheet. Also I would like the headers to go to the new worksheet.

Hi All, Good day! How can I get the hours or minute difference between two date but those dates should only count network days Fri - 10 sat - 11 sun- 12 mon - 13 <tbody> start date & time end date & time what i get (minutes) desired result (minutes) 8/10/2018 5:08:00 PM 8/13/2018...

I created a column that takes the difference or percent of difference from another field i.e. 1st Qtr 2017 versus 1st Qtr 2018 in a pivot table using an existing value column. Unfortunately, what this does is creates two columns one for 1q17 and one for 1q18, with an empty column for 1q17. Is...