Hi
I have a worksheet change event macro that converts 1 to 4 digit integers entered into a particular range to hours and minutes. For example: 111 converts to 1:11; 12 converts to 0:12. This works fine - I have been trying to come up with a formula to use in data validation that would restrict user entries to base 60 eg. prevent an entry like 170. or 90 etc.

Thanks for any suggestions.

Richard