I need some help with the time in a formula please.
I have this info in each cell:
Friday, September 14, 2007 - Sidewalk 65 -     8:00 PM - Tom & Betty's -
387-3311

I am doing a years budget. Sheet 1, I have created the ff tables: Variable
Costs, Standard Costs and Loan Repayment Schedule. Each of these contains
formulas which give out montly totals.
I have then created a 4th table for the monthly instalment (this table has

I have searched the Groups but cannot find a means by which I can call
the Window dropdown to allow a user to navigate between open excel
files to select the correct sheet for the macro to run on.
Basically, I want to be able to ensure that the user already has the

Hi,
I currently work with Excel 2003. There is a worksheet that has a password
which I did not create. Yesterday it was fine but today when I try to type in
the cells i get a message that it is protected or read only. I already tried

I get an excel sheet from our accounting department that I import into a
database for reporting.  The data is straight forward in most cases, but
today I noticed that there are a lot of rows that are duplicated except for
two columns.  Is there a macro or a way to run a script ...

I am having a problem with excel recognizing files that have been saved to my
documents folder. It will not open any of my excel programs from outside of
the program itself, only by clicking on the recent files list at the bottom
of the file menu. Can someone help, please. I need ...

How do I match a cell from one sheet to another and then in a different sheet
I would like only the matched cells displayed?

I have some columns that look like the following:
x    3   9
x   4    2
    6   3

I want column "A" to be numbered 1 to 500

I am using Office 2007 on XP SP2.  I am trying to get external Access data
from a database.  When I do a window comes up with Access Tables and Queries
(referred to in the window as View) in it.  However, not all the queries are
listed.  What determines whether a query is listed ...

I'm using Excel 2007 on Vista.
A worksheet with 3 charts (3 whole sheets) was created in Excel 2003. None
of the charts appear. Their sheets are there, but they're blank screens: no
background, no grid, no nothing. There are no active ribbon buttons while on

I have a four column worksheet - col A contains text for descriptions, cols b
thru d contain comma formatted numbers - 2 decimal places, the worksheet has
about 30 rows of data.  When summing col b thru d the total for each column
should be zero, the row totals can be various ...

I have a indexing statement to match up product codes but if there is no
number in the matched code it returns a 0, is it possible to use INDEX with
an ISERROR statement or Less than? I've tried many different ways to do it
and am unable to figure it out for myself.

I am trying to find if there are any duplicate values within the same
column, without removing them.  Example
ID no.
1121

Hi,  I have a list of titles and some titles have a letter A or B at
the end.. is there a function/formula I can use to remove them if it
ends in A or B?
For example (my list):