time stamp but no date

[daveyc18]

i can use =now() but that also gives me the date in front....is there a simple way to only have the time?

 

[Joe4]

You can simply change the format of the cell to only show the time and not the date.
But note that =NOW() is NOT a date/time stamp! It is a volatile formula that will keep changing with each calculation (and each time you open the file).
If you want to "lock in" an actual date/time stamp so that its value does not change once entered, you will need to use VBA (if you want to do it automatically).
A simple Google search on "Excel Time Stamp" will return many threads of this nature.

 

[joeu2004]

Ostensibly, =MOD(NOW(),1) results in just time of day, accurate to the 1/100 second (truncated).

But if you intend to use that value for look-ups and other comparisons, it would be prudent to write:

=--TEXT(NOW(), "h:m:s.000")
or
=--TEXT(NOW(), "h:m:s")

depending on the accuracy that your require. Format the result any way that you wish.