time help

[lrhodes]

I need to insert key strokes in an "if" formula any help would be greatly appreciated.
I built a phone log with date, time, and name of contact. I need the time column to insert a static time (i.e shift+ctrl+";") if there is no contact name it inserts a "" I just can't figure out how to insert the shift+ctrl+";" (the quotes are so it doesn't show you a smiley face.) into the formula.

[VBA Noob]

Two ways.

One is a macro the other is a circular ref.

Both are explained on the attached link

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

VBA Noob

[lrhodes]

Thanx, the iteration solution works perfectly