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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Minutes elapset between two cells 4
Difference between NOW() and TODAY() 9
Calculating Problem: Desperate :( 4
Time elapsed calculation 6
Cell =Now() << Can I get this to auto-update? 2
How to calculate the difference between two different times. 1
How to calculate the difference between two different times. 1
Calculate the difference between two times and show dd:hh:mm:ss 7

Back
Top