half

Hello Everyone, I was hoping someone could help me with what should be a simple problem, I have been racking my brains for a solution I cannot work out. A have alist which contains a max of 28 names. Some weeks I may have full 28 names other weeks I may only have 14. I would like the...

Hi, I’ve been developing a spreadsheet given by a colleague that allows me to track annual leave, time off in lieu etc. The spreadsheet has been broken down to either note full day, half day am and half day pm. I have 5 categories where someone could be absent either for the full day or...

Hello All, I want to be able to separate out this data and allocate it to daily HH segments. For example ideally I would be able to pull out the data in B3 (16:00-19:59) To show 16:00 and 20:00. And then multiple these values by 2. As this data sett would fall between the 33rd and 40th half...

Hello In sheet1 i have data in column A through I as below: Excel 2016 (Mac) 32 bitABCDEFGHI1nameStartStopData AData BPoint APoint BPoint CPoint D2XYZ01/09/16 04:15:0002/09/16 13:25:001234678901/09/16 04:35:0001/09/16 04:43:0002/09/16 12:27:0002/09/16 12:39:003Sheet1 i want to loop through...

Hi, I have a start date and time in C1 e.g 01/07/2017 16:25:00 (date is in DD.mm.yyyy format ). In D1 I have an end date and time e.g 01/07/2017 22:15:00. The day is not relevant and is always the same in both cells. I then have the day broken down into half hour chunks eg A2 has 00:00 and B2...

Morning All, I have a drop down list in cell C33. When I select an item, cell C36 is filled and the next 2 column cells D36 and E36 auto fill by using VLOOKUP. Cell D36 contains code number and E36 contains the rate. Half of the list from cell E36 have precise rates (like 0.01%, 0.025% etc) and...

I have a workbook with about 120 sheets. I need a macro/vba that will search through half of these sheets and delete the entire row if it contains #N/A. The other half of these sheets also contain the #N/A, but I don't want it deleted in them. Thanks

Hi there, i have recently realized how much fun & time saving it is to use VBA macro writing for reporting purposes. i am an operations analyst, and would like to automate all my reports :) (if i could). I need help writing a macro to pull in info from multiple sheets with each #ed sheet's...

Hello everyone my name is Brandon and i'm new here. I am having a problem with coming up with a formula and was hoping someone could help a new person to excel. I have made a spreadsheet report that splits up a 8 hour shift in half cause we our overtime is done by half shifts. I was hoping...

Hi All, Trying to format a line chart based off of Actual, Forecast, and Budget data. I have an Actual/Forecast line, which I would then like to have half one color for Actual and half another color for forecast, based on I am in the year. I'm having a difficult time figuring out how to do...

In it's most simplest form my need is simple... I have a cell that contains a "note field". I would like to search inside this note field and pull out a date that is before a specific sub-string. It gets tricky when I start to break it down and try to actually make it happen, however. The data...

I have stock trading results in Columns AX through BD (hundreds of rows). I need formula for Columns BE through BI that will let me rearrange the data as shown. Essentially, I'm taking data that's presented as 1 row per symbol and converting it to 2 rows per symbol then rearranging the data as...

Hi I have a quick question regarding the if function combined with the left function. My data set looks like this. I only need the left side before the deliminator but with a filter. 88-9999 98-1120 102-1100 102-1200 104-1200 104-1165 I currently have this to separate the first half...

So what I am trying to do is delete unwanted rows in one Sheet if they do not meet the validation values from 2nd sheet. I have a tag list with tags that are associated to a system. Some systems are not part of the project so I need to purge these from the excel list before I can run a status...