Functions

help creating a time function
Hello, I am trying to create a time function that will look at a typical day and add the hours. Then show how many hours after 8 is overtime. I have the first part created, but how can I write a formula that will look at say 12:45 hours and tell me 4:45 of it is overtime? Please help!! Thanks!!! ... 5 Feb 2010 05:03

Is there a function in excel where you can the beginning of the mo
I am trying to look for a function that would will display the first of the month if the cell I am referencing is a date in that month. For instance: I have a date that says 12/16/09 I want the function/formula to return 12/1/09. Is this possible? I cant seem to find it anywhere. ... 21 Jan 2010 14:38

join imported Excel 2007 files
I have two Excel 2007 files that I need to join to form one spreedsheet of data. I have the unique identifier column in both files. There will be some records (rows) that are in one file but not in the other that need to be kept as well. How can I pull all of this data together using the unique identifier column... 21 Jan 2010 20:20

Lookup data in the list
Hi All, I have a list as shown bellow, I want to pick up the date correcponding to the value on cell A1 and the value in B2 or B3. So it is some thing like this =Vlookup(a2,a:b[b2+1] or[b+2] {this is just a vierd example} ColumnA ColumnB ID Name 1 12082A IN-tuition 2 Ms. Gayle 3 Gayle Theresa 4 Sofi... 21 Jan 2010 19:13

Relative Reference in Conditional Formattin
I can't get relative references working in a conditional formatting formula in Excel 2003. Can someone help me with this? I'm sure it must be something simpe I'm missing. Here's what I want to do: - Apply a conditional format to a large area of a spreadsheet to show when the cell in the column to the left of ... 21 Jan 2010 11:12

Multilayered Spreadsheet Function
Is there a way to take a Main spreadsheet that has the sales data and take that data and allocate it to individual regional sales sheets as the data is being entered? For instance, there are 25 Regions nationally and each phone call is logged onto the main sheet. Each of the 25 Regions need to know the data o... 20 Jan 2010 21:57

Excel - Ignoring the contents of cells when there are letters in the cell
Use the SUM function. =SUM(A1:A3) Instead of doing this: =A1+A2+A3 The SUM function will ignore any cells that contain text. -- Biff Microsoft Excel MVP <James McErlain> wrote in message news:20101201413james(a)kingdom.ie... When using MS Works I can enter letters and numbers in a cell and the ... 20 Jan 2010 15:12

90 day Running total
I have a workbook set-up that contains two worksheets. One work sheet has the current date and totals for individual inventory. The second worksheet has the individual months with that months inventory. How do I set a formula in the first sheet that will calculate the running total for the last 90 days and aut... 20 Jan 2010 12:56

Change listbox text size in Excel 2007
Using data validation list box function to display a named range, How can the text size be increased when displayed in the list box, How can the number of records displayed be increased from the default ... 20 Jan 2010 10:39

Formula To Bring The Best Name
I have a worksheet that has 9 suppliers names in (C4:L4), there costs for a item in (C19:L19) I want to bring the cheapest suppliers name into cell M4. Need Help! ... 20 Jan 2010 00:46