Time Stamp

Running Time Stamp for the First Time

To run Time Stamp, proceed to the EMAGENIT toolbar and click the Time Stamp button. In Excel 2007, proceed to the Add-Ins tab and click Time Stamp. The program will prompt you with two screens, follow the instructions. On the second screen which is the Information screen, leave the product ID box blank to run the program in demo mode. The Time Stamp will allow you to insert a time/date 20 times before prompting for a product ID which can be purchased from EMAGENIT.

Time Stamp Introduction

Our Microsoft Excel Add-In Time Stamp allows you to quickly insert the date and time in a worksheet cell without using time formulas or date formulas. It also allows you to place the time and date on a Microsoft Excel worksheet in a designated column, around an individual cell, in dual columns around two cells, typing in a row or by clicking an output button. Time stamp is used widely by the oil and gas industry for recording time and date when taking instrument readings or in business on log sheets.

How to Open and Launch Time Stamp in Microsoft Excel

To open Time Stamp in Microsoft Excel, go to the Windows start button and click it, select the EMAGENIT grouping under programs, click on the Time Stamp icon and it will open in Microsoft Excel. If prompted, click the Enable Macros button to enable the program. Once open in Excel, proceed to the EMAGENIT toolbar in Excel 2003 and below and click the Time Stamp button. In Excel 2007, proceed to the Add-Ins tab and click the Time Stamp button.

How to Enable Macros in Microsoft Excel (Time Stamp Not Running)

If Time Stamp will not run in Microsoft Excel and prompts you as such, your macros have been disabled. To enable macros, proceed to Microsoft Excel Help and type in Enable Macros and follow the instructions about enabling macros. Note that you will have to shut down Excel and re-launch Time Stamp in most instances after adjusting these settings. Note that Time Stamp cannot override Microsoft Macro security so there is no way for our program to control this feature and enable it for you. If it could be done, we would have done it for you.

How to Purchase and Activate Time Stamp

Time Stamp automatically prompts you to purchase it after "inserting 20 time/dates" by redisplaying its setup Information screen. You can purchase the software by clicking the purchase button on the screen then clicking the purchase button on the website page that is displayed. EMAGENIT will send you the product-ID within 2 hrs during our operating hrs Mon-Fri 8:00 AM-4:00 PM PST. You can also purchase it by clicking on the Purchase button to the left. To key in the product-ID, just launch Time Stamp and type the ID in the Information screen in the Product-ID box at the bottom.

How to Use Time Stamp

Setup and Use Time Stamp

1. Click on the Time Stamp button on the EMAGENIT toolbar.

2. To turn Time Stamp on, click the On/Off button button at the top of the Time Stamp screen to On. To turn off Time Stamp, click the On/Off button to Off. You can also press Alt+O. Time Stamp must be turned on in every mode except Manual. As you switch between modes Time Stamp returns to the off position.

3. To put a time/date into any cell you click on, you select the Cell click, any cell mode. You can also press Alt+A. After selecting the mode, just turn on Time Stamp and click on a cell. Note that Time Stamp does not distinguish between worksheets.

4. To put a time/date in a particular worksheet column only, you select the Cell click, specific column mode. You can also press Alt+S. To use this mode you must first designate a column that the time/date is placed in. To accomplish this, click in a cell in the column that you want the time/date to appear in then click the Set Column button. Next turn on Time Stamp and whenever you click in that column the Time/Date will appear. Note that Time Stamp does not distinguish between worksheets, only the column.

5. To type in a cell, then have the time/date appear in an adjacent cell around it, you select the Cell type, single cell, adjoining cell output mode. You can also press Alt+J. Next select where you want the time/date to appear around the cell by clicking the Left, Right, Top or Bottom option button. Next turn on Time Stamp, click where you want type and when Enter is pressed the time/date will appear around the cell. The position can be changed on the fly without turning off Time Stamp. Note that Time Stamp does not distinguish between worksheets.

6. If you want to type in two adjacent worksheet columns and have the time/date appear to the left of the first column and to the right of the second, select the Cell type, double column, left right cell output mode. You can also press Alt+D.  Next click on a cell in the left column you will be typing in and click the Set Column button to lock it in. Next turn on Time Stamp and whenever you type in the designated column a time/date will appear to the left of it. If you type in the adjacent column to the right of it, a time date will appear to the right. Note that Time Stamp does not distinguish between worksheets, only the columns.

7. If you want to type in a row on a worksheet and have the time/date appear in a certain column, select the Cell type, designated range, output in column mode. You can also press Alt+G. Next select the boundary columns you will be typing in or between in the row by clicking on a cell in the beginning column and selecting Set Beg Column, next clicking on a cell in the ending column and selecting Set End Column and then clicking in the output column for the time/date and selecting Set Out Column. Next turn on Time Stamp and whenever you type in or between those to columns in a row, the time/date will appear in the output column.

8. To manually output the time/date select the Manual time output mode. You can also press Alt+M. Next select a cell and every time you click the Insert Time button the time/date will appear in the cell.

Overwriting

Time Stamp does not overwrite existing cell values/formulas as a safety precaution. To override this feature, check the Overwrite check box. Note that the Cell type, designated range, output in column mode always overwrites the output column cell.

Including the User Name

Time Stamp can include the user name by checking Include user name. The user name will appear next to the time stamp depending upon the mode selected.

How to Format a Cell's Date and Time

Excel 2003 and Below

1. Select the desired cell range. Click on the column header (i.e. A, B, c…etc) to select the entire column.

2. Proceed to the Worksheet menu bar and select Format/Cells.

3. On the Format Cells dialog box, select the Numbers tab then the desired cell date and time display option.

Excel 2007 and Above

1. Select the desired cell range. Click on the column header (i.e. A, B, c…etc) to select the entire column.

2. Right mouse click over the selection and select Format/Cells.

3. On the Format Cells dialog box, select the Numbers tab then the desired cell date and time display option.

Time Stamp closes when Microsoft Excel closes and does not reopen with it. This is by design. To close Time Stamp so it is no longer present in Excel without closing Excel, just check the Quit check box at the bottom of its screen then click the Close button. This will remove Time Stamp from Excel.