processing

Dear Folks, I am stuck in a situation where I would like to calculate the total processing hours of a request. Of course I have request receive time and request processed time. Both time are in dd/mm/yy HH:mm:ss format. I have tried many combination of formula to calculate total working hours...

Morning All, Have been trying to figure out how to do this, but failing miserably. Hoping someone can help/offer advice. Including a sample sheet to download. Completed worksheet is a selection of tickets worked by a team, a description and the customer name. On the Order Processing sheet...

What would be the appropriate formula to extract the text between the 1st and 2nd underscores? Text: STR_UAT_19.3_MWaaS: MODIFY_EXISTING_INTERFACE - Business processing area is not populating when MFTP-ID is entered. * Original Value located in Column: F

I have a Powershell script that pulls all of the Outlook Email Rules in our Office 365 Domain. I would like to output it to JSON as CSV drops columns. I have the export working fine but cannot seem to get the data to load into Excel. I have followed several videos on how to go to Data --> Get...

I am processing thousands of xls files and randomly I will get a popup that halts my processing. It is a login window (https://login.microsoftonline.com). Why does that come up and how do I avoid this so it does not halt my execution of my code? thanks

Hi Experts! I am trying to formulate the best way to create conditional formatting rules to be able to highlight the whole row based on the words found in column G. Basically, column G contains all the status of the processing of the macro. It is consist of a sentence or two. I want the rule to...

OK here is what I am trying to do I have a workbook (lets call it A) which has a fixed name and stores the VBA codes. The macro in A creates a workbook (B) which is saved under a name which varies. Another macro in A does some processing on B. Ideally, I need a VBA subroutine to switch...

Hello, I have a column which contains DATE/TIME (3/14/12 1:30 PM) in excel. This column is called "Arrival Time". What I am trying to do is to look at this column and determine what the "Processing Date" should be. Here is the caveat. Files arrived from 8am - 7:59am the next day are...

=IF(OR(F2="Archive DATA - ECA",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(S2),"False",IF(OR(F2="Archive Data - Review",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(S2),"False",IF(OR(F2="Client Training",I2="02 Pending PM Review",I2="03 Approved by...

Hey Guys Looking for some help as not that expereinced with VBA, i've created a consent form for clients to fill in and that data then gets recorded, there are several pages and each step is recorded step by step as to stop it all being down in one go, i found this was a quicker way to do...

What should I get paid for creating/solving Excel/VBA things in the UK? Wondering because my contract (for data processing) is coming up for review and I've been doing a wee bit more than data processing. Any input would be great. Norie

I need to execute 2 commands in N but don't see how I can do that. The value in K is from another program using DDE and is continually changing. When M is >= F I want to Move F to N and move zero to K. I need to zero out K to stop any more processing on this row. N will be zero while this...

Hello, I am trying to determine two things in relationship to Excel 2016's computational abilities : 1.A benchmark on how to guage the processing power of Excel 2016 on my particular system. 2.Figure out how much computational power is needed to calculate up to 10 Excel sheets. For example...

I have a workbook that I had intended to use Conditional Formatting to apply a 3 letter code as a prefix to a numerical value to indicate the currency being displayed. The code will change depending on the value of cell, “USD”, “EUR”, etc… I have 13 different codes in total, so there are 13...

I was wondering which of these two indirect formulas (that preform the same calculation) would use less processing power and not slow Excel down as much? Looks can be deceiving so I thought I'd ask those who would know for sure. =INDIRECT($A$1&CELL("address",$b3))...

I need some help with how to best design an application. The current structure of this application uses hundreds of formulas across all of the sheets. The vast amount of formulas is drastically slowing down the processing of the application. With that said, I'm trying to find alternative...

I have 52 weeks as columns and 30 products as rows. There are 3 machine machine 1, machine 2, machine 3. Each product takes certain amount of time on each machine to get completed. Sales W1 W2 W3 P01 xx xx xx Processing Time in minutes Product Machine 1 Machine 2 Machine 3 P 01 0.6...

Beginner VBA user here. I'm getting a runtime error that says "Out of Memory" with one certain set of code. I have one specific worksheet within a workbook that contains 4 rows each valued as the days Monday, Tuesday, Wednesday, Thursday respectively in Column "A". The nature of the worksheet...

Hi All, First up I love these forums, I'm a bit of an excel geek and I love to learn. I'm still quite new to VBA and am really enjoying learning - but I wouldn't claim to fully know what I'm doing with it yet :P I'm currently trying to build a code to clean up orders which come in for our...

Hi, I have a workbook in which users are supposed to give in a lot of data, which then can be exported as a .csv and turned into a nice-looking pdf report including graphs etc. The pdf is generated via a .exe file that a colleague of mine programmed using Processing. When I open this exe file...