Time Input EXCEL 2003

[adulted]

Time Input

In cell F1 I have the following formula =TEXT(HOUR(NOW()),"00")&":"&TEXT(MINUTE(NOW()),"00")&":"&TEXT(SECOND(NOW()),"00") Which displays the current time. Formatted as General.

I would like to enter a number in cell E18, and have D18 Display the time from F1, which auto updates after a number is placed in E18.

D18 must remain static and not update, after any entries or F9 is used.

Thanks in advance.
DC

 

[adulted]

Time Input

In cell F1 I have the following formula =TEXT(HOUR(NOW()),"00")&":"&TEXT(MINUTE(NOW()),"00")&":"&TEXT(SECOND(NOW()),"00") Which displays the current time. Formatted as General.

I would like to enter a number in cell E18, and have D18 Display the time from F1, which auto updates after a number is placed in E18.

D18 must remain static and not update, after any entries or F9 is used.

Thanks in advance.
DC

Hopefully this can be achieved via formula, and not use of Macro's