Variable Time Macro

This puts the function, @NOW, in the current cell and formats the range to HH:MM AM/PM. Whenever you call the worksheet up, the current time will appear in that cell, and change from day to day.

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~/WCS9~/WCS

System Macro Version:

Comment: 123 Variable Time

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