Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Sum Data For Time Intervals

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

View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Returning A Value If The Time Falls Between Two Intervals
I'm the Held desk manager . I'll have my folks logging in every time interval and work for 9hrs. Now I wanted to see at any given point a day the number of folks I have on my desk .

I have created table " A " and I'm looking for a formulae so that I get my data like table " B " .

To give more insight about table '" B " - During 00:00 - 00:30 , I'll have 41 people slowly goes down as people log off..

View Replies!   View Related
Getting A Macro To Run On Time Intervals
Below is the code i want to be run evey 2 minutes Thanks
Sub WebData()

Dim wSU As Worksheet
Dim wSR As Worksheet
Dim wSS As Worksheet

Dim iForRow As Integer
Dim iLastRow As Integer
Dim sURL As String

View Replies!   View Related
15 Min. Intervals To Incident Create Time
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?

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

View Replies!   View Related
Breaking Time Into Intervals And Performing A Count
Office 2003 with Windows XP

This is my first post so i may not have done everything correctly. I tried doing google searches to see if anyone else has done something similar but its a tricky thing to search for. I have found pages dealing with manipulating time but none seem to be what I want

I have an Excel sheet with data

C1-h1 all contain data (name, location, etc, etc) but I am not interested in those.

A1 (the date cell) is formatted like: m/d/yyyy" "h:mm:ss AM/PM


a2 = 8/1/2006 12:20:23 AM b2 = phone
a3 = 8/1/2006 12:21:13 AM b3 = email
a4 = 8/1/2006 12:33:03 AM b4 = phone

This is what I am trying to accomplish:
I want to break each hour, whether it contains data or not and get a count of the different types of source

my desired output would be:

time Phone email
to 2 3

My problem occurs because I am unsure how to break the times down into intervals. In my head, I would create a new column and try to break the time up into an interval. So for a2 (8/1/2006 12:20:23 AM), I think I would need to break the date and time up and then determine which interval would be needed based on the time.

I was going to perform the following:
=text(a2, "h" + if("mm:ss">30, 30,00)

Basically, pull the hour from a2 and evaluate the mins/secs.

If the min/sec is bigger than 30, put a 30 in the box. Less than 30, put double zero in the box. So for 8/1/2006 12:20:23 AM, b2 would have 12:00 since it falls in the 12 to 12:30 interval.

Once I have all the intervals, I would also need to preform a count on the source cell but I think I can use a vlookup to get the count for the interval.

View Replies!   View Related
Return Time Intervals Based On X Minutes
I have a spreadsheet set up that has a series of timestamps and values. Please find a copy attached. I need to set up a macro that will allocate the timestamp in column C to an interval of time, e.g between 12:30 - 13:00.

To achieve this I tried to set the following code up in VBA, which would input a letter in a blank cell based on the time interval that the timestampin column C falls into, for example if the timestamp is > 12:30 and < 13:00 then "A"...the plan was to extend this concept to accomodate all of possible the time intervals I have.

Sub time_intervals()

Dim x As Integer
Dim lastrow As Long
Dim timeA As Date
Dim timeB As Date
Dim timeC As Date
Dim timeD As Date
Dim timeE As Date

The idea was that the timemaster value would be the timestamp in column C of my spreadsheet and the timeA,timeB,timeC etc would reference the timeintervals. However this does not seem to work as the value returned by my if statement is always incorrect - for example timemaster in cell C2 is less than timeA but the if statement always returns FALSE as opposed to "A"

View Replies!   View Related
Run Multiple Macros At Different Set Time Intervals
The code from this page works perfectly when I am running one macro at a set interval: [url]

However, when I try to run multiple macros at different set intervals the order of execution gets messed up.

For example, I need macro1 to run at 00:00:30, macro2 at 00:00:45, macro3 at 00:01:00, then macro1 at 00:01:30, macro2 at 00:01:45, macro3 at 00:02:00 and so one.

View Replies!   View Related
Line Chart Showing Values Over Time Intervals
I'm trying to do a line chart showing two teams and their cumulative scores over the period of a game. I've attached a sample with mock data. Is it possible to change the x-series of the charts to display custom time intervals like 0 min 1 min, 2 min, 3 min, 4 min, etc? Currently the x-series only has labels for each specific time there was a change in value. I've tried to change the scale but the options that I want aren't there.

View Replies!   View Related
Continually Run Macro Code At Time Intervals
I am trying to continually refresh a spreadsheet (it is a countdown timer), and i am looking for a way to do this other than hold "F9". It is excel 97.

View Replies!   View Related
Creating 15 Min Intervals From Data
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.

View Replies!   View Related
Dynamic Sum Function (number Of Sheets Can Vary From Time To Time)
I need a sum function in A1 of a "Total"-sheet that totals cell A1 in every sheet with a certain color on the tab. The number of sheets can vary from time to time.

Any idea about a dynamic sum function that will do this, in combination with VBA?

View Replies!   View Related
Sum Of Time Values
I've a field on my database table that is of "Short Time" format. I've some values like this:


I want to add the whole record, to update the record and have the value of the field to show "0:25"

View Replies!   View Related
Change The Intervals
How do i change my data file from 1' intervals to 5' intervals?

The way it is now The way I need it
8300 8300
8301 8305
8302 8310
thru 11,000

View Replies!   View Related
Histogram Intervals
I'm making use of a histogram to visualize my data. The only problem is that 90% of the data has a value which lies close to eachother but 10% is very different.

For example:


Now the histogram I will obtain won't look very good. Is there a way I can have an interval like 40 - ... which resembles everything above 40?

View Replies!   View Related
Sum The Time Field And Vlookup
I need to sum the Time field, if the Temp Zone is = F. My problem is, as shown on the sheet, there are multiple days. As well, I need to pull the information for the totals (looking at 6 days worth of info) into another worksheet where the names (first column) are not in the same order, as some of the names are on this sheet, and some are not. I had a massively large vlookup statement, but of course, it's rather large and doesn't copy over well (when changing the days, it looses the last couple of lookups) ......

View Replies!   View Related
Graphing Time To A Sum Of Hits
I have a graph / time problem

I have a program that is spitting out raw data to me that I would like to be able to put into a graph form in a efficient manner, but I’m not sure the best way to accomplish this.

Here is what I’m working with:
I am getting a list of time date stamps that appear as follows.

11/30/2006 6:02:25 AM
11/30/2006 6:02:36 AM
11/30/2006 6:02:40 AM and so forth.

Each stamp represents a hit to a link.
What I would like to be able to do is graph the number of hits per hour verse the time of day hit. Showing the time on the x & the number of hits per that hour on the y axis.

I can convert the time to decimal, but I still need to find a way to get excel to graph the sum of hits per hour.

View Replies!   View Related
Sum Range Of Time Cells
When I input time in the h:mm:ss format it add a am/pm to it. I tried formating it to remove it yet it wont go away. What I am trying to do is add up time in the G Column but all I get is 0:00:00.. I added the [h]:mm:ss format to that cell... Does this have to do with Execl adding am/pm to the time? If it is how do I stop it.

View Replies!   View Related
Solver: Confidence Intervals
Does Solver provide confidence intervals around its parameter estimates?

View Replies!   View Related
1/2 Hour Intervals To 15 Minutes
08:00 26calls
12:00 50calls
16:30 16calls

The problem is the data is output as above just outputing intervals with data.

I need to convert this data to 15 minute intervals as below:

08:00 13calls
08:15 13calls
12:00 25calls
12:30 25calls
16:30 8calls
16:45 8calls

View Replies!   View Related
Find Out How Many Observations Are In Those Intervals
I have a range, intervals and need to find out how many observations are in those intervals...

RANGEINTERVALFREQUENCE-0.10773-0.10773-0.11 ?-0.10144-0.11 -0.05 -0.0983-0.05 0.01 -0.085110.01 0.07 -0.0810.07 0.13 -0.078760.13 0.19 -0.07580.19 0.25 -0.071360.25 0.31 -0.070750.31 0.37 -0.06930.37 0.43 -0.068420.43 0.49 -0.068060.49 0.55 -0.067390.55 0.61 -0.060030.61 0.67 -0.059350.67 0.73 -0.057470.73 0.79 -0.05290.79 0.85 -0.052570.85 0.91 -0.05190.91 0.97 -0.051340.97 1.03 -0.050011.03 1.09 -0.048051.09 1.15 -0.046941.15 1.21 -0.046411.21 1.27 -0.045311.27 1.33 -0.045291.33 1.39 -0.045061.39 1.45 -0.045021.45 1.51 -0.044341.51 1.57 -0.043321.57 1.63 -0.042231.63 1.69 -0.041661.69 1.75 -0.041441.75 1.81 -0.040051.81 1.87 -0.038661.87 1.93 -0.038561.93 1.99 -0.037811.99 2.05 -0.037112.05 2.11 -0.036272.11 2.17 -0.033292.17 2.23 -0.032872.23 2.29 -0.032672.29 2.35 -0.031322.35 2.41 -0.029372.41 2.47 -0.029262.47 2.53 -0.028292.53 2.59 -0.028222.59 2.65

View Replies!   View Related
Rearranging Columns With Intervals
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....

View Replies!   View Related
Transpose One Row With Intervals
I am trying to write a macro for transposing one row into multiple columns where the starting point for each column will be 15 cells starting from B4. I want to replicate the transpose for 200 rows.

View Replies!   View Related
Repeat Text At Specified Intervals
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
No. of Marks

With name ranges being, (for e.g.) P1QT, P2QT, P3QT. For three sets of papers for the "Question Title" range.

View Replies!   View Related
Histogram: Intervals Below Bar
I'm trying to make a histogram with the data analysis tool. The problem is that whenever I make a chart it doesnt show my intervals correctly. It puts them under the bars instead of between them.

View Replies!   View Related
VBA Code To See SUM And AVERAGE At The Same Time
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rng As Range
Set rng = ActiveCell.CurrentRegion
Application.StatusBar = _
"Current SUM is: " & _
Application.WorksheetFunction.Sum(rng) & " " & _
"Current AVERAGE is: " & _
End Sub

I now have the following problems:

I get a errot when i select cells with no number

Run-time error 1004
Unable to get Average property of the WorksheetFunction class

The sum and average stay in the status bar.

The code gets confused after i selected different columns.

I would like the code to work only when i select a range of cells.

Is it possible to move the text in the status bar more to the right?

View Replies!   View Related
How To Get The (average Or Sum) In A Limited Period Of Time
This code help me in typing the date and time in any cell of column (B) automatically just in case I enter somthing in any adjacent cell of column (A)

View Replies!   View Related
Sum By Time & Date Criteria
I have a spreadsheet with date/time in a column. Each date/time has a value associated with it in another column.

What I am looking to do is to sum the values that occur in an hour or less and have that summed value populate a cell in the proceeding column. Not concerned about values that are associated with durations greater than 1 hour.

Date/Time Value
7/27/07 5:33 PM 0.00
7/27/07 7:51 PM 0.04
7/27/07 8:28 PM 0.04
7/27/07 11:08 PM 0.00
7/27/07 11:57 PM 0.08
7/28/07 12:11 AM 0.04
7/28/07 12:23 AM 0.06
7/28/07 12:50 AM 0.04
7/28/07 2:46 AM 0.04
7/28/07 5:30 AM 0.04
7/28/07 5:27 PM 0.04

View Replies!   View Related
Chart Axis Date Intervals
I'm using Excel 2007 and I want to plot data vs dates. Furthermore I want the dates on the dates axis to increment by month not by a certain number of days. So something like this:


There's the Major/Minor Units on the Axis Options screen but I cannot type in a constant number since the number of days for each month is different.

View Replies!   View Related
Count Occurancies In Date Intervals
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?

View Replies!   View Related
Time Card & Sum Hours And Minutes
Just basic enter a start time in column A a finish time in column B and column C gives you total in hours and minutes and then maybe a way to sum those hours and minutes. how to do "Math" on time and how it should be entered (formatted) for it to work properly.

View Replies!   View Related
Sum Time Cells In Range With Empty Text
trying to add cells together that contain time (hours and minutes). The cell containing the total formula shows the #VALUE! result when and only when one or more cells being added do not have a value in them.

The times have been entered as actual times of the day, formatted for AM/PM.

A simple adding formula works fine, but all cells must have a value in them to obtain a valid result.

I attach a sample of the sheet.

View Replies!   View Related
Grouping Log In Times Into 15 Minute Intervals
I have been given the task of finding out who logs in at what time of the day.

I have attached the raw data that I have to work with.

In essence I need to see how many login's there were for 06.00 - 10.00 at 15 minute intervals e.g:

06:00 - 5 Logins
06:15 - 1 Logins
06:30 - 3 Logins
06:45 - 11 Logins

Has anyone got any suggestions?

View Replies!   View Related
Average Of Open-ended Column, Within Given Intervals
I need to average a column, without a fixed number of rows, and within an interval (and excluding zeros).

Example: Average of all numbers in the bracket 28-35, in column B2-B??

By this I mean that the total of rows in column B will vary from time to time, so in order to not having to manually change the number of rows each time, I need an "open-ended" formula, that also incorporates say 4 intervals (for instance 1-27, 28-35, 36-70, 71-100).

View Replies!   View Related
Fill Down The Spreadsheet, However The Dates Change At Different Intervals
I have a series of dates that I need filled down the spreadsheet, however the dates change at different intervals.

The best way I can describe it would be;

IF: Cell contains text
THEN: Copy Text
ELSE: Paste Text

Rinse and repeat!

My spreadsheet looks something like: ..

View Replies!   View Related
Insert Line Feed At Intervals In A Phrase
Each cell in Range("A1:A2000") contains a remark, each phrase or remark is
Between 5 & 70 characters all written without line feeds (carriage return,i mean Alt Enter) Just spaces between words. What I would like to do in every cell is to force a line feed (Alt Enter) every 10 characters, and if the 10th character happens to be in the middle of a word I want the line feed to be inserted at the end of this word. Note that the phrases are not necessarily multiples of 10.

View Replies!   View Related
Add And Subtract Date & Time To Return One Sum
I am trying to add/subtract dates and times to return one sum; but I only want to count the work week (5 days M-F) and work day (8 hrs.) 8am- 4pm. This is to compute the actual turn around time for a certain process.

Date ReceivedTime ReceivedDate ApprovedTime Approved10/1/20081:00 PM10/15/20089:00 AM

The total hours this process should equate to is: 9days and 6hours.

way to achieve this sum?

View Replies!   View Related
Total/SUM Various Times: Calculate Various Lengths Of Time Within A Column
Need a ormula that will calculate various lengths of time within a column.

For example: I would like to be able to add
02:43 (2 minutes 43 seconds) plus
01:10 (1 minute 10 seconds) plus
05:15 (5 minutes and 15 seconds)
..and accurately arrive at the sum of
09:08 (9 minutes 8 seconds)

Currently, whenever I input the value of 02:43- and assign the value of 'TIME'.. it reads it as 14:23 (clock time..not length of time.) I will only be using data that follows the format of mm:ss (minutes:seconds).

View Replies!   View Related
Stop Macros Automatically Running At Predetermined Intervals
I am using a macro that automatically updates data obtained through a DDE link at 5 second intervals. My code is based off of the article "Automatically Run Macros at a Set Time or Date" found on the Ozgrid FAQs found here:

However, I have this macro execute when I activate a Form Button, not when the workbook opens. So far, this macro works perfectly, and I have no problems. Although, I'd also like to include a Form button to STOP the macro from automatically running if the user chose to do so. How exactly would I go about making this STOP button?

View Replies!   View Related
Copy Columns & Paste Mutiple Times At Intervals
Code copies the first two columns of a many column table and pastes them at a certain interval (14 columns) to make transfer to a report easy. The problem is that the worksheets each have a different number of columns, but none more than 56 columns. The macro works wonders on the first sheet, but thereafter does not work at all. The first sheet has 27 columns, the second sheet only has 4 columns and the one after has 38 or something.

Option Explicit

Public iMaleGroup As Integer
Public iFemaleGroup As Integer
Public iMaleAnimal As Integer
Public iFemaleAnimal As Integer
Public iMaleGroup1 As Integer
Public iFemaleGroup1 As Integer
Public StudyTitle As String
Public SmallAnimal As Boolean

Sub CommandModule()

Dim Wrkst As Worksheet
Dim wsName As String
Dim wsSubject As String
Dim wsNumber As String
Dim rSummaryHeader As Range
Dim MergedHeader
Dim NextMergedHeader
Dim HeaderRange
Dim AddHeader
Dim TableHeader
Dim SumTableHeader
Dim PasteRange
Dim x As Integer
Dim n As Integer
Dim z As Integer
Dim i As Integer

Application.Calculation = xlCalculationManual
Application. ScreenUpdating = False ............................

View Replies!   View Related
Sum Every Nth Cell & Calculate Difference Between 2 Different Time Interval List
I have two sets of data, one is recorded every 5 minutes and the other is every 15 minutes. I am trying to add every 3 cells in the 5 minute column so I can compare it side by side with the 15 minute column. I have tried one of the responses in this forum with placing 0s in 2 cells and then the formula in the third however this does not allow me to compare the 2 sets side by side.

View Replies!   View Related
Count Number Of Times Specific Intervals Occur Between Relevant Values
I will say exactly what i want.

I want to keep statistics of roulette.

More specifically, i want to count how many times a dozen lates to come.

The range from 1-12 is 1st dozen, from 13-24 is the 2nd and 25-36 is the 3rd.

I want to count among these numbers, how many times one of three dozens appear every 1 time, how many times appears every 2 times, .... until 20 times.

For example: I have put in a column 500 numbers from 0 to 36.

The output must be like this:

1st Dozen: Every 1 time: x
Every 2 times: n
Every 20 times: m

The same for 2nd and 3rd dozen.

View Replies!   View Related
Sum Data By Criteria From Badly Laid Out Data
I am creating a graph which charts the most recent 3 years of YTD data, and right beside it, the past 13 months of monthly data. The data comes from two other worksheets and is brought in with an Index/Match formula, but to create the chart without having to go and update the data series every month the data to chart (in row 46 to 49 of attached worksheet) needs to change each month according to data in rows 2 & 3, and when the Year changes, in rows 24 & 25. I am trying to do this an offset, and/or vlookup, and/or counta functions.

View Replies!   View Related
Adding Time: Adding Individual Cells Works, But SUM Doesn't
I have a column of times: e.g. 10:03:00 and I would like to add them all up.

=A1+A2 works fine.

=sum(A1:A10) does not.

View Replies!   View Related
SUM MAXIMUM Or Index/Max: Count Number Based On The Maximum Time??
I was hoping that my formula would give me the count number based on the Maximum time (latest time) and the Name field...My result is a 0 instead of 62 (the correct answer).

=SUM((Download!$H$2:$H$10=A4)*(Download!$D$2:$D$10=MAX(IF(Download!$H$2:$H$10=$A4,Download!$D$2:$D$1 0)))*Download!$I$2:$I$10)

Would a Index/Match/MAX function be more efficient?

View Replies!   View Related
Sum Of Lap Times In Order To Give Race Time At Any Lap


Where C4 is 'Qualifying time', C5 is 'Starting fuel', C2 is 'Lap number' and C3 is 'Fuel consumption'. I also plan to make the 0.3 a changeable variable.

I'm not fussed as to whether or not this is a realistic function that would work in a real race, it's only hypothetical. However I would like to have a function that would give me the over all race time at any given lap, not just the lap time for it.

View Replies!   View Related
How SUM The Time As Format "h:mm" From Cells A1 To A250
how do i SUM the time as format "h:mm" from cells A1 to A250

View Replies!   View Related
Display End Time Automatically Upon Entering Start Time And Time Usage
I have a worksheet which contains START TIME in column A, then TIME USAGE in column B and END TIME in column C. User enters start time, followed by the number of time usage in minutes, how could i possibly display the end time automatically in this scenario? how do you add the entered time usage to the start time to display the end time? Say if I enter 1:00 AM at start time and 00:15 minutes on time usage, how can 1:15 AM be displayed on the end time automatically?

View Replies!   View Related
Draw Log Chart Or Edit Axis Intervals And Starting Axis Value
I have some numeric data that has to be put on a log chart. but there is no option for log charts. so i converted my data to log and then drew a chart but i am unable to edit the axis intervals and starting axis value. whenever i change the value it gets back to its default value,ie 1. can anyone tell me how to draw log chart or how to edit axis intervals and starting axis value?

View Replies!   View Related
Sum Up The Data
i have got data in column A1 to A100 week no 1 to 100 and in column B,C i have got some date. I want to sum at week 80 to sum 1 to 80 of Column b & C , on week 81 from row 1 upto 81 soon. How to do it what is required formula.

View Replies!   View Related
Sum The Data
I need to sum data for each branch contained in column I in a seperate worksheet. The data contained in column I that pertains to say branch1 is contained in several worksheet in column I.

What formula can I use to add all the values in column I pertaining to for eg Branch1

The branch names are in column C.

Can I use Sumproduct together with match and Index and if so how do I do this? Have tried this but cannot get it to work.

************************************************************************>Microsoft Excel - Brach Summing.xls___Running: 12.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutH4I4F5E7F7G7E8F8G8E9F9G9E10F10G10E11F11G11E12F12G12E14F14G14H14I14=CDEFGHI1   1   2  October 20062006 TB-INPUTTB-OUTPUT3  VALUE ADDED TAX RETURN    4    PeriodOctober 2006October 20065         MONTHLY RETURN FOR October 2006   6  VARTOT PER TBTOT PER VAT RPTTB-INPUTTB-OUTPUT7Branch1 5,603.595,603.590.0049,527.75(43,924.16)8Branch2 407,520.00407,520.000.00594,725.00(187,205.00)9Branch3 69,890.0069,890.000.00145,207.00(75,317.00)10Branch4 (666,769.00)(666,769.00)0.001,253,745.00(1,920,514.00)11Branch5 33,720.0033,720.000.0080,145.00(46,425.00)12Branch6 (82,069.00)(82,069.00)0.0043,478.00(125,547.00)13Branch7 -----14  (232,104.41)(232,104.41)0.002,166,827.75(2,398,932.16)15  -----Oct 2006 [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

View Replies!   View Related
VBA Code To Sort Data - Run-time Error When No Data To Sort
I havet he following code which sorts data. If there is no data to sort I keep on getting a run time error. Could I add something to my code to prevent the run-time error, as sometime there won't be any data to sort. The code runs when I switch to the worksheet in question.

Sub SortMeetings()
Dim iCTR As Integer
Dim yCTR As Integer
Dim zCTR As Integer

zCTR = 11
For iCTR = 12 To 23
For yCTR = 1 To 10
If Len(Range("D" & iCTR).Offset(0, yCTR)) 0 Then
Range("AA" & zCTR).Value = Format(Range("D" & iCTR).Offset(0, yCTR), "HH:MM") & " " & Range("D" & iCTR).Value
zCTR = zCTR + 1
End If
Next yCTR
Next iCTR
Range("AA11:AA" & zCTR).Select
Selection.Sort Key1:=Range("AA11"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
End Sub

View Replies!   View Related
Copyright © 2005-08, All rights reserved