View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Using multiple NOW functions

Hi,

How does the spreadsheet know when the exercise is complete?

You can move to a cell and press Ctrl+Shift+: (control colon) to enter the
current time as a hard coded time.

the NOW function is volatile - which means it recalculates everytime the
speadsheet changes.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Dgwood90" wrote:

Is it possible to use more than one NOW() function in a worksheet? I need to
show the time of when an exercise is completed. There are 3 exercises per
page. At the moment, when you answer one statement, they all change to the
current time.