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



--


Regards,


Peo Sjoblom




"Medic1712" wrote in message
...
I am trying to do something that seems impossible. I am a paramedic and
use
a mobile device during the course of my job. I am trying to write a
spreadsheet that will "time stamp" important times within a run. I have
been
using:
=IF(A3=1,NOW(),"")
I enter a 1 in Column A and the equation is in Column C, but it resets all
time to the same since NOW() is a volatile function. Is there anyway to
overcome this?