1. charlesstricklin

    Calc difference between two dates without DATEIF

    I'm using a 2010 version of Excel (Don't judge!) and it does not have DATEIF as one of its functions. I know that I use: =INT(YEARFRAC(D2,TODAY()))&" years," ...to calculate the years, but how do I add the number of months?
  2. W

    VBA find differences in 2 worksheets

    I have two large worksheets. One was run a couple months ago and the other was run this week. I'm looking for VBA to find the differences between the worksheets. Each worksheet is set up the same, but the data may not be in the same order, and may not have the exact same items. Spreadsheets...
  3. D

    Managing Department Salaries and Yearly Percent & Dollar Difference

    Before I give up and just use a pivot table to do this. Is there a way, without a pivot table, to calculate the percent salary (column F) difference in column H and the hourly dollar (column G) difference in column I, for the previous year? I know I can do this with a pivot table by only using...
  4. W

    Doesn't subtract right.

    Greetings, I keep a Diabetic Log, and I want to compare this period to the last period. The code that I use is,; ="I'm " & (ABS(INT(I17-'April 2020 - July 2020'!I14) ) ) & " points, " & IF(I17>'April 2020 - July 2020'!I14,"Higher", "Lower")&" than the last peroid. " The difference will range...
  5. A

    Working out Time difference

    I have the below that I am trying to work out. People have 15:00 minute breaks at present. I have data of how long people have taken. So want to know the difference in time against 15 minutes. Person 1 - 9:53 Person 2 - 20:24 Person 3 - 15:00 Person 4 - 12:30 And so on. At present I get...
  6. D

    What do the @ symbols do in formulas

    What do the @ symbols do in excel formulas? The names are table column headers =[@Rate]*([@MinHours]+[@AddHour]) What would happen if the @ symbols were not included?
  7. V

    Difference in date

    I have this records below If the “PROJECT_NUMBER” is repeated AND “INCIDENT_CREATION_DATE” between the two incidents is less than 31 days then mark it as a "repeat" I am confused as how shall I do it, as did countif as well to find the duplicate and then the diff in date but the records can be...
  8. T

    Formula using Percentages

    I have a formula that I want to write as follows: <tbody> <tbody> A B C D E F Region Country Charge Rate Card 15% Margin New %margin new rate formula for cells in column F C&W Europe Austria € 750.00 € 637.50 23.39% € 637.50 IF E2 is less than 15% then increase D2 by the difference in...
  9. H

    Urgent Help!! excel formula to calculate time difference between two dates in Milli seconds with AM

    I have dates in excel as shown below: <tbody> 26-JAN-19 AM 26-JAN-19 AM </tbody> I need to find the difference between 2 dates... In the example above, I have difference at Sec and milli seconds. How can I find the time difference. This is bit urgent
  10. J

    VBA getting the difference between Time Stamps

    I am looping through a column of TimeStamps in this format: 6/7/2019 9:15:19 AM CDT I want to find the difference between the first and last time in terms of hours and minutes preferably in a format such as 8.5. in the below code, sRange is an array of data containing the timestamp...
  11. S

    VBA Differences

    if r =("A1:M1") then I know what this would do For each c in r But what would be the difference between the following below: For each c in r.rows For each c in r.cells For each c in r.columns
  12. TAPS_MikeDion

    Finding Difference Between Two Times

    Hello, I have been trying without any luck to find the time difference (Sun - Sat, employee start & finish times) between two columns of times, but the finish time may go into the next day. I found a post here that I thought might work, but VBA MOD is apparently different from Excel MOD. I...
  13. S

    Comparing text in 2 different cells

    Hi It is easy to do the above as per https://exceljet.net/formula/compare-two-strings. My question: Can one do such a comparison without extra spaces in one cell being counted in the comparison? In other words, if the only difference between the 2 cells is an extra space in a sentence, I...
  14. W

    Displayed date difference starts counting from one day again whenever a date difference exceeds one month

    I'm trying to calculate the date/time difference between two cells, to be displayed in days, hours and minutes. Right now, if I simply use <code><code>=A1-B1</code></code> The cell displaying the difference has the following custom formatting: <code><code>d "days" h "hours" m...
  15. B

    Excel time formulas

    Hi, I'm looking for a simple formula that will calculate the difference between a start and an end time then subtract 30 min. So, for example, the start time is 7:00 am and the end time is 4:00pm. I can calculate the time difference but I don't know how to then modify the formula to subtract...
  16. M

    Calculating difference in time - conditional formatting

    Hi all I would like to calculate Time-in - Time-out and if there is less than a 9 hour difference, highlight the cells. In the example below B4:B5 & C2:C3 would be highlighted. <tbody> Time-in Time-out Time-in Time-out Time-in Time-out 08:00 18:00 09:00 22:00 06:00 17:00 12:00 23:00 07:00...
  17. T

    Automating conditional decision making

    Hi all, I have hit a problem with my work project and it's one of those where I can't even begin to design the solution never mind implement it! I hope you guys can help! I have provided a sample workbook here. https://drive.google.com/open?id=1u30oLh9SavbDpc3YVfoWGCEGJZ7Aqpeu The process...
  18. G

    Excel - Subtracting 2 dates/times (DD/MM/YY HH:MM:SS) to find the difference

    Hi there, Read a couple of posts on this, and struggling to get my head around it. Sorry if this has been answered before. My data source outputs dates/times as 22/08/2019 10:33:03 in one cell, formatted as (dd-mm-yyyyhh:mm:ss). What im looking to find out, is the difference in timebetween...
  19. A

    Best PC for calculating huge data?

    Hey Dear community, I use VBA to calculate very big files, with my pc ( 6gb ram ) it takes 35 - 40 minutes for calculation. I wanna know what if i make same calculation with server? ( 125gbram etc ) will there be very big difference in calculation time? or is there calculation time limit...
  20. E

    trim not working

    I am trying to use =trim(D2), but it is acting like I am not using a formula. It is just displaying =trim(D2) in the cell. The field I am looking at is an address field so they start with numbers, if that makes a difference. Thanks for any help.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back