=NOW()
formatted to time should change automatically

If this post helps click Yes
---------------
Jacob Skaria


"Cletus" wrote:

I don't need the current time entered. I have varying times and it would be
so much more convenient if we didn't have to manually enter the colon. I
tried formatting the cell but that doesn't work