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...
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...
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:
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...
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?
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
until 100. And what I want is until number 10 return 20€ from 11 to 20 return...
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...
Im struggeling with a macro which needs to convert 15 min intervals to 30 min
Original data looks like
and I would need such an outcome somewhere right or left from the original
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...
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.
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...
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.
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...
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...
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...
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...
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
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.
I need to calculate multiple hours a shift 'shares' with multiple 'Periods...
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...