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

's Computer Specifications

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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use value in cell as numeric reference to a row, within a sum func	=?Utf-8?B?Y3Nwcg==?=	Microsoft Excel Programming	1	17th Aug 2007 02:21 PM
RE: Use value in cell as numeric reference to a row, within a sum func	=?Utf-8?B?Y3Nwcg==?=	Microsoft Excel Programming	0	17th Aug 2007 02:05 AM
formatt to Calculate difference in now() and date in cell,	=?Utf-8?B?R0FSRE5FUkdVWQ==?=	Microsoft Excel Misc	1	27th Apr 2007 04:06 AM
Help pls! Max func to display value of different cell?	Impakt	Microsoft Excel Worksheet Functions	5	12th Feb 2005 04:06 AM
Need func to display a cell + formatting in another cell	=?Utf-8?B?anF1aWV0?=	Microsoft Excel Programming	4	2nd Oct 2004 12:52 AM