Hello, i wish to calculate response times in business hours.
I have two columns of data; A represents the "call log" date and time; B
represents the "responded by" date and time.
I wish to calculate the time difference between A & B, but only in office

Anyone know how to set the X Values of a series collection item for a
HLC stock plot to a discontinuous range?
I can define a range using the Union function and set the X Values to
that range without an error.  But the chart is created with nothing

I have a series of numbers
1234
1236
1239

HI Group,
I have been asked to work out a risk assessment based on some of the
following grid/variables (there are 3 more to build...)
Loan    Rating    Weight    Item    Rating    Weight

I am using the below formula and it works a treat. However I want the
'FirstB.Address' to be input as a relative reference rather than the
default absolute reference. Could anybody offer any help as to how I
could do this? Many Thanks.

Is there any way to get the cursor to go to the first row of a filtered list
when Autofilter is used?
Thanks,
John

The below code populates a listbox for me, but i want ONLY unique values listed, currently i am
getting a few duplicate values populating in the listbox.
How can i remove them to ONLY display 1 value of the duplicate values ?
Private Sub ListBox1_Change()

I posted somehting like this last week, but the asnwe Irecieved was to use
SUMPRODUCT. Firs I am filtering the record set to match a date range.  THen
on that subset, I must use any of 3 to 10 different criteria in 2 columns to
determine if a record is counted.   So if a record ...

I've created a UserForm with listboxes:
ListBox1 loads all my open workbooks.
ListBox2 loads all worksheets in selected workbook.
ListBox3 loads data from WorkbookA starting with Range("C5") through

Beginning with row4 in ColumnE my data has CO125. I want to cut the CO
and paste it in ColumnF.
This is the macro I've got so far:
Sub DeleteCharacters()

I have a userform with a combo box and a commandbutton. The combobox
uses the .additem, currently it has 11 items but will be added to. My
UserForm_Initialize is below:
Private Sub UserForm_Initialize()

I have a database query that retuns data by date range. After the data is
returned
i enter in this formula in Columns G and H down to the last row of Data. Is
there a code to run a macro to do this

I'm running macro on excel file an i need to build conditional
formatting to a large amount of excel,
does anyone have faster way to populate the conditional formatting
beside running 2 "for" in order to populate the data?

I have a User Form with five check boxes.  The default setting for the
check boxes is FALSE.
When I open the user form and select some of them and then hit the
CANCEL commandbutton (the idea being that I dont want to make any

I have a spreadsheet where I add multiple entries every day.
Here's the layout:
Date         cust #      sale        COMM
For sake of ease, I add about 6 customers straight down the column.