I have information in the following format:
A1 - 2/29/2008  15:00:00 PM
B1 - 3/3/2008  3:42:00 AM
I am trying to calculate the hours in between and come up with a numeric

I have three tabs within one spreadsheet, Column A holding the same data,
I.E. Last Name.  I need to know if the Last Name is found on the other tabs.  
Here is the formula I have so far:
=VLOOKUP(A2,DEC!A1:O94,1,TRUE)

Dear All,
  Kindly I have data in sheet 1 & data in sheet 2, I need the data which is
not matching to be transfer to sheet 3.

I am trying to set up a spreadsheet to track the scores for our pub quiz
league (!)
I want to be able to input the scores and have a formula return the team's
position in the quiz - eg who was first, second, third etc. I'm sure there is

Please can anyone tell me what formula to use to calculate how much 17.5% of
a figure is.
I have 3 columns - Net Amount, VAT, Gross Amount.  I need it to calculate
the VAT of the Net Amount & then add the Net Amount & VAT together to give me

I'm trying to set up some spreadsheet exercises for some students who are
studying Excel at an intermediate level.
One of the problems that they have to solve involves entering an IF statement
in cells F3 through to F10

I need to format the results of a =DEGREES(ATAN(x)) formula to be in Degrees
Minutes Seconds format. I don't want to have to do decimal degrees, not put
the results in 3 different columns (which I have done in the past).

The cells in the formula below contain formula themselves; could this
be why it is not working?
"False" is being returned whether or not the values of each of these
cells are zero.

I'm sure this can be done so pls assist...
I have to worksheets.
The first one has two columns: Old Label and New Label.
The 2nd worksheet has several columns and i want to do a search in a

I have a specific problem. Your timely help will be greatly appreciated.
I have a text in a form of paragraph in A1 (eg., The BlackBerry e-mail
system is still unmatched. I set the service up with Gmail, Microsoft
Exchange Web Access, and  Yahoo! Mail accounts within minutes. The ...

Is there a way to cut part of the text in one cell and put it into another?
For example, if I have a dropdown list in cell B3 that includes both an
account number and an account name. I would like cell C3 to take the account
name from cell B3 so all that's left in B3 is the ...

Hi;
1) The following formula returns TRUE or FALSE:
=AND($J$15<>"",(MOD(SECOND(NOW())-1,6)+10) = COLUMN())
It works fine as long as the w/b is busy doing something!

Is it possible to put multiple IF functions to one cell? For examples, say I
want to assign different descriptions depending on what value shows up in a
cell.

I want a function to return the day of the week in text not integer (ie
"Tuesday").  I've tried the TODAY and WEEKDAY functions but must be doing
something wrong.  Can you help?

If the time is, for example, 1:30:23 (h:mm:ss) and the miles are 30, what
function would you use figure it out?  
Thanks for any help,
Russ