hi
there is no formula that will display the time that is not volital meaning
that it is keyed to the system clock and will update to the current time each
time the sheet calculates formulas.
the keyboard shortcut Ctrl + Shift + : will insert the current time(system
clock) into a selected cell but that is a manual process.
if that is not what you want, vb is about all that is left.

Regards
FSt1

"karim" wrote:

hi,

i want to create excel sheet wherein time has to be recorded multiple time.
Now() formula does not help and i don't want to use macro.
Pls Suggest