I would like to add hours in a worksheet to come up with a total number of hours. However, when I add something like this: 5:00 5:00 5:00 5:00 5:30 .. . ....

I have a xsl file with two sheets One is named data and other is named info lets say. On the data sheet lets say there is cell a1:z50000 I need to pull every...

I have a quote form in Excel. Right now, if I have a zero in the Qty column it shows the zero, the Sku# in the next column, description in next, and so...

The cell fill color is black and the font is white, if the date show is long before it expires I want it to remain white, at 90-days before the date shown,...

Hi Can anyone advise if there is an easier and less complicated way to achieve the following...

Hi: I need to know exactly what xlnm is, because it's messing me up. I have two excel files, one used as a database and the other as a reader, {Showing the...

I have lots of entries that have the form "+6+2", "+4+3", "+5+1". Is there any way to extract the second half, so the "+2", "+3", "+1" - part ? (Not all of...

Goal: By entering a beginning date and an ending date on Sheet2, I hope to populate Sheet2 with data from Sheet1 within the selected date range below row...

I am looking for a formula that calculates : - the average of the last x entries in a row - that are NOT formulas, and that are greater than 0 - and - where...

Hi Any help? I want to count cells that contain numbers with criteria, I used these functions, but it returns false, the range can contain data or are blank, I...

Hi - I have the following array of data, where the top row is the year worked and the following rows are number of hours worked by employees in that year. ...

Hi, I'm having trouble with an Excel financial function mainly because I don't really understand the financial jargon that is being used to explain it. I want...

Hi Any help? I want to count cells that contain numbers with criteria, I used these functions, but it returns false, the range can contain data or are blank, I...

i have to create a worksheet that requires the use of imaginary numbers calculating inductive reactance and capacitive reactance

Hi I'm trying to place a data filter at the top of a column that can sort the data within that column. The filter works but it doesn't cover the whole column...

GOD OF GIFTS Free Animations + Wallpapers + Adsens Tips + Hand Reflexogy + Games + Audio + Videos + Nature Health Tips And Beautiful...

Hi, I have a spreadsheet that is populated with data obtained from several other spreadsheets and an .html document also. Is there a fairly simple and...

I have several workbooks with different types of statistical data. I want to combine all the workbooks to a single workbook. Is it possible?

If I have three columns of data representing three different raters, how do I conduct an "inter-rater" reliability?

I have a sheet that I have created a button on that when its pressed opens outlook up, would like as part of the macro that it places the employee's email...