Time Stamp Macro

Inserts the current time in the cell you are positioned on and formats the time to be displayed as HH:MM AM/PM (e.g. 12:45 PM). Once the time is inserted into the cell, it does not change.

The macro sets the column width to 9 so the time will fit in one column. The macro pauses to allow the user to change the column width if desired (use the arrow keys or enter a number). Finally press (ENTER) to accept the width.

1-2-3 Macro: '/RFDT2~@NOW{CALC}~/WCS9 ~/WCS

System Macro Version:

Comment: 123 Fixed Time

Contents: {MENU}rfdt2{ENTER}@now{F9} {ENTER}{MENU}wcs9{ENTER}{MENU}wcs