You are here:
I can answer any question relating to MS Excel formulas, or to programming with vba (Visual Basic for Applications) in the Excel environment
As a consultant, I've designed Excel tools since the 90s, working for the Federal Reserve Bank, AT&T, and (currently) Gap Inc.
| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| Althea | 11/02/09 | 10 | 10 | 10 | 10 | Stuart...you are the BEST!!! Thanks so ..... |
| Cassandra | 11/02/09 | 10 | 10 | 10 | 10 | WOW. I never expected such a quick ..... |
| Althea | 10/30/09 | 10 | 10 | 10 | 10 | GREAT TURN AROUND TIME IN ANSWERING MY ..... |
| rugian | 10/26/09 | 10 | 10 | 10 | 10 | |
| Ellerd | 10/20/09 | 10 | 10 | 10 | 10 | Stuart Resnick, your first feedback was correct ..... |
There's no simple way to do this, as the Excel INDIRECT function doesn't work for closed workbooks. There are add-ins that you can download which, when added to your Excel application, will include a new
Start with new worksheet. View the Control Toolbox toolbar, and use it to place a checkbox on the sheet. Right-click on the checkbox, and set the LinkedCell Property to =A1. Exit design mode, and close
Since you now say your Time On and Time Off may be on different days, it's MUCH clearer to include the date in these entries. So for instance, in cell A2 enter: 11/2/09 5:00 am and in B2 enter
New sheet, select cols A:D, Format, Cells, Number, Category: Time, Type: 1:30 PM, OK. In A1:A3, enter: 8:00 AM 9:30 AM 10:00 AM In B1:B3, enter: 6:00 PM 7:00 PM 8:00 PM Range A1:B3 now
Since you don't specify, I'll assume Excel 2003. Select cols A:B and Format, Cells, Number, Category: Custom, Type: hhmm, OK. In cell A1 enter 06:19 and it will appear as 0619. Similarly, enter
Answers by Expert:

©2009 About.com, a part of The New York Times Company. All rights reserved.