1. L

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Group Minutes In Defined Intervals

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

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

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

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

Watch MrExcel Video

This Week's Hot Topics

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