Column A is Names, B is H for Holiday (Mental reminder column) I have column
C (Monday) as a time for a person to work. IE: 09.30 - 12.00.
The next column (D) I want to show how many hours that is as in 2.5 etc. Do
I use the Time function in C5 and if so what calculates it in D5 ...

Is it just me or does Excel 2007 not handle the leap year.  I had a
sheet where my header labels were dates every two weeks using date +
14 days.  Feb 15 + 14 is the 29th, not March 1st.  Running 2007 with
SPs

Where is the Magnifier in Excel?

How do I get Excel to automatically make the highest value in a given row to
be one color, and the lowest value to be another? For example....I enter in
daily prices for certain products. After ~7 days, I want the highest price
for that product during the week to be red, and the ...

Hello, I have a spreadsheet with 8 columns - a list of names in column A and
dates in column B (other columns contain data that I don't need). The
spreadsheet is appended each day with the same or a new name and another
data so there are about 100 rows for each day. I am trying ...

Is it possible to have a formula with standard Excel function that gives the
Min value without the zero value ?
Ex
        Col A

Hi--
Just downloaded the ProfitandLossStatement.xls template and am using it on a
Mac (sorry!).
So we depreciate about 35,000 worth of computers purchased in 2004, and I

I need a formula;
A1:M1 have months, Jan...Feb...March...etc.
A2:M2 have dollar amounts,
I need to fill A3:M3 with these dollar amounts only if it is the current month.

Is there a quick way of turning text that is on multiple rows into one row,
one problem that have with this, is that I have text say in 4-7 that I what
all in row 4, then the next maybe row 8 & 9 into row 8, then the next maybe
row 12-14 into row 12 and so on. They is no pattern ...

Hello- I'd like to be able to create _several_ (hyper)links to _one_ set of
data, with each link providing a different filtered view of the data. The
"AutoFilter" functionality can display the data in the way I'd like to see
it, but needs the filter criterion to be selected from ...

I am using Excel 2007 and utililize fill colors to color code various reports
which are sent to users running Excel 2003. I am saving these files in
compatibility mode before sending them out. I am having problems with the
fill colors I am using in 2007 not displaying correctly ...

I am downloading data into an Excel file using the Tezxt to column
feature. Some cells in the downlaoded tabble appear empty, but
actually have spaces in them, ranging from 3 to 15, depedning on the
width of the column in the original program. If I leavcew them in, the

I'm using Excel 2003. I have a list of 400 numbers in Column A,  I would like
to transpose it across 7 columns and 58 rows.  Is there an easy way to do
this?  I understand I can do the copy/paste special/transpose for 7 at a
time.  Thank you.

Is there a way to set a format style to the comma on the formatting
toolbar?  It has changed from what I had previously, and not sure why.
TIA
Gerry

I've got the following code in personal.xls (ThisWorkbook) to set calculation
to automatic and set iterations to true.  Code works great...but I'd like to
insert some additional code to make personal.xls hide itself.  I was thinking
perhaps another XLApp statement added somewhere ...