| Thread | Last Post | Replies |
|
| Adding TIME | 14 Apr 2004 04:41 GMT | 1 |
I am tracking a 5 day sporting event that has stages and legs within the stage. I am estimating the time it will take to complete a leg,a stage and a cumulative time. I input the leg time, have
|
| Toolbars missing | 14 Apr 2004 04:12 GMT | 4 |
My toolbars in Excel 2000 ( Office 2000) have disappeared. ALSO menu items:Edit, Insert, Format, & Data are greyed out and cannot be accessed. Tried repairing through add/remove programs - no different.
|
| golf league spread sheet | 14 Apr 2004 04:08 GMT | 3 |
I am trying to set up a spread sheet for my golf league. Here's an example: Member ___ Today's Score __ Net __ Current Handicap John Smith _____75 ________ 70___________5
|
| AM - PM | 14 Apr 2004 04:04 GMT | 4 |
I am using excel and am tring to find out me sleeping habites. Is there a "fx" in Excel that will tell the diff. between 11:50 PM to 7:00 AM in numbers. If not how can i do this?
|
| Newbie Help! | 14 Apr 2004 02:33 GMT | 1 |
Im am fairly new to MS excel. Ill try and describe my problem as best can. One of the lab technitions at work has an external 'grip tester' tha sends road readings into an excel file on the fly.
|
| Decision table help | 14 Apr 2004 00:25 GMT | 4 |
Hello, I am making a decision table and I could use some help with formulas to make the data entry easier. Any help or links would be appreciated. I have experimented with the offset function unsuccessfully. 1) In cells B1, C1, D1, etc. I have choices A, B, C, etc.
|
| macro problem | 13 Apr 2004 23:28 GMT | 1 |
i have a worksheet that shows worktimes for employees, the cells ar grey, when you enter the employees time or "shift" and press a butto that executes my macro, it changes the colour of the "shift" to whit to show the time scale that the employee is working. the macro run
|
| Linking Worksheets | 13 Apr 2004 23:17 GMT | 13 |
I have a workbook with 10 worksheets. I would like to link on worksheet to a Word document so that when I update this particula worksheet the document updates as well. I tried to do Insert Object but it only allows me to select a file. I
|
| Comparing 2 Lists | 13 Apr 2004 23:06 GMT | 2 |
I have two lists, one is shorter than the other. I need to make a third list that contains only items that are in both lists. Let's say that column A is my short list (about 2,000 entries), column B is my long list (about 20,000 entries), and I'm going to make column C a list ...
|
| UDF showing full Path of Worksheet or Worksheet Name? | 13 Apr 2004 22:45 GMT | 2 |
How can I modify Wallenbachs UDF to show the "Worksheet Name" of the referenced worksheet and or the fullpath? Function SHEETOFFSETNAME(offset, Ref) ' Returns cell contents at Ref, in sheet offset
|
| need help with timer button | 13 Apr 2004 22:44 GMT | 1 |
In the attached excel file, I am wondering is anyone able to put a time on it for me. When the Hint button is pressed a text GUI appears. I wa wondering does anyone know how to just have this GUI appear for 3 seconds. all help and comments appreciated
|
| Find/Replace on Range? | 13 Apr 2004 22:30 GMT | 1 |
When I highlight a column or some cells I can not restrict a FINE and REPLACE to those highlighted cells. Can this be done so that it doesn't search the whole sheet? Using Excel 2003.
|
| Add pattern using macro | 13 Apr 2004 22:16 GMT | 3 |
I was just wondering, is it possible to record a macro that can add pattern to a cell? Everytime i need to add a pattern to a cell, i have to go throug Format|Cells|Patterns and then choose 'Thin Diagonal Stripe'.
|
| negative time values? | 13 Apr 2004 22:16 GMT | 8 |
F103=SUM(F94)-(F102) could someone tell me how to format this cell to get the correct answer, current format is [h].mm;#;[Red]-[h].mm; and its giving me a value of 1 and it should be -18:22
|
| time calculation | 13 Apr 2004 21:10 GMT | 4 |
I need to do a check on the time.. if it is after midnight but before 5am then I need to minus 1 day off of the date. How could I do this?
|