interval

HI all, I'm having an issue returning multiple results for a vlookup I'm using to tell me all instances that have occurred for a certain time period. What I have is a certain point in time in one sheet that I need to know all the downtime events that were occurring at that point in time. My...

Hello The function Application.OnTime could be use to refresh or recalculate a cell with the minimal interval of 1 second. Is there a way to have the function using a 200 milliseconds interval? Martin

I am not sure why I am having so much trouble figuring out the VBA code on this one; I am just trying to paste values 1 to 12 in Column B for each cell occupied in Column A. I know its most probably super simple Excel 2013 32 bit <tbody> A B 1 Category 1 2 Category 2 3 Category...

Hi everyone, I'm hoping I am not repeating a previous question (I did try to check). I am trying to collate data from multiple sheets based on the minimum interval with a key identifying field. I think this is best demonstrated with the example below: <tbody> sheet 1 ID attribute 1 attribute...

I have data from a datalogger which varies in the time interval it was collected, sometimes the data is collected every hour, sometimes every 15 minutes. Column A has date/time info (ex: 6/3/16 9:52:00) and Column B have the raw readings (ex: 0.00025). I would like to be able to create graph...

Hello all, I have a problem with the following: I have multiple columns of numbers, which are sorted in ascending order and can be of variable length and interval, but always start at 0. For this problem, I have selected 4 columns though. <tbody> 0.00 0.00 0.00 0.00 0.25 0.3025 0.1600...

Hi, I'm new to this forum and can't figure out how to do something. I have six years of data that contain dates for when certain events happened (dd/mm/yyyy). I need to create variables indicating when those events happened by 3 month intervals (quarters), BUT I need those quarters to range...

Hello there, Does anyone know if there's any way to adjust the <interval> argument of functions like DATEADD according to filter context? The argument takes enumerations, not text strings or numbers that would be easily swapped with some IF logic. At the moment, I'm doing things like this...

Hello, I have data for different time intervals for one month. <tbody> <tbody> <tbody> Start Time End Time Value 1 Value 2 1.1.2012 00:08 1.1.2012 00:18 12,3 13,4 1.1.2012 00:18 1.1.2012 00:29 14,6 12,5 1.1.2012 00:29 1.1.2012 00:39 8,7 9,6 </tbody> </tbody> etc. I want to create...

Hello</SPAN></SPAN> I need your help!:confused: I have Excel 2010.</SPAN></SPAN> I wish to group my values into intervals than I want to add a mark which later discribe the position of the value.</SPAN></SPAN> I have two values in %. The 1st is from the Low Yld and the 2nd from the top yield...

Hello Excel Gurus, Can someone help with a bus day interval calculation involving WORKDAY and NETWORKDAYS calculations? If the status of the query is "Closed" and the end date is greater than the set interval, then show the number of days the query is late. If the status of the query is...

I have 30-day data running from (eg) 16/04/2013 to 15/05/2013 to display on a graph. Since having intervals of 1 day on the x-axis overcrowds the labels I want intervals between them. However, I want the latest date (15/05/2013) to display on the right and the intervals to work backwards to the...

Hi guys! Please let me know if I can convert a particular number (e.g. 5) into an interval (1-5) and if I can count them as follows: Column M Column N (Number of pages) (Number interval) 2 1-2 5...

Hello all, I was wondering if there exists a neat effective way of calculating the number of days two date intervals overlaps? Example: Interval 1: 5. jun 2011 - 21. jun 2011 Interval 2: 10. jun 2011 - 15. jun 2011 Interval 3: 1. jan 2011 - 30. sep 2011 Intersection( interval 1, interval 2 )...

Hello, Help! I am trying to sum up 10 minute interval data into 1 hour. I need to do this for the whole month of October and I have no idea how to do this or if this is even possible in Excel. Any advice is much appreciated! 14:00-14:50 would be the full hour. <TABLE style="WIDTH: 144pt...

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 All Hope you can help me.. I need to copy a range of cells (A3:J43) and then to paste it 7 rows under the previous paste. This need to take place 100 times. In other words: Copy 40 rows Jump 7 rows (from the last cell of the range) paste the 40 rows jump 7 rows (from the last cell of the...

I am trying to grab the value of a cell every time it updates and copy that value and store in a new cell. So I have a cell (A2) and it updates every 60 seconds, I need that value for t=1 (first time) to be copy and pasted into a new cell (B2). Then when t=2 (second time, 60 seconds later) I...