Thread: Calculate the difference between two cell entries using NOW() func
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CZeigler CZeigler is offline
external usenet poster
  
Posts: 1
Default 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?
Reply With QuoteReply With Quote