# intervals

1. ### Returning Values for Date Intervals

I need some help with a formula and I've tried searching but not finding an exact match to what I'm looking for. Column A has hundreds of dates, past, present(today), and future. I need a formula that will tell me how many days old (by interval) any past dates are. The intervals would be 0-5...
2. ### Add to cell reference on multiple rows

I have a table that I have a lot of production numbers in at regular intervals, say 4/hr at 15min intervals. Each 15min interval is in a different row, all in the same column. How do I quickly populate a table where each hour is on a different row, four columns wide? I know the text =C# doen'ts...
3. ### Breakout total time into 15 minute intervals

I need a formula to take total time (from time in to time out) and extrapolate how many 15 minute intervals are in that total time. This is for determining how many units (15 minute intervals) an individual should get paid for. Any help is appreciated.:mad:
4. ### Calculate Next Occurrence (Date) Based on Varying Intervals

Hello, This is my first post so I apologize ahead of time. I was wondering if there is a formula that will calculate the next occurrence of a date based on different time lengths? I have found many solutions dealing with whole month intervals and weekly/biweekly intervals separately, but for...
5. ### Confidence Intervals using Solver

Hello Everybody I'm doing the parameters estimation of a model using the Excel solver with the GNG Nonlinear method. My question is, how can I get the confidence intervals of the optimized values? Thanks
6. ### returning number based on intervals

Hi to all in the forum, I have a doubt related with a returning number based on intervals. I have a table like this: 1-10 - 20€ 11- 20 - 17€ 21- 30 - 14€ and so on... The I have in one row a list of number 1 2 3 until 100. And what I want is until number 10 return 20€ from 11 to 20 return...
7. ### Convert Standard Date to Number of 100-Nanosecond Intervals Since Jan 1, 1601

I need a formula to change a standard date (ex: 6/1/2019) to the format Active Directory can use. The problem is that AD stores date values as the number of 100-nanosecond intervals that have elapsed since the zero hour of Jan 1, 1601. I've found several places that tell me to use this formula...
8. ### Change 15 Minutes into 30 Minutes Intervals VBA

Im struggeling with a macro which needs to convert 15 min intervals to 30 min Original data looks like <tbody> 00:00 2 3 5 00:15 2 1 4 00:30 5 2 6 00:45 5 3 4 01:00 7 4 2 01:15 7 2 3 </tbody> and I would need such an outcome somewhere right or left from the original <tbody>...
9. ### Formula Help

I have a table that counts how many people have presented on a certain date in hour intervals. I use the following formula to gather this data: =COUNTIFS('Patient Summary'!B6:B453,"21/7/2018",'Patient Summary'!C6:C453,">=02:00",'Patient Summary'!C6:C453,"<03:00") When writing the formula I...
10. ### Is there anyway to set non fix intervals in x axis

Ob excel chart lets say i want the first three intervals five units apart namingly 5,10,15 then i want the next three intervals 10 units apart like 25,35,45 would this be possible? Thanks alot for he help.
11. ### Scatter Chart? Bell Curve?

I have likert scale data: -29.0 through +29.5 I have four different likert scales that need to be graphed in some manner. the original thought was to create a bell curves to demonstrate the commonality of each set of data. - - That has proven difficult, or impossible as I cant figure it out...
12. ### Adding up in time intervals

Hi there, I'm trying to add bits of data up in the table below so I can see the total at different 15 minute intervals and then plot it onto a graph, I've tried using sum and sumifs but the formula doesn't seem to work! Any help would be very much appreciated. <tbody> Start Time End Time...
13. ### Merging 2 Tables - Matching Intervals

Hey MrExcel. I have ran into what I consider to be a rather complex problem. I have millions of lines of data that I need to merge into a single sheet, however it is not as easy as simply copying and pasting the columns next to each other as intervals are missing. I should mention that case...
14. ### Easy way to mass conditional format?

Good evening, First off, I would just like to say a big thank you to everyone who contributes to this forum. You're help has been much appreciated. I'm trying to develop a visual chart for employee staffing and I'm wondering if there is a easy way to conditional format numerous cells on a mass...
15. ### Formula to extract data from report with daily results that excludes data if no volume for that day

Hello, i have a report for call volume by interval, the report will exclude data if no volume on the day, the problem i'm having is the work group name and time intervals are in the same cloumn Column A | Column B | Column C workgroup a | totalcallsoffered | totalcallsanswered...
16. ### Splitting activity duration by half an hour intervals

Hi, Could you please help me with the following task: have a long list of activities and their start and end time. What I need is to split the duration of each activity by half an hour intervals as my example below. The blue intervals show beginning of each interval, for example interval...
17. ### Group Minutes In Defined Intervals

Hi, I have the following data: Excel WorkbookK1Wait...
18. ### carting time intervals on x axis

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
19. ### Time Calc: Hours shared between intervals

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...
20. ### How do you modify the widths of the bars in a histogram that has unequal intervals

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

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...