Data Validation and Current Time

jkjohnson0723

New Member
Joined
Jun 2, 2015
Messages
3
I am creating a spreadsheet for users to punch in an out after they have completed a task. I need to ensure that these entries are honest. Is there a formula I can use that will ensure a user can only enter the current time in a given cell?
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
when you say punch, how will that operate, whats your concept and limitations
 
Upvote 0
The users will need to insert the current time into a given field. They know they should be using the shortcut (ctrl+shift+;). I want to make sure that the user can not manually enter a non-current time.
 
Upvote 0
you could put this in
Code:
Sub stamper()
On Error Resume Next
Dim LR As Long
Dim lastrow
LR = Sheets("Track").Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Sheets("Track").Range("A" & LR) = Now()
Sheets("Track").Range("B" & LR) = Environ("USERNAME ")
End Sub
 
Upvote 0
I would like to enter a simple formula in the Time tab in the data validation screen. I can do this with a date by entering =TODAY() but it will not let me do it with =NOW()-TRUNC(NOW()).
 
Upvote 0
In the Data Validation criteria, select Allow Time Data that is equal to =TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(0))

1673879590698.png
 
Upvote 0

Forum statistics

Threads
1,214,720
Messages
6,121,136
Members
449,012
Latest member
Lilcps

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top