Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple functions, conditional functions | Excel Worksheet Functions | |||
Multiple if functions with sum | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Multiple functions | Excel Worksheet Functions | |||
How do I use multiple functions? | Excel Worksheet Functions |