I would like to write a formula where I would input the starting time of a project or customer call minus the finishing time and then convert that amount of...

In the entries below care was not taken in respect to case. Is it possible for case to automatically change to upper or lower case when enter or right arrow...

Hi ~ I've been asked to construct a timesheet where hours are tracked at 480 hour intervals. At each 480/hr interval, the employee is due for an evaluation....

I need actual two different formulas 1) The first is to count dates in months for start to current, but to stop counting if an end date is listed. - i.e. c2 =...

Is there a way to do basically a reverse of the conditional formatting - where the certain cells have a pattern assigned to them already, and is there a way to...

Hi All Does anybody know why the IRR formula doesn't appear to calculate when it is one of the output fields under the Scenario Manager Pivot Table option?...

I am using the following: =TEXT((J30/$B$31)/24, "h:mm") to convert hours and hundreths to hours and minutes. Excel is dropping the seconds and not rounding...

I need help with the check boxes on my excel spreadsheet at the top of the sheet I am able to check mark them as I reach the end of the sheet for some reason I...

hi- i have 3 columns (A, B, C) of data with 100 rows in each column. i want to combine my data from A,B, and C into column D. i can place this formula into...

Dear experts, I have a list of students with ten columns of data to the right and then an eleventh column containing textual comments. I want excel to...

Hi; I would like to multiply one cell (Hours worked) with another cell (hourly wage) and get the answer in the third cell (Wage earned). The other variable is...

Hi, I have a Word Document (Office 2003) with lots of names and addresses that I need in Excel so I can add them to another list to do a data import. The...

Hi all, I am trying to solve this problem for quite a long time, but no idea what's wrong. My problem si a typical one. I need to use COUNTIF function with...

How do I write the following condition in one cell (AA)? cell 'C' - year bought cell 'J' - bought commission cell 'Q' - year sold cell 'U' - sold...

In Col A, I have a list of 3 digit numbers eg: 110 111 112 113 115 116 120 Some numbers begin with 1, some with 2, 3 or 4.

Hi All, I apologize if this is not the right place, I believe this falls under teh category if worksheet functions; I have a SS I would like to reference a...

Is there a way to enter subset, union, element symbols in Excel, and if so, how?

I have a 2500+ line document with different years indicated in column D. How would I use the count (??) function to count the number of occurances for 1998,...

How can I change Euros to U.S. Dollars in Excel 2003? I found how to convert currencies but not Euros to Dollars just Dollars to Euros and other currencies.