Is there a way to convert a time number:  9:30   (9 hrs 30 minutes)
to a whole (w/fraction, or one decimal to the left)?   9.5
Thanks You!
Wayne

I need to track billing for a client, with 1/10th hour precision, and where
partial groups of 6 minutes round up to the next 1/10th hour (example: 8
minutes = 0.2 hours).   I have a start time, and an end time.   Then I
subtract one from the other and get hh:mm, such as 1:08 ...

I have a worksheet with data organized somewhat like this:
New York      New York
New York      Albany
Florida            Miami

All of my XP Office apps have been running fine since they were installed
years ago, until today. Suddenly and inexplicably...as of today when I try to
open Excel or any of my many Excel documents, Windows Installer initiates and
starts searching for set up files and then prompts ...

Can someone please run me through the drill to configure Excel 2002 to
always save a backup file when the original is saved.
Thanks,
Ron Patterson

Trying to get a column to auto-format numbers based on value - I've
done some Google searching, checked through newsgroup archives and
must be looking in the wrong place.
I have a variety of numbers from $146.0B to $.0093B using a Custom

I need a macro that will check out a given range( say a1 to z100)
As it checkd ther range(a1..z100) if there is NOT data in the cell, replace
the blank cell with $0.00
I appreciate all the help I am getting from this site

I run Excel 2K
I require a formula that removes the last 19 letters from a text string.
I have a number of varying lengths of text strings that require the last 10
letters being removed from each them.

I use VLOOKUP all the time but I now have a workbook with multiple
worksheets. Each worksheet has different product groups. Each product has a
unique product code (catalog #). I would like to retrieve three pieces of
data.

I have 3 columns that I would like to be merged in to one. For example:
b2=3 c2=4 d2=6, and so e2 = 3
                                    e3 = 4
                                    e4 = 6

I am working on invoices for my employer. Each row in the spreadsheet has a
calculated value. When the calculated value in the row = 0, then I am to
'hide' the row. If the calculated value is not =0,  (could be positive or
negative), then I am to display or 'unhide' the row. Does ...

I have 2 lists of students - both lists are exactly the same; in one list
certain students have a grade, in the other list all the other students have
a grade.
No student has a grade on each list; how do I end up with one list of

I have 2 pages
Page 1 is booking form
In page 2 I am doing this    ='Booking Form '!J11
This refers to a name on the booking form, however it shows ='Booking Form

Hello - I have a server inventory list that I'm trying to organize for
end users based on what group the servers belong in.  Some servers
belong exclusively in our "Staging 1" environment, some servers belong
exclusively in our "Staging 2" environment, and some are shared

I have a worksheet with about 2,000 records. I have a status field with 3
possible values - Open, Closed or Void. I have about 25 records in this
worksheet with a status of void. How could I copy ONLY those records to a
second worksheet? If I could do this automatically, this ...