I've tried subtracting the hours, but it keeps subtracting from the date.
I've tried subtracting just from the time and that doesn't work either.

How do I put a vertical line in a chart in excel at a given point?  i.e.
timeline
Thanks
Jon

I have a conditional format that works fine on the previous version of
Excel, but not so well on 2007.
It is a formula condition: =AND($D$13 = "N",LEFT($D$6,2) = "AP")=TRUE
D13 is the cell with the conditional format in it and D6 is a drop

Is there anyway possible to create a Drop-down list that includes the dates of only the current month? If it's March I would like column A to only have March 1st through the 31st to be possible entries. When it becomes April, then April dates are only ones allowed, and so on. If ...

I can't figure this one out and need help. Sheet1 has names in col 1 and
values in col 2 -
I want to add totals together for everytime a certain name is found in col 1
in the sheet 2.  (Name is listed multiple times on sheet 1)

what is a database?

We recently moved to "visual studio 2008" . Our addin workd find on our
development machine which has Excel 2003 and Excel 2007. When we create the
installation package and install onto a machine with only Excel 2003 we get
the "runtime error '429' activex component can't create ...

When I import a file that originally had numbers such as "000123" in
excel, the number only shows 123.  Is there a way for me to get the
cell to show 000123?
Thanks

in excel 2003 we click on a point and after appearing an arrow we could
change its position to manipulate it. Meanwhile the table is corrected
automatically. In excel 2007 it is impossible. Do you please help me?

I am using the match and index function to pull in data from a
separate worksheet.  I am using Column A as the reference cell,
whereas my formula lies in Column F.
The formula pulls in the data fine. The problem is, when I sort the

it always converts to 10 when i type 0010 . .
how to change the setting ? ? ?
some excel pro please help me !

Hello - I have been too cheap to buy any excel add-ins or plug-ins,
and then recently I downloaded one (i.e., the PUP v6 toolbar), and
realized that it was worth much more than the $40 price tag.
I would be interested to hear some of your favorite add-ins (either

Count anyone shed some light on this issue.
I am using the statement
n = WorksheetFunction.CountA(Cells(i, 13), Cells(i, 17), Cells(i, 22))
I am trying to get a value for how many of the 3 cells have data in them.

am trying to vary the name of the lookup range depending o the result
of a 2nd lookup --
NYC            =vlookup(A1,range1,4,0)
LA               =vlookup(B1,range2,4,0)

Data Entry Outsourcing Services ensures high quality, result oriented
in time. We promise to deliver excellent output at low turn around
times and cost-effective rates. Our dedicated team of highly
experienced professionals to provide you high quality outsourcing