Another possibility if you are comfortable with Circular References:

In B1:

=IF(A1="",NOW(),B1)

Press F9 to force a re-calculation before entering data in A1, once data is
entered in A1 whatever was in B1 will stay there.



"karim" wrote in message
...
i want to record start time and end time multiple times on single worksheet
without using macro. Pls suggest any formula for same as =now() does not
help.

karim.


"ozgrid.com" wrote:

????????????????????



--
Regards
Dave Hawley
www.ozgrid.com
"karim" wrote in message
...
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