I summed up a cell using the sum formula, then formatted it with [h]:mm.
Now i need to divide a real # with this formatted cell.  I need to find a #
of tasks per hour, is this possible?

I would like to know if you can convert years to MONTHS
in excel 2003. Help Please.
Cheers,
Ashley

I am using =INFO("numfile") to return the number of active
worksheets I have open.  This function is returning more
worksheets that I see active.  How can I return the names
of the active worksheets?

How do you copy rows of cells without the hidden cells?

I have a spreadsheet with multiple worksheets in Excel
2003. Everytime I populate a series of cells in one
worksheet, they populate to other worksheets in the same
cell locations erroneously.

I have  an average amount of waiting time for my vehicles
in F3 = 1:29 (1 hour 29 minutes)it is variable
What I would like to do is in cell J2:
divide F3 by 30 minutes and roundup so the result would

I am trying to make a match formula that matches an exact
number in column C with another number in column G.  the
match formula matches my number in column C with the first
number in column G.  I was wondering if it was possible to

I got the following formula from this newsgroup.
Private Sub Workbook_Open()
   Worksheets("Sheet1").Unprotect
   With Worksheets("Sheet1").Range("A1")

How many functions can be nested together? Currently, my
function looks like this:
=IF('Dec 11'!I33 ="P",'Dec 11'!$O$1,IF('Dec 18'!
I33="P",'Dec 18'!$O$1,IF('Jan 7'!I33="P",'Jan 7'!$O$1,IF

I would like to enter phone # in cell f, then in cell I, have it sa
state,and in cell J,give time zone difference:confused:
--
Message posted from http://www.ExcelForum.com

I am currently working on several Excel 2000 spreadsheets.  These spreadsheets are from 20 to 60 pages in length.  I am currently having a problem with the columns that repeat at the left.  It seems that when I reach a certain point in the document, Excel adds a line to the row, ...

I am doing a statistics project and have collected numerous dates o
birth. However I do not know how to automatically calculate their age
from a set date. ie 29/01/04 whilst retaining the original data
It is pretty urgent so if you have any idea ..

I have 2 columns containing names (Last Name, First Name
in each).  Column B is my primary data. I need to see if
any names in column B also appear in column A.  Can
someone give me some suggestions on how to accomplish

I need to create a hyperlink to a web site that provides
live data (meaning it is up to the minute information).
I am using the HYPERLINK function =HYPERLINK
("Website","Live Report")

ok i want to sort files to different pages, this is how it is set up
Logon cbourassa YORK tue date/time
Logoff cbourassa YORK tue date/time
Logon cbourassa YORK wed date/time