Time question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when the user inputs data into cell C8 I want the current time to be
displayed in cell D8, and remain there without changing value, so if the user
inputs the number1 into cell C8 the time 17:00 is shown in cell D8, and from
that moment on it does not change.

Can this be done, if so any ideas??

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

variable question 3
Date Calculations as Days 6
Can I add more than 2 comparisons to an IF statement?? 3
Formula for showing warnings when cells are out of range. 1
Forcing the completion of a particular cell 3
I need the cell to be blank instead of showing #DIV/0! 5
Please Help with Macro Code 1
copy/paste from one file to another without file name reference 4

Back
Top