interval

Hi, My objective is to identify (assign "1") the current row (interval) if it overlap from previous rows (intervals). I have found the formula (thanks to these 3 sites : #1 , #2 , #3) but the problem is when there is a row (interval) that do not overlap (stop assign "1") and start new identify...

17:58:282020-08-02LocationDim LevelCHANGE17:57:092020-08-02xOffOn to Off17:06:452020-08-02xOnOn16:45:362020-08-02xOffOn to Off08:15:032020-08-02xOnOn02:43:522020-08-02xOffOff02:33:502020-08-02xOffOn to...

Hi guys, I really need help to set up a logical solution to this. In 'Value' column I want to have a value based on time interval. If a time interval in a cell in Sheet 1 falls inside a time interval in Sheet 2 then take the values shown in Sheet 2, otherwise 40. See image. THANKS FOR HELPING

Dear experts, I am trying to convert an excel formula into M for PQ but I think it cannot be done. I need to generate an interval (of 2's) from 2 values. First Second Great result Ideal Result 2.5 12.5 6-8 2-4;4-6;6-8;8-10;10-12;12-14 4.2 13.2 8-10 4-6;6-8;8-10;10-12;12-14 8 1 4-6...

Dear all i want to fill series with specific intervals for example auto fill with 2 interval auto fill with 3 interval 85 85 85 85 86 85 86 86 87 86 87 86 88 87 88 87 89 87 89 88 88 88

Hi everyone, I got this bar-chart with x-axis labels of which I only want to show every 3rd item, but I also would like to start at the 2nd item of the list. now I got 1,4,7,10,... and I like it do show 2,5,8,11, but still chart data from 1, just the label needs an offset of 1. (VBA...

I have yet to see a solid solution about this: I need help making a macro that can insert 6 blank rows, every 60 lines. I have tried the one developed by Kutools shown below, this code will insert 6 blank rows, count another 60 and then insert another 6. This causes my data to break at (61...

Hi everyone, I am trying to convert a 15-minute interval export into a 30 minutes interval and sum up the different values (Total 1 - Total 9) within that 30-minute interval. The data table is as below: Text Date TIME_Interval Split_Number Split_Name Total 1 Total 2 Total 3 Total 4 Total 5...

All; I researched and trialed different options on this for awhile, I am not a charting expert but what I'm trying to do is chart two separate trendlines for two separate time intervals but only show (and have the trendline effected by the data of that interval. Below is the data and where I...

Hi, I´m fighting against an elusive formula to assign scores, I have tried to use arrays and combinations of functions seen in old posts... with no positive results. I have a long list of rows of concepts, each of them related to several values that appear in columns, so they must be compared...

Can I receive assistance resolving an error running this code... The code is suppose to retrieve intraday prices. I email the author, but never received a response. Greatly appreciate the help. Thank you kindly ' Samir Khan' http://investexcel.net ' simulationconsultant@gmail.com ' Contact...

I have a list of clients to which i need to send mails. However due to service provider restrictions, i can send these mails at an interval of 10 secs only, or else my domain gets black listed for spamming. I need a VBA code where the comman mail body is used to send the mails to a particular...

I have a file that contains values gathered at 15-minute intervals for an entire day for hundreds of meters. I need to sum these values by each hour for each meter. Most of the entries contain values for each 15-minute period in the each hour (0:15, 0:30, 0:45, 1:00), but not all show all four...

Hey, i want to convert a schedule into interval staffing with VBA. How to start this project? 1. Read the data into a array. 2. Calculate each shift duration. 3. ???? Please help me with some guidelines. I dont expect to receive here the full code but at least information what I need to...

Hello Everyone, I am attempting to rounddown the time to the nearest previous interval. I have some data in excel. It logs the start time of a bar. Eg the 16:00 bar begins at 16:00 and completes at 16:00:59 Now when the time is at 17:20 I would like excel to look for the time 16:00 (starting...

Hey, what is wrong in the code below. I need to receive a output like 00:00 00:15 00:30 00:45 but instead d I get 00:00 00:15 00:15 00:15 ---------------------------------------------------- Dim interval As Range Range("E6").Value = "00:00" Set interval = Range("E6") For i = 1 To 95...

Good morning, We recently upgraded from Win7 to Win10 and i'm trying to prepare my monthly metrics report. Typcially, I extract a file from our data system, clean up the noise, and then insert a pivot table to get summary information that I need for reporting. The data has a column for date...

Afternoon.... I am doing several oven temp analysis over the next couple weeks. My data is coming from two instruments, and I need to merge results to compare. One unit I can control the time interval, and have it set for once a minute, ez pee-zee The other one...well I get what I get, and...

Hi, I have the total number of employees allocated to each shift, what is the best way to formulate to show the count of each employee in an interval for each day of the month. M-F 8am -5pm-: 20 employees M-Sat 6am -3 pm, with wednesday off: 10 employees How do I formulate this show I can...

Hello, I need help with a VBA code to update links in excel. Id like it to update every 5 min. The links will be between 2 different excel workbooks. Any help will be appreciated