standard

I am attempting to change military time to standard time but am having issues when the time starts with a 0, for example 0327 is changing to 8:07 AM rather than 3:27 AM. Here is the current formula I have used, =TIMEVALUE(LEFT(G2,2)&":"&MID(G2,3,2)&":"&RIGHT(G2,2)). Any thoughts on how to...

Hey all, I am trying to set up "draft boards" for a youth sports organization and we run the drafts in standard snake order (see example below). I have to do this multiple times per year for for varying number of teams (sometimes as few as 8, sometimes as many as 22) and it gets tedious...

I need a formula to change a standard date (ex: 6/1/2019) to the format Active Directory can use. The problem is that AD stores date values as the number of 100-nanosecond intervals that have elapsed since the zero hour of Jan 1, 1601. I've found several places that tell me to use this formula...

Hi I have 3 values. Average = 100 Average+ standard deviation = 100+10 Average- standard deviation = 100-10 I want to draw a chart that show each value as below. The vertical value does not matter (I mean the line height). Is that possible . Thank you

To all, I'm looking for a macro that will start in cell D6 and see if the cell contains the word "Custom" anywhere in the cell and if so, highlight the column to the last row with data in it. I then need it to move over to D6 and repeat until it encounters the last column with data with it at...

I can calculate the standard deviation when the cell condition is above or equal to 70 using this formula. <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas...

Hi, I am looking to a way to import data from a list <colgroup><col span="3"><col><col span="3"></colgroup><tbody> cola fanta sprite 320 JAN CAR STANDARD EXTRA 12-Jan 13-Jan RETOUR USED 321 PIET TRUC STANDARD EXTRA 12-Jan 14-Jan RETOUR...

Ok I'm trying to get a lookup function within another sheet & I'm completely lost :confused: hoping someone can direct me.. current formula reads: =IF(ISNUMBER(VLOOKUP(A2,Expenses!$A$2:$E$21,5,100)),"YES","NO") where if the amount in E2:E21 has an output of 100, the answer would be yes. The...

HiAll Hoping you could help me achieve this layout I have a pivot table that stores the location in thr rows Either Office Home I have downtime Printing in values and Downtime standard in values too The problem im having is that Downtime Standard appears in both WFH and office I want to...

To all, I'm looking for a formula that I can use to look for a very specific number string in a column, that doesn't contain any other numbers in the cell unless the numbers are separated by "." and contained within brackets as these are used exclusively for dates, and then sum the column next...

I receive a number of data files each month from a number of different sources, and while they are all supposed to be in a standard layout (column headers and column order), they often aren't. I've written some code that checks to see if the values on the sheet match to either... - the...

Hey, I'm trying to create something in Excel so that we are able to know when our standards go out of date, as - for some unknown reason - this is not something that can be done online or via. a reliable service. Essentially, I have column with standards, ie. AS_4021_1 and another column with...

I need to nest a few IF statements into a VLOOKUP and I am having issue figuring out how to get this right. I have looked through a number of related post but haven't found one describing my situation. This is my current formula =IFERROR(VLOOKUP(A7,ElliotsPricingUpdate,6,0),"") The table...

Hi I have the following code on Sheet3 of my workbook. Unfortunately, when C16 is either left blank, or "standard" is inserted, nothing happens - i.e. it does not hide rows or columns. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.EnableEvents = True...

Is it possible to import other macros in the ribbon, than the standard ones from the personal macro book. The macro should remain in the ribbon. (I have some code in one VB Module saved on my drive). What is the easiest way of opening it in a standard way? If it could always be in the ribbon...

There are some of the Subs that when I call them from the standard module with my userform, I get errors so I have to place them in the userform module. I have not used the class module before. Can someone point out to me whether I am doing the right thing or not? Regards Kelly

Hi, I need help working out if a product is Standard, Medium or Large size based on the length, width and height dimension with the following restrictions: <thead style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font: inherit; vertical-align: baseline;">#C7E0F9[/URL] "] Standard...

HI, I have the following table: Excel WorkbookBCD10CODETYPERESULTS11DCPolicePolice12DCPolicePolice13DC#N/AERROR14DC#N/AERROR15STANDARD#N/ASTANDARDSheet1 I am trying to have the Results column as follows: 1) If the Code is not "Standard" and there is a word in column "Type", the Results...

Having trouble finding the solution to this if there is a simple one. My formula looks like this: =COUNTIFS(Model,$A10,Package,$B10,Status,"*DS*") But it is not returning anything. I'm assuming this is because B10 contains varying numbers with 0's in front like "01" or "02" but the Package...

Hello, EXCEL 2013 is there a way to do a STDEVA with a Match function without an array? I'm looking for a formula in column C. I have a large set of data (9,000 rows, 1200+ different instances of column a) with an unknown amount of instances in column a. I want to match column A to column be...