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