I am not sure if a similar questions has been posted before... I did
search but couldnt find.
I need the difference between two dates/times field in hours or
minutes.

Formula that sums only the numbers in a range and ignores text

how do i auto sort columns by clicking on header name

Good evening,
Has anyone addressed the following issue:
- In A1, I have a hire date
- In A5 to Z5 I want to display the 24 months based on the hire date

I have a roll of paper that has to be slit into 3 different widths, may be
more than one lane of each width.  Lets say 5", 10" and 15".
I need to decide the best layout of the slitters that will be slitting this
parent roll to ensure the least amount of waste.

in excel - Somehow my work sheets have disappeared. How do I recover them?

My worksheet is sorted by customer first, then product with different package
configuations.  Each customer can have 1 product or many products.  I want to
sort through each customer by name and when I get to the last row, insert a
space.  Then I want to jump over several columns ...

A co-worker of mine was particularly frustrated that she had multiple
spreadsheets she needed to work from, but was unable to cascade the way word
does which made her efforts all the more difficult.
Fortunately I was able to show her how to alt+tab between them which helped,

I have a worksheet similer to the following with data range names:
User     Item     Debit
Adam   Lunch    $1.70
Alex     Milk       $0.30

I am trying to figure out a function for interest only payments.  If it is a
$10,000 loan for 30 years with a 5% interest rate, what function should I use
to figure out what the monthly payment would be??
on another task, how would I get it to give me a positive amount for the

Here's my formula, but it is resulting unexpected.
=IF((NETWORKDAYS(A68,D68))=1,1,"")
I want to eliminate 'same day'.  So if the date is 1/1/06 in A68 and 1/1/06
in D68, I don't want a number but rather a blank.  My formula indicates 1

I am at a cabinet building company and we are needing to incorporate an
on-going column of accumulative totals, and they stay constant even when
other formulas that change the totals are changed or the other values
pointing to the totals are changed. I guess you could call it a ...

Is there a formula to convert inches to feet? (Ex: 67" to 5'7" and 75" to 6'3")

How do I perform a concatenate function?

I use Excel 2002 and I'm looking for a formula that will look to a specific
cell in a row of cells based on a value that comes from part of this formula.
I don't have a specific heading, like looking up the word "apples" in a range
and then returning the value below that, as the ...