subtract

I am looking to subtract 15 minutes from whatever value is in cell O2 and put that information in P2. Any help would be appreciated.

Hello, I have a spreadsheet with multiple tabs. Each week, I add a new tab. The columns on all tabs contain the same exact data type in the same column (ex, col A on all tabs is the customer #). I need a macro that will look at col A (customer #) on the current tab, then go previous tab...

I hope you can help. I have a small piece of code below. The issue I am having is that I am trying to subtract today's date from the date in Column T and then return a numerical result in Column U and then continue this formula down Column U until there is no values left in column T to subtract...

I have a pivot table and I need to subtract a couple columns. The way I have it formatted is one column contains all of the individual names. How do I subtract 2 of the columns in the 1 column? Any help is much appreciated!

Hi everyone, I appreciate you looking at my thread. I'm still new to this excel thing, and I've only just started getting my hands dirty with this program and it's quite addictive. Ok so now here's what I need to accomplish: I have a form where my Team Leaders order totes of product that we use...

Hi, I need help. I want to subtract 2 columns from each other (Dates) but the cells need to be checked fist if blank and if blank it should ignore the one or use Today() in the other. Example below. Row 4 and 5 work but row 6 gives me a 43027 value that should be a blank as I get the average...

I am trying to create a spreadsheet that balances my clubs books. Debits are in G6, Credits are in I6 and balance is in K6. I am looking for a formula that leaves K6 blank if there are no numbers in G6 or I6; and will subtract any amounts in G6 and add any amounts in I6. Hope this if sufficient...

Need a formula that will calculate the time (Hours) difference between two values then subtract 1 hour and give a numerical Sum. Ex. (A1) Start Time:8:00 AM (B1) End Time: 5:00 PM (C1) So the Formula in this cell should show the difference (9 hrs.) between the time in cells A1 & B1 then...

Hi guys, Complete newbie to VBA! I have created a stock management worksheet that I "simply" want to add or subtract from a running total with a click button to carry out the function. At the minute I have the following code: Private Sub commandbutton1_click() Range("J5").Value =...

Hi Experts, Need you help with Macro to subtract 2:30:00 HRS from a column which has date and time in this format "10/7/17 2:40 PM" . Thanks :)

Hello, I am trying to find an efficient formula that will add the values in B4:F4 (yellow cells) and then subtract it from the value in A1 and put it in cell A2. But then I want the same for values in G4:J4 (gold cells) and then subtract it from the value in G1 and put in cell G2. And so on the...

So I have a pricelist on one sheet and I'm looking to make it my master sheet. Then I'd like to import it to another sheet, so any time I make a change on my master sheet, it changes my imported sheet. I'd then like to put certain ranges, like if under $10, subtract 20%, if under $20 subtract...

Good morning and newbie here. Not sure if I worded the title correctly but hopefully I can describe it better. So I have an age range starting with 62 on up. The formula I am looking for would start with a set number (in this case 29), subtract a year based on the person's age as they get older...

I have column D of times that I need to subtract 5 hours from each. I wrote the following code: For i = 2 To LR If IsEmpty(data.Cells(i, 4)) = False Then data.Cells(i, 4) = DateAdd("h", -5, data.Cells(i, 4) End If Next i I wasn't sure if this was the best way or not, but it seemed...

Hi i have two sheets sheet one <tbody> id values 11200 100 11201 200 11202 300 </tbody> sheet two <tbody> id values result 11200 1000 11202 300 11201 4000 </tbody> i wanna subtract values base on id and insert in result column for example for id 11200 result...

Hello, I am at my wits end trying to work with numbers in excel. I simply want to be able to work with minutes and seconds data. Add it, subtract it, heck maybe even divide it. So I want to be able to take 20:00 (20 minutes, 00 seconds) and subtract 7:45 (or even 07:45) and get 12:15. I...

Hi There- I have a spreadsheet that has a running total in cell G5. I would like to subtract a cells value from range B4 to B21 if the corresponding cell in range D4 to D21 is filled with PAID. Meaning, if cell D8 = "PAID" then subtract cell B8 from running total in cell G5. Can someone help...

Hi all, I'm having a strange problem. I have a formula subtracting one cell's value from another - the resulting number is incorrect by a very small decimal amount (like 1*10^-14). The initial two numbers were typed in so they should be exact values. Anyone know what is going on? Screenshot is...

Hi, can someone help me with the following : let's say I have a variable and let's make it =4 for this example I need to have a formula that will generate the following rows : 1 2 3 4 3 2 1 2 3 4 3 2 1 .... and so on... Any ideas ?

I would (A2-A1)+(B2-B1) multiply by 65 then subtract this answer from C2.