Hi Again All,
I have a slew of dates and times (measured out as far as seconds) in a
12-month range, and they need to be grouped as "Rows where mm/dd/yy tt:tt:tt"
is from 0:00 (midnight)-8:00am, 8:01am-4:00pm, and 4:01pm-11:59pm.  I have an

Can anyone figure out why this formula would not be working (all cell
formatting is in tact):
RANK(G6,G$6:G$130)+COUNTIF(G$6:G6, G6)-1
Thanks in advance,

How do I show the total of difference between two times in decimals (numbers)
to calculate charges.
Example: time elapsed between 10.15 am to 12.15 pm = 2 hours.
Suppose a charge of $ 3/hr to be charged the total to be charged would 2*3 =

How do you merge Excel Data into a Word Document and keep the number format.  
E.G. 150,000.00.  When I merge it merges as 150000

I just want to shade every second row in a large spreadsheet to improve
readability but without invoking a full style. How can that be done?

what is asap utilities can anybody give information about asap.
regards

Hello,  I am a second grade teacher and I just used an Excel Template to
create a gradebook based on points.  I love it so far.  I have one problem
though.  When students in 2nd grade are absent I don't usually have them make
up the test.  Thus I would like to note this in the ...

I am trying to set up an excel worksheet to calculate and charge for time
spent by computer users.
Can anyone help me?
E. Lewis

i have different database in different sheets i.e sheet1, sheet2, sheet3,
sheet4, sheet5...............sheet10,
in sheet 11 i used vlookup formula, i wnat to use the vlokup range for all
the sheet, if the value is not find in sheet 1 than find in sheet 2 or in

I have a pivot field
       Amount  Cases
Branch
a        100      2

Hi, when I apply an auto filter to a range and I try to filter by a certain
column, the filter does not show all the values in that column. How can I fix
this?
Tx

need that formula which i will put in F1 column
NOW HOW IT WILL WORK?
when i put any value in B1 Aswer show by F1 is 990
when i put any value in B2 aswer show by F1 is 980

I forgot how to to this, anybody remember? Deb

Does anyone have any suggestions on how to fit each cell into perfect square?
I would like to make each cell into a perfect square, but the lenght and
height for each cell used different unit. Does anyone know the proportion for
each cell between length and height? so I can ...

I have this formula in D1 for multi currency's calculation, following two
currencys I want let calculate with *(multiply) else should be / (divided)
A_1 has Currency name exp:> "JPY, USD, JMD so on...."
B_1 has Amount exp:> "100,000"