On Feb 10, 6:29 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
You would need NOW().
TODAY() gives zero time on the current day.
--
David Biddulph

"Michael.Tarnowski" wrote in message

...

To clarify my posting: I want to use a time stamping mechanism by
using a circular definition

=IF(D10=0;NOW();D10)

the point is: when should I use NOW() and when TODAY() to get a
timestamp like 10.Feb.2009 15:45 (actual dates and times)?

Michael

Michael.Tarnowski wrote:
Hi community,

in excel help I found the information

TODAY():
"Returns the serial number of the current date. The serial number is
the date-time code used by Microsoft Excel for date and time
calculations. If the cell format was General before the function was
entered, the result is formatted as a date."

NOW():
"Returns the serial number of the current date and time. If the cell
format was General before the function was entered, the result is
formatted as a date.
...
The NOW function changes only when the worksheet is calculated or when
a macro that contains the function is run. It is not updated
continuously. "

I have a cell formatted as TT. MMM JJ, hh:mm ;;

when I copy-n-paste a cell showing NOW() I get the current time but an
older date; when I copy-n-paste a cell showing today() I get the
current date but the time 00:00.
I want to have after copy-n-pasting the current date and the current
time. Do I have to force a re-calculation (F9) or calculate in VBA?

Michael

Thanks David, you affirmed my experiments
Michael