Excel Training, Excel VBA Training, Excel Software Design

Time Stamp for Microsoft Excel On-line Help


Time Stamp for Microsoft Excel On-line Help

EMAGENIT Excel Add-Ins Version 9.0

Time Stamp for Microsoft Excel Help Instructions.

Time Stamp Help Page Navigation

Time Stamp for Microsoft Excel Introduction

Load Time Stamp Manually into Microsoft Excel

Running Time Stamp in Microsoft Excel

Load Time Stamp Automatically Every Time Microsoft Excel Opens

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

How to Purchase Time Stamp

Time Stamp Layout and Control Overview

How to Turn Time Stamp Off/On

How Time Stamp Follows You and Behaves in Microsoft Excel

How Time Stamp Uses Excel's Cell Formats

How to Use Time Stamp's Different Modes

How to Manage Time Stamp's Settings

Where Can I Find the Latest Version Number of Time Stamp?

We will be updating Time Stamp periodically. To find your version number of Time Stamp, click the Product Info button on the main screen of Time Stamp. The latest version number of Time Stamp is listed at the top of this screen and on the Time Stamp home page (do not click yet, read the rest first). You can download a new version from that page. Before doing so, first read how to remove our add-ins from Windows before installing a new version.

Time Stamp for Microsoft Excel Introduction

Our Time Stamp for Microsoft Excel add-in allows you to automatically insert the date and time in different worksheet configurations without using formulas or pressing shortcut keys. Time Stamp's modes include placing the date and time in any worksheet cell by selecting it, placing the date and time in a cell in a designated worksheet column by selecting it, placing the date and time around an individual cell when it is typed in, placing the date and time in dual columns around two cells when they are typed in, placing the date and time in a specific worksheet column when typing between two columns in a row and placing the date and time in a selected cell by clicking an output button. Time Stamp uses our follow me and active sheet features that allows you to keep it open while you switch workbooks and interact with a worksheet. It even remembers up to 100 of its settings so you do not have to keep resetting it.

Load Time Stamp Manually into Microsoft Excel

After installing and activating the Time stamp add-in, proceed to your desktop and double click on the Time Stamp icon to load it manually. The icon will be black with a red border on the left-hand and bottom edge as presented in the first picture below. Excel will automatically open at this point. As the Time Stamp add-in loads into Excel, a security dialog screen will appear as seen in the second picture below. Click the Enable Macros button on the dialog box to finish loading Time Stamp.
Destop Icon
Excel Macro Enable Screen

Running Time Stamp in Microsoft Excel

Before your run Time Stamp, at least one workbook needs to be open or it will flag you. To open a workbook, select File/Open in the Ribbon or create a new workbook by pressing Ctrl+N. Next proceed to the EMAGENIT Tools tab in the Ribbon and click the Time Stamp button as presented in the picture below. Time Stamp will open. If you opened Time Stamp manually as discussed above, you will see both a Quit and Close button on the right-hand side. Clicking Quit will remove the program entirely from Excel. Clicking Close will just close the program but still keep it loaded in Excel. If you checked the “Automatically Open” checkbox on the bottom right of Time Stamp as discussed next, you will no longer see the Quit button on the Time Stamp screen.
Tab and Button

Load Time Stamp Automatically Every Time Microsoft Excel Opens

Time Stamp can be loaded manually by double clicking on its icon on the Windows desktop. It is also designed to be loaded automatically every time Excel opens. To load it automatically, first load Time Stamp by double clicking its icon on the Windows desktop as previously discussed. Next run Time Stamp by clicking its button on the EMAGENIT Tools tab as seen in the first picture below. When the Time Stamp main screen appears, check the Automatically Open check box located at the bottom right-hand corner as seen in the second picture below. Once checked, a message will prompt you that Time Stamp will now close and to reopen Time Stamp via its button in the Ribbon. Click OK on the message box to complete the process. Every time Excel starts up, it will load the add-in so its button will appear in the Ribbon. To stop Time stamp from loading every time Excel opens, simply run Time Stamp and uncheck the box.
Tab and Button
Tab and Button

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

If Time Stamp opens disabled and 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-load 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 Time Stamp

Time Stamp automatically prompts you to purchase it after using it for 10 days by displaying its Activation Software screen. You can purchase Time Stamp by clicking the following hyperlink: Purchase Time Stamp. EMAGENIT will send you an activation code via email within 3 hrs during our operating hrs Mon-Fri 8:00 AM - 5:00 PM PST. Note that during the trial period, you can also purchase Time Stamp by clicking on the Product Info button on the main screen, then clicking on the purchase button on the Product Info screen as seen in the picture below. To activate the software using the activation code, follow these instructions.
Purchase Time Stamp

Time Stamp Layout and Control Overview

The main screen layout of Time Stamp is as follows:
  1. Column / Cell Settings: This section will display graphical buttons to set the columns or cells for the different modes of Time Stamp and is pictured below. In the picture below, you would click on the Set Column graphical button to set the worksheet column that Time Stamp will use. The large graphic in this section will change displaying a picture of what mode you are in. While the main large graphic is never clicked in this section, the graphical buttons and radio buttons that appear to the right of it are. Different buttons will appear and disappear based on the mode you are in.
    Column/Cell Settings
  2. Output Options: This section will display the following output options that Time stamp will use when inserting a date/time into a worksheet cell. It is pictured below.
    • Formats: Select the date/time format you want Time Stamp to output its information as. If you select the Worksheet Default, then the output will be formatted as the default Excel time/date of the worksheet or use whatever format that has been set for the output cell.
    • Overwrite output cells: This option allows Time Stamp to overwrite the information that already exists in a cell.
    • Include name: This option allows Time Stamp to include the user name affiliated with your Windows login. Time Stamp will put the name in a different cell according to the Output Mode the user selects.
    • Include time: By default Time Stamp outputs a date to a cell. This option allows Time Stamp to also include the time in the same cell as the date. Available only in Auto date/time mode.
    • Output time only: This option tells Time Stamp to output the time only. Available only in Auto date/time mode.
    • Output in UTC: This option tells Time Stamp to override the Windows date/time and output the current UTC date/time in all six output modes. Available only in Auto date/time mode.
    • Auto date/time: This mode tells Time Stamp to use the Windows date/time.
    • Manual date/time: This mode tells Time Stamp to output the date/time listed in the date/time box directly below the option. When using this mode, Include time, Output time only and Output in UTC are not available. This mode can be used with all six output modes discussed below.
    • Date/time box: This box provides the capability in which to manually type a date, time or date/time combination. You may wish to do this if you are noting the date/time you are checking something then have to go back to your computer and fill it in. Dates are typed in a mm/dd/yyyy format, times are typed in a hh:mm:ss AM/PM format and combined date/times are typed in a mm/dd/yyyy hh:mm:ss AM/PM format.
    Output Options
  3. Output Modes: This section toggles the different modes that Time Stamp uses when outputting a date/time. These modes are from top to bottom placing the date and time in any worksheet cell by selecting it, placing the date and time in a cell in a designated worksheet column by selecting it, placing the date and time around an individual cell when it is typed in, placing the date and time in dual columns around two cells when they are typed in, placing the date and time in a specific worksheet column when typing between two columns in a row and placing the date and time in a selected cell by clicking an output button. This section is pictured below.
    Output Modes

How to Turn Time Stamp Off/On

Time Stamp needs to be turned on before it can output a date/time to a worksheet cell. To turn Time Stamp on, click the On/Off button at the top right of the Time Stamp screen after selecting an output mode. When Time Stamp is on, the button will remain pressed in, it is a toggle button, and will be orange/red in color and the word On will appear below it. To turn Time Stamp off, click the On/Off button again, it will depress, and the word Off will appear. To perform this toggle operation you can also press Alt+O. Time Stamp must be turned on for every mode except Manual. As you switch between modes, or toggle between workbooks, Time Stamp always returns to the Off position for safety. If you stay within the same workbook and switch between worksheets, Time Stamp will remain on. How the on and off modes look are presented in the pictures below.
On Mode
Off Mode

How Time Stamp Follows You and Behaves in Microsoft Excel

Time Stamp is designed to follow you from worksheet to worksheet and from workbook to workbook while it is open. When switching between workbooks, you will see it briefly disappear and then reappear, this is normal operation and occurs because the program was designed for the new separate workbook windows appearing in Excel 2013 and above. When switching between worksheets, Time Stamp will stay "On" if it is switched on. When switching between workbooks, Time Stamp will turn itself "Off" as a precaution. When you close Time Stamp, it will remember its last screen position when it is opened. Whenever a workbook is closed and Time Stamp is running, the program will shut itself down by design.

How Time Stamp Uses Excel's Cell Formats

Excel stores data two basic ways in a worksheet cell, as a number or as a piece of text. Numbers by default right justify in a cell by themselves using no alignment formatting while text left justifies in a cell. Dates fall into the number category as there are no actual dates in Excel. So when you type 1/1/2017 in a worksheet cell, you are really typing what is called a cell format. Excel really puts in the serial date number 42376 into the cell which is a number. Since you typed a format that Excel recognized, a date format, it auto selected that visual format style for the cell so you did not have to format it manually. The number that is really input represents the number of days from 1/1/1900 which would be 1. So if you typed in 12/31/1899, you are out of luck because Excel will not recognize it and will actually make it a piece of text, left justified. These concepts are presented in the picture below. If you look under the General category on the Format Cells dialog box, you can see the real value in the cell is 42736 even though 1/1/2017 is in the cell being displayed, that is its format. Switching the format of a cell back to General will flush any format back to a number if it can except True and False.
Date Format
When Time Stamp uses the Worksheet Default setting in its Formats box, it puts the date/time out to a cell and uses the format setting Excel already has for a cell. If a format was never set for the cell, then how the date/time is output determines the look of the date/time in the cell. This concept is presented in the picture below.
Time Stamp Output
Excel has one interesting feature, say you first output a date to a cell using Time Stamp, then you change your mind and output a date and time to the same cell. Excel tends to keep the original format it auto selected when you first put the date out. That means if you then output a date and time to the cell, only the date part will show up in the cell visual. The time is still there, just not being shown because of the default format that was first selected. By the way, the way time is really stored is a decimal value between 0 and .999... . 0 represents 12 midnight and 11:59:59 PM is 0.999988425925926. If the time appears with a date it would be 42736.999988425925926.  If you find yourself in situation just discussed, you can override the cell format by selecting a look for the date/time in the Formats box. This box has basically all the default date and time formats that Excel uses that are found on its Format Cells dialog box. When one is selected, it will override the way Excel defaults the date and time look in a cell. The second option is to format the worksheet cells you are outputting to before turning Time Stamp on. To do this just highlight the desired output cells, right-mouse click over the highlight and select Format Cells from the shortcut menu. On the dialog box, click the Number tab and select the Date or Time categories and then the format look. Again most of these are already in the Formats box. However if you wish to tinker, select a default from the Date or Time categories, then click the Custom category on the Number tab. You will see the real format script that gives cell information its look in the Type box. You can alter this script and create some interesting cell format looks that are not in the default formats for the Date and Time categories.

How to Use Time Stamp's Different Modes

Mode 1: Select cell, any cell: Choose this mode to insert the date/time in a cell on a worksheet when it is selected. A cell is selected on a worksheet when you click on it with the mouse, you press Enter and the selection feature of Excel advances to the next cell or you use the arrow keys to move the cell selection on the worksheet. To use this mode:

  1. Activate the worksheet in Excel you wish to use. This is done by clicking on a worksheet tab.
  2. Click the Cell click, any cell radio button on the main Time Stamp screen.
  3. Set your output options in the Output Options section. Note that after setting these options, be sure to select a cell on the worksheet that is not the first cell to insert the date/time in before turning on Time Stamp. If the first cell you wish to insert the date/time into is already selected, Time Stamp cannot insert the date/time into it because technically it was already selected when you turned on Time Stamp. This is an Excel feature and we have no control over it.
  4. After setting the output options, click the On/Off button at the top right of Time Stamp. Click the button once to turn “On” Time Stamp. Click the button again to turn it "Off".
  5. Next proceed to the worksheet and click a cell to insert the date/time in. The output options and formats you have selected will decide what is outputted to the cell and how it is formatted.
    • Note that if you have several date/times to enter and they are one right after the other on the worksheet, try clicking the first cell to enter the date/time in and then pressing the desired arrow key to rapidly enter the data/time in the worksheet without having to click the mouse.
    • Note that if the Include name check box is checked, the user name will be inserted in the cell to the right of the selected cell.
  6. What this mode looks like is pictured below. Note that the time is also being output.
    Mode 1

Mode 2: Select cell, specific column: Choose this mode to insert the date/time in a cell on a worksheet when a cell is selected in a specified column. A cell is selected when you click on it with the mouse, Enter is pressed and the selection feature of Excel advances to the next cell or you use the arrow keys to move the cell selection on the worksheet. To use this mode:

  1. Activate the worksheet in Excel you wish to use Time Stamp on.
  2. Click the Cell click, specific column radio button on the main Time Stamp screen.
  3. Set your output options in the Output Options section.
  4. Next, select a cell in the column you wish to restrict Time Stamp to operate within. It can be any cell in the desired column. In the Columns / Cell Settings section, click the Set Column graphical button to specify the column to output to. You will see the column letter load above the button. Note after setting the column, be sure to select a cell outside of the column before turning on Time Stamp. If the first cell you wish to insert the date/time into is already selected in the column, Time Stamp cannot insert the date into it because technically it was already selected when you turned on Time stamp. This is an Excel feature and we have no control over it.
  5. After setting the output column, click the On/Off button on the top right of Time Stamp. Click the button once to turn “On” Time Stamp. Click the button again to turn it "Off".
  6. Next proceed to the worksheet and click a cell in the designated column to insert the date/time. The output options and formats you have selected will decide what is outputted to the cell and how it is formatted.
    • Note that if you have several date/times to enter and they are one right after the other on the worksheet, try clicking on the first cell in the designated column to enter the date/time in and then pressing the down arrow key to rapidly enter the date/time in the worksheet without having to click the mouse.
    • Note that if the Include name check box is checked, the user name will be inserted in the cell to the right of the selected cell.
  7. What this mode looks like is pictured below. Note that the user name and time are being output.
    Mode 2

Mode 3: Cell type, single column, adjoining cell output: Choose this mode to insert the date/time to the right, left, top or bottom adjacent cell to the cell you are typing in on a worksheet. To use this mode:

  1. Activate the worksheet in Excel you wish to use Time Stamp on.
  2. Click the Cell type, single column, adjoining cell output radio button on the main Time Stamp screen.
  3. Set your output options in the Output Options section.
  4. Next proceed to the Column / Cell Settings section and select the desired adjacent cell in which to output the date/time. This is done using the T (Top), B (Bottom), L (Left), R (Right) radio buttons.
  5. After setting the adjacent output cell, click the On/Off button on the top right of Time Stamp. Click the button once to turn “On” Time Stamp. Click the button again to turn it "Off".
  6. Next proceed to the worksheet, select a cell, type in it and press Enter to insert the date/time to the specified adjacent cell. The output options and formats you have selected will decide what is outputted to the cell and how it is formatted.
    • Note that if the Include name check box is checked, the user name will be inserted in the adjacent cell to the left, right, top or bottom cell of the date/time output cell.
  7. What this mode looks like is pictured below. Note that the user name and time are being output.
    Mode 3

Mode 4: Cell type, double column, left right cell output: Choose this mode to insert the date/time to the right and left of two cells in the same row you are typing in. To use this mode:

  1. Activate the worksheet in Excel you wish to use Time Stamp on.
  2. Click the Cell type, double column, left right cell output radio button on the main Time Stamp screen.
  3. Set your output options in the Output Options section.
  4. Next select a cell in the column you wish to restrict Time Stamp to operate within. This will be the left-hand side column of the two column configuration. It can be any cell in the desired column. In the Columns / Cell Settings section, click the Set Column graphical button to store it. You will see the column letter load above the button. Any time you type in that column, the date time will be inserted in the adjacent cell to the left of it. If you type in the adjacent column to the right of that column, Time Stamp will insert a date/time to the adjacent cell on the right of the cell you are typing in.
  5. After setting the column, click the On/Off button on the top right of Time Stamp. Click the button once to turn “On” Time Stamp. Click the button again to turn it "Off".
  6. Next proceed to the worksheet, select a cell in either the designated column or the column next to it on the right, type in it and press Enter to insert the date/time. The output options and formats you have selected will decide what is outputted to the cell and how it is formatted.
    • Note that if the Include name check box is checked, the user name will be inserted in the adjacent cell to the left or right of the date/time output cell.
  7. What this mode looks like is pictured below. Note that the user name and time are being output. Column K is the specified left-hand column and column L is its adjoining column to the right to type in.
    Mode 4

Mode 5: Cell type, designated range, output in column: Choose this mode to insert the date/time in a specified column to the right of an area between two columns on a worksheet that you are typing in. To use this mode:

  1. Activate the worksheet in Excel you wish to use Time Stamp on.
  2. Click the Cell type, designated range, output in column radio button on the main Time Stamp screen.
  3. Set your output options in the Output Options section.
  4. Next select a cell in the column that begins the typing area. This will be the left-hand side column of the typing boundary. It can be any cell in the column. In the Columns / Cell Settings section, click the Set Beg Column graphical button to store it. You will see the column letter load above the button. Next select a cell in the column that ends the typing area. This will be the right-hand side column of the typing boundary. It can be any cell in the column. In the Columns / Cell Settings section, click the Set End Column graphical button to store it. You will see the column letter load above the button. Last select a cell in the column that will be used to output the date/time to. It can be any cell in the column. In the Columns / Cell Settings section, click the Set Out Column graphical button to store it. You will see the column letter load above the button. Any time you type between the two columns including the beg/end columns, the date time will be inserted in a cell in the out column in the row you are typing in.
  5. After setting the column, click the On/Off button on the top right of Time Stamp. Click the button once to turn “On” Time Stamp. Click the button again to turn it "Off".
  6. Next proceed to the worksheet, select a cell in the designated area, type in it and press Enter to insert the date/time. The output options and formats you have selected will decide what is outputted to the cell and how it is formatted.
    • Note that if the Include name check box is checked, the user name will be inserted in the adjacent column to the right of the date/time output column.
  7. What this mode looks like is pictured below. Note that the user name is being output, the time is being output and the cell overwrite feature has been activated. Column A designates the beginning of the typing range and column C specifies the end. The D column is the output column in this example but it does not have to be directly next to the range.
    Mode 5

Mode 6: Manual time output: Choose this mode to insert the date/time in a selected cell by clicking a button. To use this mode:

  1. Activate the worksheet in Excel you wish to use Time Stamp on.
  2. Click the Manual time output radio button on the main Time Stamp screen.
  3. Set your output options in the Output Options section.
  4. Click the On/Off button on the top right of Time Stamp. Click the button once to turn “On” Time Stamp. Click the button again to turn it "Off".
  5. Next proceed to the worksheet, select a cell and press the Insert Date/Time button. The output options and formats you have selected will decide what is outputted to the cell and how it is formatted.
    • Note that if the Include name check box is checked, the user name will be inserted in the adjacent cell to the right of the selected cell.
  6. What this mode looks like is pictured below. Note that the time is included in the output.
    Mode 6

How to Manage Time Stamp's Settings

Save Time Stamp's Settings

Time Stamp's settings can be stored as a named configuration for rapid access. Up to 100 configurations can be stored. To store Time Stamp's settings:
  1. First adjust the settings for Time Stamp then click the Store Settings button on the Time Stamp main screen as pictured below.
    Store Button
  2. On the Time Stamp Configurations screen that appears, click the Save button as pictured below.
    Configuration Screen
  3. On the Configuration Name screen that appears, type the configuration name and click the OK button as pictured below.
    Type Configuration Name
  4. The configuration name will now appear in the Store Configurations box. Note that the name will appear in lower case.
    Configuration Name Stored

Load a Time Stamp Configuration

Time Stamp's stored settings (configurations) can be loaded instantly configuring Time Stamp. To load a configuration:
  1. Click the Store Settings button on the Time Stamp main screen as pictured below.
    Store Button
  2. On the Time Stamp Configurations screen that appears, select a configuration name in the Stored Configurations box and click the Load button as pictured below. Click the Yes button on the confirmation screen that follows.
    Load Configuration

Delete a Time Stamp Configuration

Time Stamp's stored settings (configurations) can be deleted. To delete a configuration:
  1. Click the Store Settings button on the Time Stamp main screen as pictured below.
    Store Button
  2. On the Time Stamp Configurations screen that appears, select a configuration name in the Stored Configurations box and click the Delete button as pictured below. Click the Yes button on the confirmation screen that follows.
    Delete Configuration


Site Map

Copyright © 2002-2017

EMAGENIT All Rights Reserved