add

I am trying to use a basic formula D2+E2, but it wont add the time right. It should say 2:07 for time stop. (2:07+00:00) but it says 7 minutes. Any ideas why?

Hi, I have recorded a macros Sub WarehouseRecieved() ‘ ‘WarehouseRecieved Macro ‘Booked in at the warehouse ‘ ‘ Keyboard Shortcut: Crtl+w ‘ Range(“Q21”).Select ActiveCell.FormulaR1C1 = “Yes” End Sub BUT!! I want to select a different cell (column b) run the shortcut and yes to appear...

Hi After some help on a formula please which will make life so much easier. What I am after is when a word is put into 1 column it will use this then to add 1 hour onto the hours on the same row. Example below of table. Basically when AL example is entered into Column F2 it then takes...

Hi, I have a VBA code (see below) for a macro button to add month sheets in a workbook. Now the month sheets are sorted from January to December, but I would like them to be sorted from December to January; while still keeping differently named sheets at the end of the worksheet tabs. After...

I have pieced together some code using excel as a file picker to add images to embed within subject body. Everything is working just fine with basic alignment, but I would like to get some help adding these images into a table with a specific formatting Outlook seems not to have a huge support...

Hello all, I'm unsure if this is something that can be done. However, I'm wondering if it's possible to add a subtotal (from a measure) onto a row value? In the attached example, I would be looking to add the Inbound actual excl recharges value, with the inbound unallocated actual value on the...

Good morning all, I have another VBA/AcitveX/Button query that I hope someone can help me to solve! Also please forgive me as I don't 100% know the QUESTION I am asking, I just know the result I am after. (I have also have to redact some of the information becuase of where I work.) Context...

Hi! I have a huge set of data that includes hours employees have worked during a pay period. I need to know how many employees have worked 40 hours during the pay period. I can combine employees to get to one 40 hour employee. For example, if I have someone who has worked 40 hours they count as...

Hello, I'm trying to do a macro that let's the user select a folder with more folders inside, this folders could have images .jpg or .png. What I want is that the macro adds only the image files in the excel, any image file. What it does right now is that adds the images but only if they have...

Hello forum friends, I am trying to add a multiplier to an existing array formula but it is giving me, not an error, but the wrong result. The formula as it exists is returning a result of 24. I want to multiply this result by 0.621371 but when I add *0.621371 to the end of the formula and do...

Hi folks, For a worksheet I'm making a comment form. What it does is simply add some text to a cell the user selects. What I've been unable to figure out is how I make only the added text in red, while the rest stays the same (black). Right now it add's the text from a Textbox to a cell. It...

Hi. In Sheet0 I have columns A to O populated with travel data. E contains email address I contains departure date L contains country B has the formula =IF(COUNTIFS(TA!C:C,E2,TA!E:E,"*"&L2&"*",TA!D:D,"<="&I2+7,TA!D:D,">="&I2-7)>0,"yes","no") which looks to see if there is a corresponding value...

this is my formula for IF...

Hello, Is it possible to add the asterisk sign to string of text with the custom number format ? i dont want to concatenate the string with the asterisk just format so in the formula bar the asterisk will not exist.

Hi, I am making a Name List where people can put their name in a cell, and click on a macro-recorded button to automatically add their name to a new row in an existing list. However, I am trying to add VBA to set a limit to the number of rows that can be filled in this list. So, if I want the...

I am having a hell of an issue that i can not figure out. So I have 6 teams with three months of data I need to track. Each team has a goal they need to achieve each month based on how many people are on that team. This goal changes with the number of people on the team. This is at the bottom of...

I need to add a minus sign in front of a number in cell G8 and one in H8. Thank you for your time

Cells: B2, C2, and D2 are the cells. Values: 19, 7, and 12. If I add 1 to 19 and make it 20. I need 12 to change to 13. If I add 1 to 7 and make it 8. I need 12 to become 11. Possible? How?

Need to add Cells D7, F7, H7, J7, L7, N7, P7, R7 can't get it to work. Private Sub Worksheet Calculate() If Target.Cells.Count <> 1 Then Exit Sub If Target.Address <> "$B$7" Then Exit Sub If (Target.Value >= 0) And (Target.Value < 0) Then Exit Sub Pictures("Picture 7").Visible =...

I have 11 cells to add that contain text and numbers. I only want to add the numbers, and if possible insert the sum into a cell that also contains text. My other problem is creating a percentage using those 11 cells divided by 11 corresponding cells with only numbers to get the percentage in...