If formula - URGENT

[orquidea]

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

 

[Niek Otten]

Look here:

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

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

 

[David Biddulph]

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.

 

[Bob Phillips]

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)

 

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

 

[Niek Otten]

You already have a VBA solution in this thread

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

 

[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

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom