I wish to set up a time sheet to record the number of hours worked in a day. How do I get excel to add time. ie Hours worked 8:30 - 13:00, 14:00 - 17:30 = 8...

Here's a question for an assignment for my computer info systems class. I have a table posted below in cells A4:E13 Credit National National...

I have a sheet that is used to post daily mileage and expenses for an employee. He works for a property management company, so he's traveling during the day...

Hi! I am trying to calculate the interest owned by a client. I need to do this using dates as the terms of sales a 1.5% after 30 days. My spreadsheet is...

Hi guys I have a spreadsheet that has a number of data. Beneath the data I have a 10 averaging functions that average data on different columns. The data...

I have a list of data in which I would like to fill in the gaps. Is this possiable? I have age in years in A2 to A100 then data in colums in 5 year gaps (eg...

I have 25000 cells with map coordinates in it in the following format: N34* 51.87' I need the data in the following format: N55 13.26 So basically I need...

I got help from some one last night and they gave me this code Private Sub ListBox1_Click() Dim rng as Range If listbox1.ListIndex -1 then set rng =...

I have excel 97, can i define row height & column width in mm ?

I am trying to create an Excel document where the top row only (approx. 30 columns) has the text displayed in the vertical. The remainder of the document will...

How to change a calendar in excel from Mon-Sun to Sun-Sat?

I need to create a stock control spreadsheet for my new job, Before I spend a lot of time making mistakes / changes, Does anyone have an example of one they...

I deviced a workbook that consists of 8 worksheets. The worksheets contain cells with formulas that are locked and hidden. They only show values. I did not...

I have been able to create a drop down list, but cant work out how to create a vlookup to auto fill in the price associated with an item. CELL A1 - DROP DOWN...

I have an Excel file with over 20 different worksheets that link to each other, and most of their cells are formated. When I was formating one of...

Hi, what I was hoping to do is if the marcros are disable when the file is opened all the worksheets are hidden except one with a message saying to enable...

Hi, I've pulled my hair out trying to nest functions and try various different ways to do this but here's the problem. I have two worksheets. The first...

We invoice customers in weekly batches (Table A). Recurring invoices are due to be raised at various intervals eg: monthly, 28 days, 18 days etc (Table B)....

A classical formula might be =HLOOKUP(a1,a100:z100,1,FALSE). But I want to display the result if the lookup value = a1 or a2 or a3 or...a10 ie: anything in the...

I have a drop down list in Excel & would like to add more names...how do I do this?