1. ibmy

    How to structure the formula properly?

    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...
  2. W

    How to remove repeating time intervals?

    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...
  3. S

    Help with IF formula

    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
  4. O

    Generate round to nearest 2 interval (text) from 2 values

    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...
  5. F

    auto fill with specific interval numbers

    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
  6. F

    Excel Chart x-axis label interval with start value offset

    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...
  7. T

    Insert Blank Rows Every Nth Lines (ie Breaks at 31, 61, 91, 121)

    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...
  8. D

    Need help converting 15 minutes intervals into 30 minutes interval

    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...
  9. I

    How to get two Trendlines to start and stop at two different intervals on a chart

    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...
  10. R

    Rank and Scores

    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...
  11. A

    Error retrieving getting data

    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' ' ' Contact...
  12. S

    Sending mails to a list of receipnts with a fixed interval of time

    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...
  13. C

    Summing a Value within a Specific Time Frame

    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...
  14. K

    Convert Schedules to Interval Staffing

    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...
  15. R

    Rounding time to nearest previous interval.

    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...
  16. K

    Loop+ Offset issue

    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...
  17. A

    Pivot Table - time row

    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...
  18. S

    Filtering: need one sample per minute, but have irregular time intervals

    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...
  19. W

    How to translate shift allocations to show count by interval

    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...
  20. M

    Update links in excel base on time interval

    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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back