This is for a employee time sheet. There are multiple employees who need to enter their Hours Worked in [h]:mm format.
Criteria:
1. Limit users into entering time only in [h]:mm format.
2. Limit users into entering min of 0 to max of 10 hours ( I use named range such as Thursday_AM_Shift_Length)
3. Limit users into entering HH:MM to avoid the error of entering 7h40min as "7:4" which produces 7:04....
Currently I've satisfied #1 & #2. #1 by having a pop-up note and #2 by having the validation criteria set to allow: time, data: between, start: 12:00:00 AM, End: =Thursday_AM_Shift_Length.
How can I satisfy #3? Can I combine the named range End Time by using =And( and Len()?
validation.PNG
Bookmarks