| Thread | Last Post | Replies |
|
| Time Format | 14 May 2008 16:46 GMT | 1 |
I'm having a problem adding together journey times. I have a start time (say 8:34:00) and an end time (say 10:23:00) and from this I calculate a journey time (1:49:00). I then add this journey time (using the sum function) across a number of different journeys giving me a
|
| Tab to specific cells | 14 May 2008 16:45 GMT | 3 |
I am using excel 2002 and my boss 2003. I want to tab to specific cells in my work sheet. Can anyone help me get started?
|
| How to open 2 excel workbooks | 14 May 2008 16:37 GMT | 3 |
I am trying to transfer a sheet from one workbook to another. When I open the 2 one (workbook) disappears, is there a way to keep both open? thanks
|
| Moving average trend line | 14 May 2008 15:37 GMT | 1 |
When graphing, does a moving average trend line give equal weight to all data within the trend period (30 days in my case) or does the more recent data have greater weight (significance)? If the latter, do you know the weighting function?
|
| Text join formulas working but act as straight text when modified | 14 May 2008 14:27 GMT | 3 |
I have a spreadsheet in which I am using left and right functions to populate a new column. This seems to work if I key the whole thing in at once. When I try to modify the formula, it stops working and displays as straight text. Format of all cells is general. The formula in ...
|
| limit text length in a text box in excel 2003 | 14 May 2008 14:14 GMT | 1 |
I'm trying to limit the text length in a text box but i can't find the option to do so please help
|
| Removing filtered Blanks Cells | 14 May 2008 14:12 GMT | 5 |
How can i remove filtered blanks cells Thanks Hardeep kanwar
|
| pivot table macro | 14 May 2008 13:06 GMT | 2 |
I want to create a pivot table using the pivot table wizzard from a worksheet into a worksheet with the name table by running a macro. when I record the macro I create the pivot table using the wizzard and it works fine but when I try to run the macro again it errors "unable to ...
|
| I want to see empty cells instead of 0.0 in number formatting | 14 May 2008 12:20 GMT | 4 |
I have column A, B, and C. Same formula is pasted all the way down the columns. C is a math formula, like =A*B/10. C is formatted a number with precision of 1 decimal place. All works fine. But often A and B are blank and then column C stupidly reports "0.0" even ...
|
| matching words | 14 May 2008 12:14 GMT | 1 |
i have data in column A of words i want to know if it is already with column B, the problem is column A does not have the exact word and i used Vlookup and it shows #NA value on column C. help please.........
|
| Excel 2007 - Nothing shows up in the cell while I'm typing! | 14 May 2008 11:51 GMT | 4 |
I'm running into an issue with a range of cells in a spreadsheet where nothing shows up in the cell as I type. I can see the cursor moving to the right to show that I'm typing something, but the value that I'm typing doesn't actually appear in the cell until I hit <Enter>.
|
| Convert time number 9:30 to a whole number 9.5 | 14 May 2008 09:25 GMT | 3 |
Is there a way to convert a time number: 9:30 (9 hrs 30 minutes) to a whole (w/fraction, or one decimal to the left)? 9.5 Thanks You! Wayne
|
| formula to turn hh:mm cell into x.y hours | 14 May 2008 08:43 GMT | 5 |
I need to track billing for a client, with 1/10th hour precision, and where partial groups of 6 minutes round up to the next 1/10th hour (example: 8 minutes = 0.2 hours). I have a start time, and an end time. Then I subtract one from the other and get hh:mm, such as 1:08 ...
|
| Re-arranging table using pivot-table? | 14 May 2008 05:02 GMT | 2 |
I have a worksheet with data organized somewhat like this: New York New York New York Albany Florida Miami
|
| SBERET.MSI file missing - Excel/Office XP | 14 May 2008 03:52 GMT | 4 |
All of my XP Office apps have been running fine since they were installed years ago, until today. Suddenly and inexplicably...as of today when I try to open Excel or any of my many Excel documents, Windows Installer initiates and starts searching for set up files and then prompts ...
|