Using multiple NOW functions
 

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.

Using multiple NOW functions
 

Hi,
The function Now will give you the actual time this is why they all change

"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.

Using multiple NOW functions
 

If you're wanting time stamps, you'd need to use some type of VBA. Here's an
example that creates a time stamp in column B when you make a change to A1,
A2, or A3. Right click on sheet tab, view code, paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)

'What ranges are you watching?
If Intersect(Target, Range("a1")) Is Nothing And _
Intersect(Target, Range("a2")) Is Nothing And _
Intersect(Target, Range("a3")) Is Nothing Then
Exit Sub

End If

'First number is how many rows to offset
'Second number is how many columns
Target.Offset(0, 1).Value = Now

End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eduardo" wrote:

Hi,
The function Now will give you the actual time this is why they all change

"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.

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.