Data validation formula - base 60

[rgarber1950]

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

[shg]

If you're using the Change event to change the cell value, why not just verify that the last two digits are less than 60 while you're there, i.e.,

Please Login or Register  to view this content.