difference

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?

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...

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...

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...

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...

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?

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...

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...

I have dates in excel as shown below: <tbody> 26-JAN-19 01.41.11.611000000 AM 26-JAN-19 01.46.07.657000000 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

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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.