intervals

Hi, I have the following data: Excel WorkbookK1Wait...

Hi, I have a chart that I need to display 08:00 to 17:30 in 10 min intervals, the source data for the x axis is in this format but I can't get it to replicate on the chart? Any help would be appreicated

Dear all, For time-sheet calculation purposes, need to determine the number of hours shared between two time intervals; in this new case, I need to correctly determine the values in cells H17 & H18. Some background: I need to calculate multiple hours a shift 'shares' with multiple 'Periods...

I have created a histogram for data that is collected in unequal intervals (grouped data). I determined the frequencies and used the bar chart. I want to change the widths of some of the bars to different widths. I can find the following -- I click on one of the bars and it shows a width on the...

I'm trying to find a formula to return a value that represents the count of intervals at a certain increment size within a range. For example: <tbody> RULE FROM TO BY 1 12 90 6 2 2 5 1.75 2 4 50 3 </tbody> Rules: The returned value must include the starting point "FROM" value as a count...

Hi, I know you can amend the intervals on the the X-Axis of a chart, do you know if there is a way to change the intervals on the data labels on the chart? So rather than showing up at every data point, it only shows up at every 6 interval units for example? Thanks in advance, LC

Hi experts :) I need to do some kind of strange operation on a large amount of data, and I hope to get your help Right now I have a table that report a value from that has on Y axe a set of times of the day express in 5 minutes (like 0005, 0010 and so on). and on the X axe I have a series of...

How do I highlight cells at intervals? Even better, how do I exclude all other data sets that aren't in my data interval? I have collected some data of temperatures rising and I want to see the rate at which it takes to increase 0.5 degrees. So I need to emit all other data that isn't within...

Hi guys! I need help regarding LOOKUP formula! I have a % commision Matrix. The rows & columns are an intervals data. Rows intervals data are organizated bottom-up (bottom the lower figure, up the higher figer). How I can get the the % of commision that one saler will get acording his...

Hi, The issue I'm facing is quite complicated to explain so please bear with me. Hopefully the example at the end will help. For accounting purposes I need have a few financial instruments (which you can think of simply as loans with an interest amount paid either annually or quarterly or...

Hello I've trying to calculate the intervals for a workday, where the hours have different categories/earnings. For instance day;IntervalStart;IntervalEnd;Category Mon;08;17;A Mon;17;20;B Mon;20;08;C Tue;08;17;A Tue;17;20;B Tue;20;08;C Wed;08;17;A Wed;17;20;B Wed;20;08;C Thu;08;17;A Thu;17;20;B...

Hi I am trying to create a formula/VBA that will return the values (text and numbers) that are within a interval. Fx <colgroup><col><col></colgroup><tbody> Adress Yield test1 1% test2 2% test3 3% </tbody> If I search in the interval: 0.5% - 2% it should return Adress...

Hi folks , I have an excel sheet with 3 columns Column A : Data that needs to be poped on a message box with a yes no button column B : Start time column C : End Time What i need is as soon as start time is reached a pop up should be displayed with a yes no . On click on NO button ...

Hello, I have 50 to 100 sequences of 200 letters long or more in a column of Excel. I'm trying to add a space every 10 letters such as: QWERTYUIOPASDFGHJKLZXCVB...etc into QWERTYUIOP ASDFGHJKLZ XCVB...etc Formulas I tried stopped after 10 characters or self-formulas replaced letters by space...

Hey there! So I have some daily stock returns over about 8 trading years and need to split them up into 60 day intervals....how do I do this? THANKS FOR HELPING :)

Hi, I am working on a maintenance schedule. Every 250, 300, 500, 1500, and 3000 hours a PM is due. I'm trying to make it so as you input the hours for each peice of equipment there is a check for each type due and at what hours it is due. Hours due is where my trouble begins. I can use the...