Hi, i have the times in 12:00 PM in cel A1 and 9:30 AM in B1 and i just want to calculate the difference between B1-A1 which is -2.30 hrs, but in excel it is...

Please post response as email is bogus to prevent spam. I have posted this query to the misc board also. I just need some direction. I am using Excel 2003. I...

I have information in column A of a task sheet. The information goes from row 1 thru 35. Column B is where I place a "x" to say the task need to be completed....

Hi, Somehow my Pivot table do not sums up by rows. Boxes are checked for both columns and rows for Grand total under options, Tools and Filter. Dinesh

Does Excel have a function that will allow me to count only the data range for a specific title when there is more than one data range in the same column? I am...

I have a spread sheet that I'm running macro's in, and it keeps coming up with the error message "excel.exe has generated errors and will be shut down...

Anyone know of a function that calculates the bond premium amortization using the constant yield method? An example of a bond premium that would need...

I need to create a spreadsheet for Aged receivables. I need to know how to set up a formula to calculate if invoice is 0-30 days old, 31-60 days old, 61-90...

I've never seen this error before, and unfortunately, my Google searches keep bogging me down with the simple "Automatic/Manual" solution... I have Workbook...

I WANT TO PUT MORE THAN SEVEN LEVELS OF FUNCTIONS WITH A FUNCTION. FOR EXAMPLE...

Hi there, I've got a list of products for my company but it is listed in product group, the products for that group coming underneath.. like...

I need an example on writing an IFERROR in Excel 2007. =IFERROR......I have to do this for work and can't find anything on it.

I have a workbook and I would like to do the following: sheet 1 named “End Bal� has 8 columns. In 2 of the columns; cells B5:B22 and H5:H21 contain one...

I have a drop down box on a spreadsheet in a workbook with several spreadsheets. For some reason the contents of the drop down box is beeing bled through to...

Hi! I have a worksheet containing many formulas. This worksheet is locked without any password. Is there a way to see if somebody unlocked the worksheet to...

I received a shared worksheet where certain features were unavailable (inserting being one of those). After saving and closing that spreadsheet and opening...

Can somebody tell me how to look up a list of items in a column from an array and then return the information in a cell that is in a column which is the same...

EVery time I open EXcel for a new worksheet, the columns are shown as numbers, the same as the rows. How do I change it so that they are letters? Makes it much...

I'm using the VLOOKUP function to return data from a named range which contains several data points (across the row) for several "sites" which are numbered...

I need to determine the maximum number of consecutive negative numbers in a column. The column contains formulas that evaluate to a positive number, a...