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

Look he

http://www.mcgimpsey.com/excel/timestamp.html

BTW don't use phrases like "doesn't work"
Wrong answer? what did you expect and what did you get instead?
Error message? What error message?
Don't see results but see formula?
Cells not recalculating?

Please be specific

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

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

And don't use URGENT in the subject, it is likely to do the exact opposite
of its intention and turn people off.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Niek Otten" wrote in message
...
Look he

http://www.mcgimpsey.com/excel/timestamp.html

BTW don't use phrases like "doesn't work"
Wrong answer? what did you expect and what did you get instead?
Error message? What error message?
Don't see results but see formula?
Cells not recalculating?

Please be specific

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

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

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

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

Look at ALL the answers, there is a link in Niek's first answer on how to
implement it

--


Regards,


Peo Sjoblom


"orquidea" wrote in message
...
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
|
|
|
|