I need a function that will result in the number of hrs between two times. If
there is no data, then blank. How do I get the result in C1 as in below?
a1= "9-15-06 8:00 PM"    b1="9-16-06 05:30 AM    c1= 9.5

I have a spreadsheet of data that is set up kind of like a form in that, for
most of the data, I have 3 blank columns separating between each record.  I
am trying to simply pull the data into another sheet using a formula that
references the cell in the original sheet.  

I need to know how to write a conditional sum (or DSUM or other) formula
involving multiple worksheets(wks1-5) in a workbook.
Here is my failed attempt in wks1:
=SUM(IF(wks2DateColumn>=B38 and <=C38,"",wks2AmtColumn))

I have a single text file with many different pieces of data that I'd like
divided into individual worksheets. The text file looks like this:
Server - test1    O/S     Version      
oracle5             HP-UX   B.10.20      

I need help on how to transfer a large spreadsheet from

I tried to go to excel open a new document and all files I
went under d:drive to pull it up and when I clicked on the

I would like to set up a spread sheet. My objective is to assign a cell(eg
A1) a value, say 50, but also to have that value hiden.
Then if i was to type in 40 into cell A1 it would work out the difference
for me i.e. the cell(A1) would show -10. Or alternatively if typed a value

Can you help please?
I have a table where each student has sat 2 papers.  If they get 50 or
over it is a pass, if they get 80 or more they distinction and if they
get less then 50, it is a fail.  This works fine if they pass or fail

if I put down 7 am in one column and 4:49 pm in another, what formula do I
use to determine total time (9.81 hours)

I have a cell that displays an error message #DIV/0! (divide by zero error).
How do I hide this error message?
I tried Conditional Formatting: Formula Is  =ISERROR (the cell that contains
the zero).  But I get an error message that reads "You may not use unions,

Unfortunately Excel won't accept below formula and I can't figure out why.
Any suggestions? I'm using a European version so I know the ; dividing the
criterias are correct.
IF(B12<B4;0;IF(B12>=B4;IF(B12<=C4;((((B12-B4)/(C4-B4))*0,25)+0,25)));IF(B12>C4;IF(B12<=D4 ...

In excel 2000 sheet when I hide and save then open it shows as unhiden  
although I have hided is there solution to this?

I am trying to create an excel spreadsheet with a multiple function equation
at the end, but I cannot seem to get it to work properly.  
Here are the rules for the equation:
Rule #1: true if the customer's net worth is greater than $500,000, false

I need to rank the "% of inc" column but I get an error message (#N/A) on the
ones that have 0%.  This is the formula I'm using:
=IF(H6=0,"",RANK(H6,$H$5:$H$15)).  I've also tried
=IF(G21=0,"0%",(C21-G21)/G21).  What would you suggest?

I am trying to create a combination function.  I want to first sum specific
cells in a column and then if the sum is a certain value, I want the cell to
say "not met" instead of the sum.
For example, I want to put the formula into cell A1.  I want to sum A2:A5.  

Hi, I have two worksheets that have data in them and they are both in one
workbook. Sheet1 contains unique group names in B1:Z1 and unique user names
in A2:A256. Sheet1 is used to put an "X" in each cell where there is a user
that has access to a group(ex. B4 has an "X" because ...