I'm trying to allow time only for data entry. I want to avoid as much apex and visualforce as possible for this project. I can certainly do it but I'm trying to keep this full configure for this particular project (short of a few triggers).
Would the standard method to create a time field that allows seamless entry be:
- have them enter a text datatype
- then use a validation rule to make sure it's in the correct format
- then use a formula field to parse into a "time" format to subtract the Start and End time
If so, is there a way I can apply a mask to the field to allow ##:## ** entry?
Otherwise, if there's an easier cleaner way, I'm all ears!