| Thread | Last Post | Replies |
|
| 7 day workweek timesheet - excluding lunch | 08 Sep 2006 23:26 GMT | 3 |
I thought I alreayd posted this but don't see it anywhere, so forgive me if this is duplicated somewhere. I am looking for a formula to calculate total hours worked, to exclude lunch, based on the assumption of a 30 min lunch if working 6 hours or more
|
| Tax Status | 08 Sep 2006 23:00 GMT | 2 |
I am trying to set up an employee on the work sheet. I do not know what to type under the Tax Status column. Please help
|
| Forumla Error | 08 Sep 2006 22:51 GMT | 5 |
Can't seem to get this code to work correctly... =VLOOKUP(Weekly Data'! COUNTIF(M2:M256,"W*") Any help would be appreciated. Rob
|
| to get the same answer from a normal calculator | 08 Sep 2006 22:22 GMT | 1 |
I am sales executive for a bank in UAE.My product is Personal Loan. I am normally using the Ms Excel worksheet to calculate the monthly installment for my clients. Sometimes,i have to use my calculator to get the installment.
|
| formula won't calculate unless I click cell | 08 Sep 2006 21:50 GMT | 2 |
I am using a countif function in MS Excel. It is counting the instances that a particular date/ time occurs in a list. The function references the criteria in an adjacent cell as follows In cell A2:
|
| Problems with find/replace function | 08 Sep 2006 21:42 GMT | 1 |
I have 25 lines of information that have the word "steel" in the formula. When I do a find "steel" and replace with "steel div" it only replaces the first 15 lines. The remaining lines I get an error message that says "That name is not valid".
|
| Looking up the most recent date | 08 Sep 2006 20:46 GMT | 3 |
I have a Database in which I keep track of all the toner for my company. I list each box as it arrives with a number, and record it (1,2,3...345,346, etc.). When it arrives, I record the date in one column, when I install it in a machine, I record that date in the next column, ...
|
| How do I change the appearance of a hyperlink? | 08 Sep 2006 20:44 GMT | 1 |
I am trying to change the appearance of a hyperlink into a button or a graphic. How do I do this? (I have the hyperlink in my spreadsheet, but I can't get it to insert into a button) What should I do?
|
| printing worksheet in newspaper columns | 08 Sep 2006 20:39 GMT | 1 |
I have a long list (3 columns wide) and I would like to print in a column set-up (similar to word). Does anyone know how to do this or if it can be done?
|
| Linking Jpeg Images to excel. | 08 Sep 2006 20:33 GMT | 1 |
Odd question, but I have a file with about 160 images and would like to link them to an excel file under category tabs example; People, Nature, Technology etc. There are 21 main files and within them about 2 - 4 sub files each.
|
| How do I create "push buttons" in Excel? | 08 Sep 2006 20:32 GMT | 2 |
I am trying to create push buttons in Excel. (Hyperlinks, maybe?) It is a button that can be pushed to direct the user to a different worksheet in the same file.
|
| dannycol | 08 Sep 2006 20:29 GMT | 5 |
I would like a macro which will format a selected range of cells to have capital letters.. any help would be appreciated
|
| to get the same answer from a normal calculator | 08 Sep 2006 20:23 GMT | 1 |
I am sales executive for a bank in UAE.My product is Personal Loan. I am normally using the Ms Excel worksheet to calculate the monthly installment for my clients. Sometimes,i have to use my calculator to get the installment.
|
| I recorded a macro, how can i share it with others? | 08 Sep 2006 20:09 GMT | 1 |
Can I email a recored macro?
|
| What is Wrong with this function?????????? | 08 Sep 2006 19:47 GMT | 2 |
=IF(AND(Z17>0,Z17<=12),Z17+12,Z17,IF(AA17<=7,".00",IF(AA17<=22,0.25,IF(AA17<=37,0.5,IF(AA17<=52,0.75,IF(AA17<60,".00")))))) For the Love I cannot find the problem. Excel says there are too many arguments for the function. Someone please please please Help.
|