Calculate the difference between two cell entries using NOW() func

I'm having some difficulty displaying the time lapsed between cell entries.
I tried using the now function embedded within an if statement but the now
function recalculates everytime I enter something in a new cell giving me an
elapsed time of 0. Is there a way to turn the automatic calculation of the
now function off without turning automatic calculation off for the entire
workbook?

No.

You'll need to find a way to temporarily store the initial time value
(in a cell or a VBA variable) so you can reuse it afterwards. Anyhow,
seems like a VBA job to me.

CZeigler schreef:

> I'm having some difficulty displaying the time lapsed between cell entries.
> I tried using the now function embedded within an if statement but the now
> function recalculates everytime I enter something in a new cell giving me an
> elapsed time of 0. Is there a way to turn the automatic calculation of the
> now function off without turning automatic calculation off for the entire
> workbook?