half

Hi, Cant for th life me wr this one out.. I need to populate this table...

Newb here so bear with me if the answer is obvious! Situation: Trying to convert field of half hour with that contain no ":" to full hours using military time. It's relatively easy for half hours that contain four characters. Hypothetical Example: =left(text,[num_char]) for "1000" returns...

Greetings Folks, I just can't think of how to make this work, I don't know if I'm just mentally exhausted by working on a dashboard all day, but I just can't figure out how to do this. I have 12 columns for Months.. January - December. I'm trying to take a number and I would typically divide...

Hi there, I'm new to the Forum and an Excel novice so I was hoping someone might be able to help with my query! I'm interested to know if a word can represent a certain number in Excel? I have searched the forum for answers to similar questions and seen some responses regarding VLOOKUPS but...

Morning All, The status bar looks like it is in two halves ? or am i wrong (i can see a dividing line) I can put a message in the first part by Application.StatusBar = ("Updating Sheet Data Please Wait") i am wanting to put a status of something in the second half is this possible how? Can...

Hi All, Can I have a button in excel workbook that have one half assigned to a macro and the other half gives an error message. Thanks Asad

Hi all, I'm new to the forum so hi and Thankyou for any advice. I am currently working on a timesheet for my partner, the problem I have is the way the sheet works I have a column that accumulates any flexi time over 7 and a half hours but she has started doing half days on Wednesday only so I...

Hi gurus, I have searched relentlessly and cannot find a solution to my problem I have an excel workbook with 21 worksheets, If i run the VBA code for password removal i get the suggestion AAAAAAAAAAA, however this does not remove the protection on any of the sheets. I have seperated all...

Hi I have spent many hours trying to figure out what the following problem is and how to fix it: - Using Excel 2007 - Using a =SUMPRODUCT formula (long one) that I copied from another worksheet to Word and saved, then copied to Excel. The problem isn’t with the formula because it...

Does any one know the formula to calculate top half rows/ bottom half rows of column D, Simply by selecting ALL the rows in column D, as shown in the image (I am not looking for the =SUM formula ) i have several tables like this and sometimes the number of rows may be odd/even

Hi guys! I'm embarrassed to have to ask this but when I exported some data to a CSV for some reason half the dates in the column is General format and not in Date format. I tried changing the format to date but it makes no difference at all. It is driving me insane =/ Any help...

Hello everyone, new here and need some help! I have some wind direction data (0-360 degrees) for six sites on a mountain. The figures are averages from a raw data set. The data is based on seven readings (half hour increments 11:00-14:00). I would like to create a wind rose-type of radar chart...

I want to make Marubozu Candles in a cell (D3) Input cells: A3: Either 1 or 2 B3: Either 3 or 4 D3 Candle should be EITHER of 4 types: If A3:B3 combination is 1,3 then FULL GREEN CANDLE If A3:B3 combination is 2,3 then FULL RED CANDLE If A3:B3 combination is 1,4 then HALF GREEN CANDLE (HALF...

Is there a character I can add to a VBA line that is meaningless to the code? I want to temporarily make several several lines the same, but be able to use "find/replace" on half of them later.

I download the same excel report daily. Is there a way to open this report with the same headings/columns that I want to see. I am deleting and hiding half of the columns for my report

Dear Mr.Excel, kindly need your advice how is formula to COUNTIF function ? if I would like to : 1. I have data regarding annual leave monitoring for staff of company which there is a regulation internally that the staff could take annual leave for 1 day and half day. for half day leave will...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

So. Here is my dilemma..... All of my columns were returning #N/A, I figured out I had to convert my lookup value to numbers, so I did that. Hurrah, it worked, or so I thought. I scrolled down and only half the values populated, the rest are still #N/A. Now some of my lookup values in the...

Hi, On a daily basis I have to process documents where each page is divided into two. For example if I get a 24 page long document then the first page's right half is going to be the 13th page, the 2nd page's right half is the 14th page, so first all the left side of page is presented first...

I'm creating a video game that uses an 8 by 8 grid. I need half of the 64 cells to be black and half white. I'm using conditional formatting to highlight the cells white or black. I've got a randomizer to randomly make the cells either black or white. But, I can't figure out a way so that - no...