Hi Niek

Thanks for your previous suggestion.
I want to freeze the time once it has been filled in A. As David said, with
the current formula the time updates as the sheet is being updated.

Orquidea

"Niek Otten" wrote:

You already have a VBA solution in this thread

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"orquidea" wrote in message ...
| Thanks for your repply.
|
| Exactly. I need the time frozen in A. Would you be able to help me with the
| VBA solution?
|
| Thanks in advanve.
| Orquidea.
|
| "David Biddulph" wrote:
|
| If you want the current date & time in B if A isn't blank, but you want B
| blank if A is blank, then you could change your formula to
| =IF(A1="","",NOW())
| but remember that it will continue to show current date and time each time
| you open or update the sheet.
|
| If you want the value frozen at the time A is filled in, then you'll
| probably need a VBA solution.
| --
| David Biddulph
|
| "orquidea" wrote in message
| ...
| Hi
|
| I want a formula which automaticaly types the current date and time when
| data have been entered in the cell beside. ie.
|
| A B
| DOG =if(A1="",(=NOW()) dd/mm/yy hh:mm
|
| But this one doesn't work.
|
| Could anyone help me please.
|
| Thanks
| Orquidea
|
|
|
|