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
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