I'm trying to determine how much time our agents are spending for their lunch/breaks during 30 minute intervals. Range A8:A200 lists the agent's names, Range B8:B200 lists their lunch/break start times, Range C8:C200 lists their lunch/break end times, and Column E lists the times (8:00, 8:30, 9:00, etc.). If an agent starts their break at 10:57 (Column B) and ends at 11:10 (Column C), the value next to 10:30 (Column E) would have 0:03:00 and the value next to 11:00 would have 0:10:00. But would need to sum all the agents which took a break/lunch between 10:30-11:00, and 11:00-11:30.
I think I've had enough of using excel generated macro's as an excuse for decent code. I need to turn this:
Small procedure, function, what have you that will continue this pattern until I hit some kind of indicator to tell it to stop. This just clears the contents from 7 rows, hops down 9 rows and does it again.
I have posted earlier thread on similar problem but i did not get much response.I am really having a tough time to record a macro, where my columns will be selected with an interval and then will be pasted in to another sheet....
I would like to write a formula to average cells F27 - F11007 in a spreadsheet for every 96 values. That is, I want the average of F27:F122, F123:F218, F219:F314 and so on up to F10912:F11007. Ideally I would be able to pull down the fill handle and perpetuate the formula since this is a lot of data.
I've been trying to use INDIRECT and OFFSET formulas but I get a #REF! or #VALUE error.
I am trying to do is calculate (sum) results data for time intervals. For example, between 0500-0559hrs then 0600-0659hrs and so on. Data is collected at 1 minute intervals and may have a result of 0 or anywhere up to 30.
Column A has all time data e.g. 0500,0501,0502 etc Column B has sum of instances e.g. 0,1,2,3 etc
I want to create 15 minute time intervals from the data. I attached the file for reference. I would like to sum the data column that corresponds to each interval. I created an example using the formulas and I want to be able to do that automatically either using VBA or the formulas.
I want to set something up so the following text, is repeated at set intervals down the sheet, a number of times defined by an integer input box at the top of the sheet. Next to each new text array, I'd like to define a dynamic name range, calling each an increment above the one before. So:
Question Title Question no. Assessment Target Level No. of Marks
With name ranges being, (for e.g.) P1QT, P2QT, P3QT. For three sets of papers for the "Question Title" range.
I've been working on this for days, i still got no solution on what formulas I will put on cells in "To" tab. The excel file is composed of two tabs "To" and "From". We will convert the "From Tab" to "To" format. What formula will I put in D3 to V3 and drag down in "To" tab to convert datas from "From" tab.
I need to compare how many incidents are created within a 15 min interval and populate the sum.
I currently have the create time of the incident in the format below, assume each date below is an incident. I have a column with 96 intervals (24hours) ie 8:00,8:15,8:30,8:45,9:00 etc.... Using a formula how can I say "if create time is between *:00 and *15 count 1 and put the number into the cell and do that for each interval?
A B ------|-------------------| Int Incident 0 | 8:00 | 1/28/2008 8:32 AM 0 | 8:15 | 1/28/2008 8:35 AM 3 | 8:30 | 1/28/2008 8:41 AM 1 | 8:45 | 1/28/2008 8:46 AM
I have a workbook consisting of 4 columns where we log reported errors: Workbook1.xls DateNormalRelease Key Account Customer ID Columns B and C have either a value of 1 or 0 at the date stated in A. Column D is filled in only if the customer is a Key Account.
I also have a workbook where we manually inserts data from above workbook, amongst others; This workbook consists of 12 worksheets (one for each month)and includes these columns: Workbook2.xlsCustomer NameKey Account Customer ID Total Number of OrdersReported Errors. Is there a way to fetch all reported errors regarding a certain customer within a date interval and insert the value into column D?